临沂旅游百事通通达路门市--临沂百事通旅行社、海量线路想去哪里点哪里

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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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=65 join fanwe_tourline_city c on t.id=c.tourline_id and c.is_effect=1 and c.city_py='fanwe_linyi' 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=65 or tj.supplier_id=46) 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 临沂旅游百事通通达路门市--临沂百事通旅行社、海量线路想去哪里点哪里

商家登录 | 全国旅游投诉

周边门票 更多>>

泰盛广场摩天轮

泰盛广场摩天轮

¥0.02起已售

热门线路 更多>>

【精品纯玩-纯净迪士尼】走进上海交通大学+上海迪士尼乐园+上海南京路.外滩三日

【精品纯玩-纯净迪士尼】走进上海交通大学+上海迪士尼乐园+上海南京路.外滩三日

¥1499起临沂出发
【鹭岛厦门】厦门鼓浪屿、云水谣土楼、南普陀、集美学村、胡里山炮台纯玩双飞6日游

【鹭岛厦门】厦门鼓浪屿、云水谣土楼、南普陀、集美学村、胡里山炮台纯玩双飞6日游

¥1999起临沂出发
【特惠喜来登】西双版纳4晚5日游18人散拼小包

【特惠喜来登】西双版纳4晚5日游18人散拼小包

¥2980起徐州出发
【熊猫斗恐龙】常州恐龙园+淹城野生动物园+迪诺水镇纯玩三日 ¥899起

全季-纯玩南京一地两日游 ¥399起

元旦"小资江南"苏州、杭州、上海+乌镇纯玩3日游 ¥650起

元旦：南京扬州两日游 ¥499起

优选线路 更多>>

【精品纯玩-纯净迪士尼】走进上海交通大学+上海迪士尼乐园+上海南京路.外滩三日

【精品纯玩-纯净迪士尼】走进上海交通大学+上海迪士尼乐园+上海南京路.外滩三日

¥1499起临沂出发
【熊猫斗恐龙】常州恐龙园+淹城野生动物园+迪诺水镇纯玩三日

【熊猫斗恐龙】常州恐龙园+淹城野生动物园+迪诺水镇纯玩三日

¥899起临沂出发
【特惠喜来登】西双版纳4晚5日游18人散拼小包

【特惠喜来登】西双版纳4晚5日游18人散拼小包

¥2980起徐州出发
【鹭岛厦门】厦门鼓浪屿、云水谣土楼、南普陀、集美学村、胡里山炮台纯玩双飞6日游 ¥1999起

半卧·【大愿九华山】·3日 ¥599起

全景西葡9晚12天 ¥23800起

普陀山双飞三日游 ¥1480起

推荐线路 更多>>

【特惠喜来登】西双版纳4晚5日游18人散拼小包

【特惠喜来登】西双版纳4晚5日游18人散拼小包

¥2980起徐州出发
【鹭岛厦门】厦门鼓浪屿、云水谣土楼、南普陀、集美学村、胡里山炮台纯玩双飞6日游

【鹭岛厦门】厦门鼓浪屿、云水谣土楼、南普陀、集美学村、胡里山炮台纯玩双飞6日游

¥1999起临沂出发
【熊猫斗恐龙】常州恐龙园+淹城野生动物园+迪诺水镇纯玩三日

【熊猫斗恐龙】常州恐龙园+淹城野生动物园+迪诺水镇纯玩三日

¥899起临沂出发
【精品纯玩-纯净迪士尼】走进上海交通大学+上海迪士尼乐园+上海南京路.外滩三日 ¥1499起

全景西葡9晚12天 ¥23800起

2025年12月临沂直飞三亚-嗨爆海南5天4晚 ¥2580起

【元旦计划★临沂自组班】【盛世京城】北京纯玩高铁3日（临沂成团，全程导游陪同，全程升级准四或三钻标准住宿） ¥1980起

山东旅游 儒风运河水浒故里黄河入海亲情沂蒙更多>>

齐鲁游【12月费县】天蒙山+小调诞生地1日游

齐鲁游【12月费县】天蒙山+小调诞生地1日游

¥99起临沂出发
齐鲁游【12月份-自驾拼团】费县天蒙+沂蒙山小调演出39.9元

齐鲁游【12月份-自驾拼团】费县天蒙+沂蒙山小调演出39.9元

¥39.9起临沂出发

国内旅游 北京内蒙古江苏福建山东海南更多>>

【元旦计划★临沂自组班】【盛世京城】北京纯玩高铁3日（临沂成团，全程导游陪同，全程升级准四或三钻标准住宿）

【元旦计划★临沂自组班】【盛世京城】北京纯玩高铁3日（临沂成团，全程导游陪同，全程升级准四或三钻标准住宿）

¥1980起临沂出发
【去远行12月全陪班】【盛世京城】北京双高/单高单飞品质四日游（全陪班一价全含纯玩团）

【去远行12月全陪班】【盛世京城】北京双高/单高单飞品质四日游（全陪班一价全含纯玩团）

¥1980起临沂出发
【去远行12月计划】【16成人精品团】【京希为贵】北京双高纯玩4日游（一价全含，真纯玩0暗店0自费）

【去远行12月计划】【16成人精品团】【京希为贵】北京双高纯玩4日游（一价全含，真纯玩0暗店0自费）

¥2980起临沂出发
【去远行12月计划】【16成人VIP精品团】【魅力皇城】北京双高4日游（一价全含纯玩，二、三环延线三钻/四钻酒店 ¥2580起

【去远行12月计划】【安心慢慢游】北京双高铁品质纯玩双高4日游（一价全含，真纯玩） ¥1980起

【去远行12月计划】【超级休闲】北京双高精品4日游（一价全含，连锁住宿，临沂起止） ¥1680起

周边旅游 临沂潍坊菏泽青岛济南泰安更多>>

齐鲁游【12月费县】天蒙山+小调诞生地1日游

齐鲁游【12月费县】天蒙山+小调诞生地1日游

¥99起临沂出发
齐鲁游【12月份-自驾拼团】费县天蒙+沂蒙山小调演出39.9元

齐鲁游【12月份-自驾拼团】费县天蒙+沂蒙山小调演出39.9元

¥39.9起临沂出发

热门线路排行

1 韩国双飞五日机票签证-青岛起止 ¥1880起 62人预定
2 韩国双飞四日机票签证-青岛起止 ¥1780起 35人预定
3 韩国单团签 ¥800起 13人预定
4 云之蓝-洱海东与西—昆明-大理-丽江双飞… ¥2980起 10人预定
5 韩国去程机票+签证-青岛起止（10天内均… ¥1199起 5人预定
6 【半自由行订制系列】百乐游玩转韩国五日游… ¥3980起 2人预定
7 【玩转韩国-半自由行订制】百乐游玩转韩国… ¥3680起 2人预定

在线咨询

董倩倩

董倩倩
商家手机：18660962591
商家电话：0539-8020267
关注商家微信

TOP