Server shutdown in progress<hr>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 = 23470 OR p.productID = 23470) 
				GROUP BY p.productID
				ORDER BY p.sort_order, IF(LENGTH(`name_ua`), `name_ua`, `name_ru`) ASC