Out of resources when opening file './psautocomua/w_details#P#IMP156.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 = '6' WHERE ( ( DETAILS.BRAND_NAME IN ('skf') AND DETAILS.ARTICLE IN ('vkc3673') ) OR ( BRANDS.BRA_BRAND IN ('skf') AND DETAILS.ARTICLE IN ('vkc3673') ) ) AND DETAILS.ARTICLE IN ('vkc3673') 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 (81,117,87,93,101,102,122,123,124,125,126,80,82,115,116,148,119,121,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,149,150,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,0) GROUP BY DETAILS.IMPORT_ID, DETAILS.ARTICLE, DETAILS.BRAND_NAME, DETAILS.BOX, DETAILS.PRICE; Купить SKF VKC 3673 Выжимной подшипник, заказать по выгодной цене в каталоге интернет магазина автозапчастей www.psauto.com.ua