库俪--临沂国际旅行社、海量线路想去哪里点哪里

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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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=64 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=64 or tj.supplier_id=37) 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起

国旅自组团 更多>>

国旅自组团——老挝、琅勃拉邦、万荣、万象双飞三动8日游（徐州直飞西双版纳，行者的乌托邦·东南亚的最后佛国盲盒）

国旅自组团——老挝、琅勃拉邦、万荣、万象双飞三动8日游（徐州直飞西双版纳，行者的乌托邦·东南亚的最后佛国盲盒）

¥3980起临沂出发
#特价#【国旅自组团】新加坡、马来西亚七日游（旅行金立减400）

#特价#【国旅自组团】新加坡、马来西亚七日游（旅行金立减400）

¥4280起临沂出发
半卧-【爆款北京】恭王府+天坛公园+八达岭长城+故宫+颐和园+抗日战争纪念馆+什刹海风光带纯玩四日

半卧-【爆款北京】恭王府+天坛公园+八达岭长城+故宫+颐和园+抗日战争纪念馆+什刹海风光带纯玩四日

¥799起临沂出发
【空包游北京】恭王府+天坛公园+八达岭长城+颐和园+故宫+什刹海风光带+航博纯玩四日 ¥499起

半卧-【五台佛佑·金榜祈愿之旅】五台山八大寺庙·善财洞·五爷庙许财愿·文殊菩萨求学业祈福纳智三日 ¥799起

半卧-【秦唐盛世】古都西安·洛阳+兵马俑+白鹿原影视城+张学良公馆+大唐不夜城+美食体验回民街·永兴坊+洛邑古城经典纯玩四日 ¥599起

半卧-【全景山西】山西精华景点从北到南纯玩六日 ¥999起

优选线路 更多>>

国旅自组团——老挝、琅勃拉邦、万荣、万象双飞三动8日游（徐州直飞西双版纳，行者的乌托邦·东南亚的最后佛国盲盒）

国旅自组团——老挝、琅勃拉邦、万荣、万象双飞三动8日游（徐州直飞西双版纳，行者的乌托邦·东南亚的最后佛国盲盒）

¥3980起临沂出发
#特价#【国旅自组团】新加坡、马来西亚七日游（旅行金立减400）

#特价#【国旅自组团】新加坡、马来西亚七日游（旅行金立减400）

¥4280起临沂出发
大巴/半卧-【杭州半自由行】沉浸式四星嗨玩三日（含乌镇+夜游西塘）

大巴/半卧-【杭州半自由行】沉浸式四星嗨玩三日（含乌镇+夜游西塘）

¥899起临沂出发
大巴/半卧-【姑苏往事】轻奢小资半自由行纯玩三日（水乡周庄·祈财运+同里·退思园+诗里江南·寒山寺·枫桥+平江路） ¥799起

大巴/半卧-【深入魔都】轻奢小资上海三日（朱家角古镇+泰晤士小镇+登金茂大厦+走进上海交通大学+南京路.外滩） ¥799起

半卧-【四星泰扬】扬州瘦西湖+李中水上森林（含竹筏）+溱湖湿地公园（含船）+溱潼古镇纯玩三日 ¥850起

大巴/半卧-【南扬泰美丽】扬州瘦西湖+大报恩寺+中山陵+夜游凤城河+泰州老街纯玩三日 ¥750起

推荐线路 更多>>

#特价#【国旅自组团】新加坡、马来西亚七日游（旅行金立减400）

#特价#【国旅自组团】新加坡、马来西亚七日游（旅行金立减400）

¥4280起临沂出发
国旅自组团——老挝、琅勃拉邦、万荣、万象双飞三动8日游（徐州直飞西双版纳，行者的乌托邦·东南亚的最后佛国盲盒）

国旅自组团——老挝、琅勃拉邦、万荣、万象双飞三动8日游（徐州直飞西双版纳，行者的乌托邦·东南亚的最后佛国盲盒）

¥3980起临沂出发
国旅自组团----越南河内双飞五天（济南直飞河内）

国旅自组团----越南河内双飞五天（济南直飞河内）

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

好客自组-德法意瑞比荷6国12日游（东航上海直飞，含联运） ¥14800起

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

半卧-【禅行普陀】普陀山祈福（普济寺+紫竹林+法雨寺/善财洞）四星品质三日 ¥599起

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

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

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

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

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

¥39.9起临沂出发

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

半卧-【爆款北京】恭王府+天坛公园+八达岭长城+故宫+颐和园+抗日战争纪念馆+什刹海风光带纯玩四日

半卧-【爆款北京】恭王府+天坛公园+八达岭长城+故宫+颐和园+抗日战争纪念馆+什刹海风光带纯玩四日

¥799起临沂出发
半卧-【爸妈游延安】红色延安+古都西安+人文山西纯玩五日

半卧-【爸妈游延安】红色延安+古都西安+人文山西纯玩五日

¥799起临沂出发
半卧-【爸妈上京城住五环】畅玩北京一价全含四日

半卧-【爸妈上京城住五环】畅玩北京一价全含四日

¥899起临沂出发
【空包游北京】恭王府+天坛公园+八达岭长城+颐和园+故宫+什刹海风光带+航博纯玩四日 ¥499起

【二环·五星帝都】精选轻奢房丨2大自助餐丨纯净北京三日游 ¥1150起

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

2026年元旦【逸品帝都】北京双高3日游 ¥1980起

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

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

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

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

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

¥39.9起临沂出发

热门线路排行

1 全季-纯玩南京一地两日游 ¥399起 237人预定
2 “夜宿普陀山”半卧大巴3日游 ¥699起 151人预定
3 元旦"小资江南"苏州… ¥650起 86人预定
4 元旦：南京扬州两日游 ¥499起 86人预定
5 韩国双飞五日机票签证-青岛起止 ¥1880起 62人预定
6 半卧-【爆款北京】恭王府+天坛公园+八达… ¥799起 54人预定
7 花漾南京-sk ¥399起 51人预定
8 泰安方特一日游-sk ¥168起 48人预定
9 【空包游北京】恭王府+天坛公园+八达岭长… ¥499起 44人预定

在线咨询

库俪

库俪
商家手机：13869981159
商家电话：0539-4228369
关注商家微信

TOP