|
|
 |
1030 - Got error 28 from storage engine
select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, pd.products_description des, cd.categories_name, cd2.categories_name AS parent_name from products p left join products_to_categories p2c on (p.products_id=p2c.products_id) left join categories c on (p2c.categories_id = c.categories_id) left join categories_description cd on (p2c.categories_id = cd.categories_id AND cd.language_id = 3) left join categories_description cd2 on (c.parent_id = cd2.categories_id AND cd2.language_id = 3) left join manufacturers m on (p.manufacturers_id = m.manufacturers_id) INNER JOIN products_description pd where (p.manufacturers_id is not null) and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '3' order by p.products_date_added DESC, pd.products_name limit 0, 15
[TEP STOP]
| | | |
Gold - 14k
