Songs & Activities These resources contain original songs and activities created by teachers in Australia and New Zealand that excel in their teaching of music with children. IJAM Music hand picks only the highest quality resources and all of these products can be returned if not completely satisfied.
Select a Category
Error reported on page /index.php
MySQL error: 3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'ijamcom_14decijam.c.sort_order' which is not in SELECT list; this is incompatible with DISTINCT
select distinct c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c LEFT JOIN categories_description cd ON c.categories_id = cd.categories_id LEFT JOIN products_to_categories p2c ON c.categories_id=p2c.categories_id LEFT JOIN products p ON p2c.products_id=p.products_id LEFT JOIN products_price pr ON pr.product_id=p2c.products_id where pr.country_id=5 and pr.price!='0.00' and c.parent_id = '5' and cd.language_id = '1' order by c.sort_order asc