Notice: Undefined index: HTTP_REFERER in /var/www/gapyear.com/www/includes/Utils_new.cls.php on line 2314
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` WHERE p.status_flag = 'active' AND pcl.countrycode='NZ' AND k.keyword IN ('Ski, Snow & Chalet Work','Things To Do') GROUP BY p.id HAVING GROUP_CONCAT(':',k.keyword,':') like '%:Ski, Snow & Chalet Work:%' AND GROUP_CONCAT(':',k.keyword,':') like '%:Things To Do:%' ORDER BY p.priority_flag DESC,p.sorder LIMIT 0, 10