Database query error ! : SQLSTATE[HY000]: General error: 23 Out of resources when opening file './mom2kids/shop_product_type.MYD' (Errcode: 24)
select count(*) as cnt FROM shop_product LEFT JOIN shop_product_option po ON shop_product.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.product_id in ( SELECT product_id FROM shop_product_category WHERE cat_id in (196) ) and shop_product.product_id in (select product_id from shop_product_type where type_id<>2 and option_id=1 and type_value in ('30','102','162','186','259','331')) and shop_product.status<>0 and shop_product.show_web = 1 and shop_product.price_net > 0