Database query error ! : SQLSTATE[HY000]: General error: 23 Out of resources when opening file './mom2kids/shop_product_category.MYD' (Errcode: 24)
select type_value, count(*) as brand_cnt
from shop_product_type
LEFT JOIN shop_product_option po ON shop_product_type.product_id = po.product_id
AND po.is_group =1
LEFT JOIN shop_product_option_choice pc ON po.product_id = pc.product_id
AND po.option_id = pc.option_id
AND pc.status = 1
where shop_product_type.product_id in ( select shop_product.product_id
from shop_product, shop_product_category
where shop_product.product_id = shop_product_category.product_id
and shop_product_category.cat_id in (311) and shop_product.status<>0 and shop_product.price_net > 0 ) and
shop_product_type.type_id<>2 and shop_product_type.option_id=1
group by type_value
order by brand_cnt desc