Jam & Sing Plus Books IJAM Music stocks Australia's two most popular primary school singing books. We have the full range at the best price.
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 = '1' and cd.language_id = '1' order by c.sort_order asc