Home » Catalogue » History Basket Contents
Search Results
0
Displaying 21 to 40 (of 3692 books)
1030 - Got error 28 from storage engine

select pd.products_name, p.products_id, p.products_price, p.products_image, p.products_model, p.products_author, p.products_first_pub, 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 join products p on pd.products_id = p.products_id join products_to_categories pc on p.products_id = pc.products_id left outer join specials s on p.products_id = s.products_id where p.deleted = 0 and p.products_quantity > 0 and p.products_status = 1 and pd.language_id = 1 and pc.categories_id in (143, 427, 145, 527, 146, 147, 148, 507, 508, 149, 531, 441, 150, 151, 152, 153, 426) group by pd.products_name, p.products_id, p.products_price, p.products_model, p.products_author, p.products_first_pub, p.products_tax_class_id, specials_new_products_price, final_price order by p.products_author, pd.products_name, p.products_price limit 20, 20

[TEP STOP]