Server shutdown in progress
SELECT
p.productID,
p.categoryID,
p.Price,
p.PriceCID,
p.list_price,
p.in_stock,
p.ordering_available,
p.enabled,
p.archive,
p.product_code,
p.sort_order,
p.default_picture,
p.slug,
p.name_ua,
p.name_ru,
pics.thumbnail,
pics.enlarged,
pm.parentProductID,
pm.childProductID,
model_childs.childProductID AS has_childs
FROM SC_products AS p
LEFT JOIN SC_products_models AS pm ON pm.childProductID=p.productID
LEFT JOIN SC_products_models AS model_childs ON p.productID=model_childs.parentProductID
LEFT JOIN SC_product_pictures pics ON p.default_picture = pics.photoID
WHERE (pm.parentProductID = 23141 OR p.productID = 23141)
GROUP BY p.productID
ORDER BY p.sort_order, `name_ru` ASC