A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IS NULL AND `tbl_viator_activity`.`VIATOR_DEST_ID` = '24558' AND `tbl_viator_...' at line 6

SELECT `tbl_viator_activity`.`ID`, `tbl_viator_activity`.`NAME`, `tbl_viator_activity`.`PRICE`, `tbl_viator_activity`.`VIATOR_URL`, `tbl_viator_activity`.`REVIEW_RATING` as `REVIEWS`, `tbl_viator_activity`.`REVIEW_COUNT`, `tbl_viator_activity`.`VIATOR_IMAGE_URL`, `tbl_viator_activity`.`DURATION`, `tbl_viator_activity`.`WHAT_IS_IT` as `description`, `CITY_TOURS`.`SM_WHAT_IS_IT`, `CITY_TOURS`.`SM_WHAT_WILL_DO`, `CITY_TOURS`.`SM_WHAT_INCLUDES`, `CITY_TOURS`.`SM_TRAVELLERS_TALK`, `CITY_TOURS`.`SM_IS_IT_RIGHT_FOR_ME`, `tbl_viator_activity`.`VIATOR_PRODUCT_ID`, `tbl_viator_activity`.`CITY`, `CITY_TOURS`.`TOUR_ID`, `tbl_viator_activity`.`SEARCH_DURATION`, `tbl_viator_activity`.`RANK`, `tbl_viator_activity`.`VIATOR_DEST_ID`, 'Y' as is_tripindicator, `tbl_viator_activity`.`REVIEW_COUNT`, `tbl_viator_activity`.`REVIEW_RATING`, `tbl_viator_activity`.`VIATOR_TOUR_ID` as `viatorTourId`, GROUP_CONCAT( SUPPLIERS.SUPPLIER_NAME SEPARATOR ', ') as supplier_name, GROUP_CONCAT( SUPPLIERS.SUPPLIER_PRICE SEPARATOR ', ') as supplier_price, GROUP_CONCAT( SUPPLIERS.SUPPLIER_URL SEPARATOR ', ') as supplier_url FROM `tbl_viator_activity` RIGHT JOIN `CITY_TOURS` ON `CITY_TOURS`.`VIATOR_PRODUCT_ID`=`tbl_viator_activity`.`VIATOR_PRODUCT_ID` JOIN `tbl_destination` ON `tbl_viator_activity`.`VIATOR_DEST_ID` = `tbl_destination`.`destination_id` JOIN `SUPPLIERS` ON `SUPPLIERS`.`VIATOR_PRODUCT_ID` = `tbl_viator_activity`.`VIATOR_PRODUCT_ID` WHERE IS NULL AND `tbl_viator_activity`.`VIATOR_DEST_ID` = '24558' AND `tbl_viator_activity`.`PRODUCT_STATUS` = 'Y' AND `SUPPLIERS`.`SUPPLIER_PRICE` >0 GROUP BY `tbl_viator_activity`.`VIATOR_PRODUCT_ID` UNION SELECT `tbl_viator_activity`.`ID`, `tbl_viator_activity`.`NAME`, `tbl_viator_activity`.`PRICE`, `tbl_viator_activity`.`VIATOR_URL`, `tbl_viator_activity`.`REVIEW_RATING` as `REVIEWS`, `tbl_viator_activity`.`REVIEW_COUNT`, `tbl_viator_activity`.`VIATOR_IMAGE_URL`, `tbl_viator_activity`.`DURATION`, `tbl_viator_activity`.`WHAT_IS_IT` as `description`, `CITY_TOURS`.`SM_WHAT_IS_IT`, `CITY_TOURS`.`SM_WHAT_WILL_DO`, `CITY_TOURS`.`SM_WHAT_INCLUDES`, `CITY_TOURS`.`SM_TRAVELLERS_TALK`, `CITY_TOURS`.`SM_IS_IT_RIGHT_FOR_ME`, `tbl_viator_activity`.`VIATOR_PRODUCT_ID`, `tbl_viator_activity`.`CITY`, `CITY_TOURS`.`TOUR_ID`, `tbl_viator_activity`.`SEARCH_DURATION`, `tbl_viator_activity`.`RANK`, `tbl_viator_activity`.`VIATOR_DEST_ID`, 'Y' as is_tripindicator, `tbl_viator_activity`.`REVIEW_COUNT`, `tbl_viator_activity`.`REVIEW_RATING`, `tbl_viator_activity`.`VIATOR_TOUR_ID` as `viatorTourId`, GROUP_CONCAT( SUPPLIERS.SUPPLIER_NAME SEPARATOR ', ') as supplier_name, GROUP_CONCAT( SUPPLIERS.SUPPLIER_PRICE SEPARATOR ', ') as supplier_price, GROUP_CONCAT( SUPPLIERS.SUPPLIER_URL SEPARATOR ', ') as supplier_url FROM `tbl_viator_activity` LEFT JOIN `CITY_TOURS` ON `CITY_TOURS`.`VIATOR_PRODUCT_ID`=`tbl_viator_activity`.`VIATOR_PRODUCT_ID` JOIN `tbl_destination` ON `tbl_viator_activity`.`VIATOR_DEST_ID` = `tbl_destination`.`destination_id` JOIN `SUPPLIERS` ON `SUPPLIERS`.`VIATOR_PRODUCT_ID` = `tbl_viator_activity`.`VIATOR_PRODUCT_ID` WHERE IS NULL AND `tbl_viator_activity`.`VIATOR_DEST_ID` = '24558' AND `tbl_viator_activity`.`PRODUCT_STATUS` = 'Y' AND `SUPPLIERS`.`SUPPLIER_PRICE` >0 GROUP BY `tbl_viator_activity`.`VIATOR_PRODUCT_ID` LIMIT 6

Filename: helpers/common_queries_helper.php

Line Number: 1011