1194 - Table 'products' is marked as crashed and should be repaired
select distinct
manufacturers_info.manufacturers_id,
manufacturers_info.manufacturers_name, products_id, products_status
from manufacturers_info,
products
where manufacturers_info.manufacturers_id = products.manufacturers_id
and manufacturers_info.languages_id = 1
and products.products_status = 1 group by manufacturers_name