SELECT product_id FROM oc_product WHERE model like '%SOFTTOUCHBLEUFONCE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'SOFTTOUCHBLEUFONCE' AND status=1SELECT product_id FROM oc_product WHERE model like '%SOFTTOUCHBLEUFONCE' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'SOFTTOUCHBLEUFONCE' AND status=1SELECT product_id FROM oc_product WHERE model like '%3DTEMPGLASSFINGER' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = '3DTEMPGLASSFINGER' AND status=1SELECT product_id FROM oc_product WHERE model like '%3DTEMPGLASSFINGER' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = '3DTEMPGLASSFINGER' AND status=1SELECT product_id FROM oc_product WHERE model like '%C-BLANCPHONELOOK' AND SUBSTRING_INDEX(SUBSTRING_INDEX(model, '-', 3), '-', -1) = 'C-BLANCPHONELOOK' AND status=1<br />
<b>Fatal error</b>:  Uncaught Exception: Error: 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 ') AND p.date_available &lt;= NOW() AND p.status = '1' AND r.status = '1' AND pd....' at line 1&lt;br /&gt;Error No: 1064&lt;br /&gt;SELECT COUNT(*) AS total FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id in () AND p.date_available &lt;= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2' in /home/menslack/domains/menslack.ch/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/menslack/domains/menslack.ch/public_html/storage/modification/system/library/db.php(56): DB\MySQLi-&gt;query('SELECT COUNT(*)...')
#1 /home/menslack/domains/menslack.ch/public_html/catalog/model/catalog/review.php(282): DB-&gt;query('SELECT COUNT(*)...')
#2 /home/menslack/domains/menslack.ch/public_html/storage/modification/system/engine/loader.php(259): Mo in <b>/home/menslack/domains/menslack.ch/public_html/system/library/db/mysqli.php</b> on line <b>40</b><br />