SELECT `S`.`shopid` AS `shopdata.shopid`,`S`.`account` AS `shopdata.account`,`S`.`name` AS `shopdata.name`,`S`.`min_price` AS `shopdata.min_price`,`S`.`listtitle` AS `shopdata.listtitle`,`S`.`com` AS `shopdata.com`,`S`.`thumbimg` AS `shopdata.thumbimg`,`S`.`min_price` AS `shopdata.min_price`,`S`.`min_time` AS `shopdata.min_time`,`S`.`base` AS `shopdata.base`,`S`.`carfare` AS `shopdata.carfare`,`S`.`tel` AS `shopdata.tel`, `S`.`plan` AS `shopdata.plan`,`S`.`coupon` AS `shopdata.coupon`, `A`.`name` AS `area.name` FROM `shopdata` AS `S` LEFT JOIN `shop_area_rels` AS `AR` ON `AR`.`shopid`=`S`.`shopid` AND `AR`.`priority`='1' LEFT JOIN (SELECT MAX(`created`) AS `blog.created` FROM `blog` GROUP BY `shopid`) AS `blog2` AS `B` ON `B`.`shopid`=`S`.`shopid`LEFT JOIN `areas` AS `A` ON `A`.`left`=`AR`.`area_left` WHERE `S`.`hyoji`='1' AND EXISTS (SELECT * FROM `shop_area_rels` AS `R` WHERE `R`.`area_left` BETWEEN '9' AND '10' AND `R`.`shopid`=`S`.`shopid` AND `R`.`priority`='1') AND `S`.`plan`='13' ORDER BY `S`.`order` DESC LIMIT 0,200SELECT `S`.`shopid` AS `shopdata.shopid`,`S`.`account` AS `shopdata.account`,`S`.`name` AS `shopdata.name`,`S`.`min_price` AS `shopdata.min_price`,`S`.`listtitle` AS `shopdata.listtitle`,`S`.`com` AS `shopdata.com`,`S`.`thumbimg` AS `shopdata.thumbimg`,`S`.`min_price` AS `shopdata.min_price`,`S`.`min_time` AS `shopdata.min_time`,`S`.`base` AS `shopdata.base`,`S`.`carfare` AS `shopdata.carfare`,`S`.`tel` AS `shopdata.tel`, `S`.`plan` AS `shopdata.plan`,`S`.`coupon` AS `shopdata.coupon`, `A`.`name` AS `area.name` FROM `shopdata` AS `S` LEFT JOIN `shop_area_rels` AS `AR` ON `AR`.`shopid`=`S`.`shopid` AND `AR`.`priority`='1' LEFT JOIN (SELECT MAX(`created`) AS `blog.created` FROM `blog` GROUP BY `shopid`) AS `blog2` AS `B` ON `B`.`shopid`=`S`.`shopid`LEFT JOIN `areas` AS `A` ON `A`.`left`=`AR`.`area_left` WHERE `S`.`hyoji`='1' AND EXISTS (SELECT * FROM `shop_area_rels` AS `R` WHERE `R`.`area_left` BETWEEN '9' AND '10' AND `R`.`shopid`=`S`.`shopid` AND `R`.`priority`<>'1') AND NOT EXISTS (SELECT * FROM `shop_area_rels` AS `R` WHERE `R`.`area_left` BETWEEN '9' AND '10' AND `R`.`shopid`=`S`.`shopid` AND `R`.`priority`='1') AND `S`.`plan`='13' ORDER BY `S`.`order` DESC LIMIT 0,200SELECT `S`.`shopid` AS `shopdata.shopid`,`S`.`account` AS `shopdata.account`,`S`.`name` AS `shopdata.name`,`S`.`min_price` AS `shopdata.min_price`,`S`.`listtitle` AS `shopdata.listtitle`,`S`.`com` AS `shopdata.com`,`S`.`thumbimg` AS `shopdata.thumbimg`,`S`.`min_price` AS `shopdata.min_price`,`S`.`min_time` AS `shopdata.min_time`,`S`.`base` AS `shopdata.base`,`S`.`carfare` AS `shopdata.carfare`,`S`.`tel` AS `shopdata.tel`, `S`.`plan` AS `shopdata.plan`,`S`.`coupon` AS `shopdata.coupon`, `A`.`name` AS `area.name` FROM `shopdata` AS `S` LEFT JOIN `shop_area_rels` AS `AR` ON `AR`.`shopid`=`S`.`shopid` AND `AR`.`priority`='1' LEFT JOIN (SELECT MAX(`created`) AS `blog.created` FROM `blog` GROUP BY `shopid`) AS `blog2` AS `B` ON `B`.`shopid`=`S`.`shopid`LEFT JOIN `areas` AS `A` ON `A`.`left`=`AR`.`area_left` WHERE `S`.`hyoji`='1' AND EXISTS (SELECT * FROM `shop_area_rels` AS `R` WHERE `R`.`area_left` BETWEEN '9' AND '10' AND `R`.`shopid`=`S`.`shopid` AND `R`.`priority`='1') AND `S`.`plan`='11' ORDER BY `S`.`order` DESC LIMIT 0,200SELECT `S`.`shopid` AS `shopdata.shopid`,`S`.`account` AS `shopdata.account`,`S`.`name` AS `shopdata.name`,`S`.`min_price` AS `shopdata.min_price`,`S`.`listtitle` AS `shopdata.listtitle`,`S`.`com` AS `shopdata.com`,`S`.`thumbimg` AS `shopdata.thumbimg`,`S`.`min_price` AS `shopdata.min_price`,`S`.`min_time` AS `shopdata.min_time`,`S`.`base` AS `shopdata.base`,`S`.`carfare` AS `shopdata.carfare`,`S`.`tel` AS `shopdata.tel`, `S`.`plan` AS `shopdata.plan`,`S`.`coupon` AS `shopdata.coupon`, `A`.`name` AS `area.name` FROM `shopdata` AS `S` LEFT JOIN `shop_area_rels` AS `AR` ON `AR`.`shopid`=`S`.`shopid` AND `AR`.`priority`='1' LEFT JOIN (SELECT MAX(`created`) AS `blog.created` FROM `blog` GROUP BY `shopid`) AS `blog2` AS `B` ON `B`.`shopid`=`S`.`shopid`LEFT JOIN `areas` AS `A` ON `A`.`left`=`AR`.`area_left` WHERE `S`.`hyoji`='1' AND EXISTS (SELECT * FROM `shop_area_rels` AS `R` WHERE `R`.`area_left` BETWEEN '9' AND '10' AND `R`.`shopid`=`S`.`shopid` AND `R`.`priority`<>'1') AND NOT EXISTS (SELECT * FROM `shop_area_rels` AS `R` WHERE `R`.`area_left` BETWEEN '9' AND '10' AND `R`.`shopid`=`S`.`shopid` AND `R`.`priority`='1') AND `S`.`plan`='11' ORDER BY `S`.`order` DESC LIMIT 0,200SELECT `S`.`shopid` AS `shopdata.shopid`,`S`.`account` AS `shopdata.account`,`S`.`name` AS `shopdata.name`,`S`.`min_price` AS `shopdata.min_price`,`S`.`listtitle` AS `shopdata.listtitle`,`S`.`com` AS `shopdata.com`,`S`.`thumbimg` AS `shopdata.thumbimg`,`S`.`min_price` AS `shopdata.min_price`,`S`.`min_time` AS `shopdata.min_time`,`S`.`base` AS `shopdata.base`,`S`.`carfare` AS `shopdata.carfare`,`S`.`tel` AS `shopdata.tel`, `S`.`plan` AS `shopdata.plan`,`S`.`coupon` AS `shopdata.coupon`, `A`.`name` AS `area.name` FROM `shopdata` AS `S` LEFT JOIN `shop_area_rels` AS `AR` ON `AR`.`shopid`=`S`.`shopid` AND `AR`.`priority`='1' LEFT JOIN (SELECT MAX(`created`) AS `blog.created` FROM `blog` GROUP BY `shopid`) AS `blog2` AS `B` ON `B`.`shopid`=`S`.`shopid`LEFT JOIN `areas` AS `A` ON `A`.`left`=`AR`.`area_left` WHERE `S`.`hyoji`='1' AND EXISTS (SELECT * FROM `shop_area_rels` AS `R` WHERE `R`.`area_left` BETWEEN '9' AND '10' AND `R`.`shopid`=`S`.`shopid` AND `R`.`priority`='1') AND `S`.`plan`='0' ORDER BY `S`.`order` DESC LIMIT 0,10SELECT `S`.`shopid` AS `shopdata.shopid`,`S`.`account` AS `shopdata.account`,`S`.`name` AS `shopdata.name`,`S`.`min_price` AS `shopdata.min_price`,`S`.`listtitle` AS `shopdata.listtitle`,`S`.`com` AS `shopdata.com`,`S`.`thumbimg` AS `shopdata.thumbimg`,`S`.`min_price` AS `shopdata.min_price`,`S`.`min_time` AS `shopdata.min_time`,`S`.`base` AS `shopdata.base`,`S`.`carfare` AS `shopdata.carfare`,`S`.`tel` AS `shopdata.tel`, `S`.`plan` AS `shopdata.plan`,`S`.`coupon` AS `shopdata.coupon`, `A`.`name` AS `area.name` FROM `shopdata` AS `S` LEFT JOIN `shop_area_rels` AS `AR` ON `AR`.`shopid`=`S`.`shopid` AND `AR`.`priority`='1' LEFT JOIN (SELECT MAX(`created`) AS `blog.created` FROM `blog` GROUP BY `shopid`) AS `blog2` AS `B` ON `B`.`shopid`=`S`.`shopid`LEFT JOIN `areas` AS `A` ON `A`.`left`=`AR`.`area_left` WHERE `S`.`hyoji`='1' AND EXISTS (SELECT * FROM `shop_area_rels` AS `R` WHERE `R`.`area_left` BETWEEN '9' AND '10' AND `R`.`shopid`=`S`.`shopid` AND `R`.`priority`<>'1') AND NOT EXISTS (SELECT * FROM `shop_area_rels` AS `R` WHERE `R`.`area_left` BETWEEN '9' AND '10' AND `R`.`shopid`=`S`.`shopid` AND `R`.`priority`='1') AND `S`.`plan`='0' ORDER BY `S`.`order` DESC LIMIT 0,10