SQL ERROR:
SQLSTATE[HY000]: General error: 1021 Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")

select count(distinct p.products_family_name) as total from (products p left join specials_retail_prices s using(products_id) ) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and p.products_stock_type not in (9) and pd.language_id = '1' and p2c.categories_id = '940' and (products_group_access like "%,g,%" or products_group_access like "g,%" or products_group_access like "%,g" or products_group_access="g") and products_parent_id = 0