SELECT DISTINCT p.products_id AS dist, p . * , COUNT( p.products_id ) AS amount FROM `products` p JOIN orders_products op ON p.products_id = op.products_id WHERE categories_id = '623' AND products_status = '0' AND (p.products_in_our_stock > '0' OR p.products_in_stock > '0') GROUP BY dist ORDER BY amount DESC LIMIT 5
Got error 28 from storage engine