Can anyone please help me!

When I add more than one category as special I get the following error:

" 1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

select count(*) as total from products A, products_description B , products_to_categories E left join specials C on C.products_id = A.products_id left join special_product F on A.products_id = F.product_id left join special_category D on E.categories_id = D.categ_id where E.categories_id = 44 and E.products_id = A.products_id and A.products_id = B.products_id and B.language_id = '1' "