Susie and Phil\'s Welcome to Music Books & CDs
An exciting, interactive and original collection of musical activities by Susie Davies-Splitter and Phil Splitter. Susie and Phil, create musical resources that are highly respected and sought after in Australia, New Zealand, Singapore, USA and the UK!
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=141 ) AND P.products_multi='' AND PR.price!='0.00' AND PR.country_id=5 ORDER BY PC.seq_no ASC limit 15