Database query error ! : SQLSTATE[HY000]: General error: 23 Out of resources when opening file './mom2kids/shop_product_category.MYD' (Errcode: 24)
select count(*) as cnt from shop_product
where shop_product.status = 1 and shop_product.show_web = 1 and shop_product.product_id in
( SELECT product_id
FROM shop_product_category
WHERE cat_id in (196) )