Fun Music Company CD Roms
Fun Music Compnay makes music games and other teaching resources for music. They have a fun emphasis and are created by experienced music educators and used by both specialist and non-specialist teachers.
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=166 ) AND P.products_multi='' AND PR.price!='0.00' AND PR.country_id=5 ORDER BY PC.seq_no ASC limit 15