SQL - 4: SELECT `p`.`id`,`p`.`sku`,`p`.`title`,`p`.`description`,`p`.`intro`,`p`.`type_id`,`p`.`image`,`p`.`price`,`p`.`active`,`p`.`sale`,`p`.`is_ppn` FROM `kp_product_owner` AS `o` LEFT JOIN `warehouse_product` AS `p` ON (`o`.`product_id` = `p`.`id`) LEFT JOIN `kp_product_category` AS `c` ON (`p`.`id`=`c`.`product_id` AND `c`.`owner_id` = `o`.`owner_id` ) WHERE `o`.`owner_id`= AND `p`.`active` = 1 AND `p`.`publish`=1 AND (`p`.`qty_available` != 0 OR `p`.`always_available` = 1 ) AND `c`.`cat_id`=86 AND `type_id` != 4 ORDER BY `id` DESC LIMIT 9
modules/visilink/_function.php line:647
modules/visilink/category.php line:135
modules/visilink/_switch.php line:11
modules/product/_switch.php line:21
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `p`.`active` = 1 AND `p`.`publish`=1 AND (`p`.`qty_available` != 0 OR `p`.`a' at line 1

SQL - 5: SELECT COUNT(*) FROM (SELECT `p`.`id`,`p`.`sku`,`p`.`title`,`p`.`description`,`p`.`intro`,`p`.`type_id`,`p`.`image`,`p`.`price`,`p`.`active`,`p`.`sale`,`p`.`is_ppn` FROM `kp_product_owner` AS `o` LEFT JOIN `warehouse_product` AS `p` ON (`o`.`product_id` = `p`.`id`) LEFT JOIN `kp_product_category` AS `c` ON (`p`.`id`=`c`.`product_id` AND `c`.`owner_id` = `o`.`owner_id` ) WHERE `o`.`owner_id`= AND `p`.`active` = 1 AND `p`.`publish`=1 AND (`p`.`qty_available` != 0 OR `p`.`always_available` = 1 ) AND `c`.`cat_id`=86 AND `type_id` != 4 ORDER BY `id` DESC ) AS `get_data_count`
modules/visilink/_function.php line:648
modules/visilink/category.php line:135
modules/visilink/_switch.php line:11
modules/product/_switch.php line:21
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `p`.`active` = 1 AND `p`.`publish`=1 AND (`p`.`qty_available` != 0 OR `p`.`a' at line 1

CHAT WITH US

6287780801010