Thank you for choosing Royal Discount, whether this is your first order or your 700th! You've chosen us as your one-stop shop for your software needs, so we'd like to be able to show our appreciation. Our Rewards program offers some of the latest electronics items and is available to anyone. Each purchase you make earns Reward Points which can be redeemed for money off of future purchases or towards items in our Rewards Store. If you have earned points, simply "check" the box on the Order Information screen to apply the points balance to your order.
1054 - Unknown column 'cd.categories_name' in 'order clause'
select p.products_image_med, pd.products_name, p.products_model, p.products_status, p.products_packaging, p.etilizeproductid, p.inventorysource, p.products_mfgpartno, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status > '0' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p.manufacturers_id = '38' and p.products_model<>'SECTIONHEADING' order by m.manufacturers_name ASC, cd.categories_name ASC, p2c.products_display_order ASC, pd.products_name ASC limit 0, 999999999