KidsInKey Backing CDs IJAM Music stocks KidsInKey Backing CDs (Formally 'Music Made Easy CDs) (See also 'MP3 Quick Picker' above). These popular CDs & notation contain instrumental and vocal versions to all songs, lyrics/notation in the key that suits your children. Most CDs include bonus harmony tracks to make teaching harmony to your students simple and easy.
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 = '2' and cd.language_id = '1' order by c.sort_order asc