Out of resources when opening file './autodetalyby/w_details#P#IMP88.MYD' (Errcode: 24 "Too many open files")
SELECT
DETAILS.*,
(CASE
WHEN IMP.delivery AND IOP.delivery THEN CAST(DETAILS.DELIVERY AS UNSIGNED) + CAST(IMP.delivery AS UNSIGNED) + CAST(IOP.delivery AS UNSIGNED)
WHEN IMP.delivery THEN CAST(DETAILS.DELIVERY AS UNSIGNED) + CAST(IMP.delivery AS UNSIGNED)
WHEN IOP.delivery THEN CAST(DETAILS.DELIVERY AS UNSIGNED) + CAST(IOP.delivery AS UNSIGNED)
ELSE DETAILS.DELIVERY
END)
AS DELIVERY,
DETAILS.BRAND_NAME MATCH_BRAND
/*BRANDS.BRA_BRAND MATCH_BRAND*/
FROM `w_details` DETAILS
LEFT JOIN `w_brands` BRANDS ON BRANDS.BRA_ID = DETAILS.BRAND_ID
LEFT JOIN `w_accounts` ACC ON ACC.id = DETAILS.IS_ACCOUNT
LEFT JOIN `w_importers` IMP ON IMP.id = DETAILS.IMPORT_ID
LEFT JOIN `w_importers_offices_params` IOP ON IOP.imp_id = DETAILS.IMPORT_ID AND IOP.office_id = '1'
WHERE
(
( DETAILS.BRAND_NAME IN ('trw') AND DETAILS.ARTICLE IN ('psa187') ) OR
( BRANDS.BRA_BRAND IN ('trw') AND DETAILS.ARTICLE IN ('psa187') )
) AND DETAILS.ARTICLE IN ('psa187')
AND (DETAILS.IS_ACCOUNT = '0' OR IF(DETAILS.IS_ACCOUNT != '0', ACC.is_active_warehouse = '1', ACC.is_active_warehouse = '0'))
AND TRIM(DETAILS.PRICE) > 0
AND TRIM(DETAILS.BOX) != '0' AND TRIM(DETAILS.BOX) != ''
AND DETAILS.IMPORT_ID IN (57,32,34,37,55,56,46,51,52,0)
GROUP BY
DETAILS.IMPORT_ID,
DETAILS.ARTICLE,
DETAILS.BRAND_NAME,
DETAILS.BOX,
DETAILS.PRICE;
Купить TRW PSA187 Усилитель тормозной системы, заказать по +375 (44) 534-62-84 выгодной цене в каталоге интернет магазина автозапчастей autodetaly.by