While Stocks Last
For what ever reason, these products are running out soon and we may never get them back again. Purchase them here for the last time and enjoy this special price!
Error reported on page /index.php
MySQL error: 3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'ijamcom_14decijam.PC.seq_no' which is not in SELECT list; this is incompatible with DISTINCT
SELECT DISTINCT P.products_id,P.*,PD.products_name FROM products_to_categories AS PC JOIN products_description AS PD ON PD.products_id=PC.products_id JOIN products AS P ON P.products_id=PC.products_id JOIN products_price AS PR ON PR.product_id=P.products_id LEFT JOIN products_to_products_extra_fields AS PE ON PE.products_id=P.products_id WHERE P.products_status=1 AND (PC.categories_id=168 ) AND P.products_multi='' AND PR.price!='0.00' AND PR.country_id=5 ORDER BY PC.seq_no ASC limit 15