Interactive Products for Students
A whole new world of interactive music designed especially for students in their home. Enjoy the magic of Black Belt Recorder Interactive, Jam Song Books and more with no limits at home and on portable devices.
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=202 ) AND P.products_multi='' AND PR.price!='0.00' AND PR.country_id=5 ORDER BY PC.seq_no ASC limit 15