1030 Got error 122 from storage engine
in:
[SELECT DISTINCT p.products_id, pd.products_name, pd.products_description, p.products_image, GREATEST(p.products_date_added,p.products_last_modified) AS products_date, p.master_categories_id, p.products_price_sorter AS price, p.products_tax_class_id, p.products_quantity, p.products_model, p.products_weight, p.manufacturers_id, m.manufacturers_name, r.reviews_rating
FROM zs_products p
LEFT JOIN zs_products_description pd ON (p.products_id = pd.products_id)
LEFT JOIN zs_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zs_reviews r ON (p.products_id = r.products_id)
, zs_products_to_categories p2c, zs_categories c
WHERE pd.language_id = 3
AND p.products_status = 1
AND p.products_id = p2c.products_id
AND c.categories_id = 37
AND p2c.categories_id = 37
ORDER BY p.products_last_modified DESC, p.products_sort_order
LIMIT 100]