select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range in (1,2,3,4) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,tj.fanli_sort desc,sj.pfstype,count desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range in (1,2,3,4) group by t.id order by t.is_hot desc,c.admin_youxuan desc,c.area_youxuan desc,tj.youxuan_sort desc,sj.pfstype,t.update_time desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range in (1,2,3,4) group by t.id order by t.is_hot desc,c.admin_recommend desc,c.area_recommend desc,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range=1 and (match(area_match) against('fanwe_beijing' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range=1 and (match(area_match) against('fanwe_neimenggu' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range=1 and (match(area_match) against('fanwe_jiangsu' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range=1 and (match(area_match) against('fanwe_fujian' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range=1 and (match(area_match) against('fanwe_shandong' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range=1 and (match(area_match) against('fanwe_hainan' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range=2 and (match(area_match) against('fanwe_gangaotai' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range=2 and (match(area_match) against('fanwe_haidaoyou' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range=2 and (match(area_match) against('fanwe_hanguo' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range=2 and (match(area_match) against('fanwe_riben' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range=2 and (match(area_match) against('fanwe_taiguo' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and t.tour_range=2 and (match(area_match) against('fanwe_aozhou' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and (t.tour_range=3 or t.tour_range=4) and (match(area_match) against('fanwe_linyi' IN BOOLEAN MODE) or match(area_match) against('fanwe_qinqingyimeng' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and (t.tour_range=3 or t.tour_range=4) and (match(area_match) against('fanwe_weifang' IN BOOLEAN MODE) or match(area_match) against('fanwe_huaxialongcheng' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and (t.tour_range=3 or t.tour_range=4) and (match(area_match) against('fanwe_heze' IN BOOLEAN MODE) or match(area_match) against('fanwe_taian' IN BOOLEAN MODE) or match(area_match) against('fanwe_jining' IN BOOLEAN MODE) or match(area_match) against('fanwe_liaocheng' IN BOOLEAN MODE) or match(area_match) against('fanwe_shuihuguli' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and (t.tour_range=3 or t.tour_range=4) and (match(area_match) against('fanwe_qingdao' IN BOOLEAN MODE) or match(area_match) against('fanwe_yantai' IN BOOLEAN MODE) or match(area_match) against('fanwe_weihao' IN BOOLEAN MODE) or match(area_match) against('fanwe_rizhao' IN BOOLEAN MODE) or match(area_match) against('fanwe_xianjinghaian' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and (t.tour_range=3 or t.tour_range=4) and (match(area_match) against('fanwe_jinan' IN BOOLEAN MODE) or match(area_match) against('fanwe_quanchengjinan' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and (t.tour_range=3 or t.tour_range=4) and (match(area_match) against('fanwe_taian' IN BOOLEAN MODE) or match(area_match) against('fanwe_pingantaishan' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7select t.price_explain,t.is_rebate, t.id,t.image,t.city_id,t.brief,t.price,t.tour_total_day,t.origin_price,t.name ,t.short_name,t.supplier_id,t.duotu,cf.name as cfname ,sj.is_store,count(o.tourline_id) as count from (select * from fanwe_tourline where is_effect=1 ) t left join fanwe_tourline_order o on t.id = o.tourline_id join fanwe_supplier_tourline st on st.tourline_id = t.id and st.supplier_id=2766 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_yantai' inner join fanwe_tour_city as cf on cf.id=t.city_id join fanwe_supplier as sj on t.supplier_id=sj.id left join fanwe_tourline_supplier_tj tj on tj.tourline_id = t.id and (tj.supplier_id=2766 or tj.supplier_id=2767) where t.is_effect=1 and st.is_effect=1 and (t.tour_range=3 or t.tour_range=4) and (match(area_match) against('fanwe_linyi' IN BOOLEAN MODE) or match(area_match) against('fanwe_qinqingyimeng' IN BOOLEAN MODE)) group by t.id order by t.is_hot desc,c.admin_fanli desc,c.area_fanli desc,c.admin_youxuan desc,c.area_youxuan desc,c.admin_recommend desc,c.area_recommend desc,tj.fanli_sort desc,tj.youxuan_sort,tj.sort desc,sj.pfstype,t.id desc limit 0,7
烟台中国国旅高燕飞--烟台中国旅行社、海量线路想去哪里点哪里
