Ops!
... [MYSQL Error] :
Request URI : /pt/pacotes-c19.html?p_page=38&rpp=24
Message : Out of resources when opening file './mademoi/category_product.MYD' (Errcode: 24 - Too many open files)
Query : SELECT DISTINCT p2.id_product FROM category_product cp
INNER JOIN (
SELECT
IF(ISNULL(v.id_product),p.id_product,v.id_product) as id_product,
GROUP_CONCAT(v.id_subproduct) as sub_product_filter_ids,
MIN(IF(p.special_price > 0, p.special_price, p.price)) as sprice,
pv.online as v_online,
p.online as r_online,
pv.date_delete as v_date_delete
FROM product as p LEFT JOIN `virtual` v ON v.id_subproduct = p.id_product LEFT JOIN product as pv ON v.id_product = pv.id_product WHERE p.product_type = "regular" AND p.stock > p.min_stock_threshold AND p.stock > 0 AND p.online = 1 AND (p.date_delete IS NULL OR p.date_delete = "") AND p.date_delete IS NULL AND 1 GROUP BY id_product
) t ON cp.id_product = t.id_product
INNER JOIN category c ON c.id_category = cp.id_category AND c.online = 1
INNER JOIN product p2 ON t.id_product = p2.id_product WHERE (v_date_delete IS NULL) AND (r_online = 1 AND (v_online IS NULL OR v_online = 1)) AND (cp.id_category IN (19, 274, 273, 130, 117, 103, 53, 32, 31, 30, 25)) AND (NOT EXISTS (SELECT 1 FROM category_product cp_ex WHERE cp_ex.id_product = cp.id_product AND cp_ex.id_category IN (160, 239, 162, 165, 164, 280, 161, 163, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 289, 288, 287, 286, 285, 284, 283, 282, 281, 279, 278, 277, 276, 275, 218))) ORDER BY cp.order ASC
Params for markers :
Array
(
[0] =>
)