Notice: Undefined index: HTTP_REFERER in /var/www/gapyear.com/www/includes/Utils_new.cls.php on line 2339
SELECT DISTINCT SQL_CALC_FOUND_ROWS p.* FROM products_full p LEFT JOIN keywords_product_link kpl ON p.`id`=kpl.product_id LEFT JOIN `keywords` k ON kpl.keyword_id=k.id JOIN `products_countries_link` AS `pcl` ON `p`.`id`=`pcl`.`productid` JOIN `company_list` AS `cl` ON `p`.`company`=`cl`.`name` WHERE p.status_flag = 'active' AND pcl.countrycode='CN' AND cl.name='Vodkatrain' AND cl.status='active' AND k.keyword IN ('Train Pass','Bus, Plane, Train & Cars','Travel Planning') GROUP BY p.id HAVING GROUP_CONCAT(':',k.keyword,':') like '%:Train Pass:%' AND GROUP_CONCAT(':',k.keyword,':') like '%:Bus, Plane, Train & Cars:%' AND GROUP_CONCAT(':',k.keyword,':') like '%:Travel Planning:%' ORDER BY p.priority_flag DESC,p.sorder LIMIT 0, 10