Harmony & Senior Backing CDs & notation
Teach them the classics! Harmony and Senior CDs give you the chance to teach and sing the classic hits! They include vocal, backing and harmony tracks, and notation. For kids over 8 years of age.
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=110 ) AND P.products_multi='' AND PR.price!='0.00' AND PR.country_id=5 ORDER BY PC.seq_no ASC limit 15