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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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=1951 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_zibo' 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=1951 or tj.supplier_id=4300) 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
¥309起 已售
¥1099起 已售
¥859起 已售
龙园凤栖度假酒店 ¥329起
汉庭酒店临沭县 ¥319起
压油沟麦山小院 ¥699起
沂水竹园春风·见南山 ¥989起
¥14800起 临沂出发
¥2980起 徐州出发
¥1880起 青岛出发
韩国双飞四日机票签证-青岛起止
¥1780起
韩国单团签
¥800起
云之蓝-洱海东与西—昆明-大理-丽江双飞6天5晚纯玩游
¥2980起
【纯自由行系列-不进免税】韩国双飞五自由行升级酒店
¥2980起
¥2980起 徐州出发
¥14800起 临沂出发

2025全陪班<10月大美重庆>仙女山大草原、天生三桥、濯水古镇、蒲花暗河、阿蓬江神龟峡 、觉心之境、白公馆、磁器口古镇、李子坝轻轨穿楼、解放碑、洪崖洞景区双飞5日游
¥1599起 临沂出发
全景西葡9晚12天
¥23800起
韩国单团签
¥800起
韩国双飞五日机票签证-青岛起止
¥1880起
【纯自由行系列-不进免税】韩国双飞四自由行酒店升级
¥6000起
¥2980起 徐州出发
¥14800起 临沂出发
¥23800起 北京出发
欧韵山海11天 ¥17888起
鲸彩·斯里兰卡7天5晚 ¥14680起
2025全陪班<10月大美重庆>仙女山大草原、天生三桥、濯水古镇、蒲花暗河、阿蓬江神龟峡 、觉心之境、白公馆、磁器口古镇、李子坝轻轨穿楼、解放碑、洪崖洞景区双飞5日游
¥1599起
韩国去程机票+签证-青岛起止(10天内均可) ¥1199起
