An Error Was Encountered

Error Number: 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 i.*, DATE_FORMAT(date_added, '%d/%m/%Y') AS `date_added`, c.title_sn AS category_title, `t1_opts`.`option` AS `operation`, `t1`.`value` AS `operation_id`, `t2_opts`.`option` AS `priority`, `t2`.`value` AS `priority_id`, `t3`.value AS `land_size`, `t4`.value AS `price`, `t5_opts`.`option` AS `city_district`, `t5`.`value` AS `city_district_id`, `t6_opts`.`option` AS `suburb_disctrict`, `t6`.`value` AS `suburb_disctrict_id`, `t7`.value AS `additional_info`, `t8`.value AS `long_description`, `t9_opts`.`option` AS `person`, `t9`.`value` AS `person_id` FROM items i FORCE INDEX(date_added) LEFT JOIN categories c ON i.category = c.id LEFT JOIN parameters_numeric `t1` ON i.id = `t1`.item AND `t1`.parameter = 25 LEFT JOIN parameters_options `t1_opts` ON `t1`.value = `t1_opts`.value AND `t1_opts`.parameter = 25 LEFT JOIN parameters_numeric `t2` ON i.id = `t2`.item AND `t2`.parameter = 39 LEFT JOIN parameters_options `t2_opts` ON `t2`.value = `t2_opts`.value AND `t2_opts`.parameter = 39 LEFT JOIN parameters_numeric `t3` ON i.id = `t3`.item AND `t3`.parameter = 12 LEFT JOIN parameters_numeric `t4` ON i.id = `t4`.item AND `t4`.parameter = 19 LEFT JOIN parameters_numeric `t5` ON i.id = `t5`.item AND `t5`.parameter = 15 LEFT JOIN parameters_options `t5_opts` ON `t5`.value = `t5_opts`.value AND `t5_opts`.parameter = 15 LEFT JOIN parameters_numeric `t6` ON i.id = `t6`.item AND `t6`.parameter = 16 LEFT JOIN parameters_options `t6_opts` ON `t6`.value = `t6_opts`.value AND `t6_opts`.parameter = 16 LEFT JOIN parameters_textual `t7` ON i.id = `t7`.item AND `t7`.parameter = 14 LEFT JOIN parameters_textual `t8` ON i.id = `t8`.item AND `t8`.parameter = 36 LEFT JOIN parameters_numeric `t9` ON i.id = `t9`.item AND `t9`.parameter = 31 LEFT JOIN parameters_options `t9_opts` ON `t9`.value = `t9_opts`.value AND `t9_opts`.parameter = 31 WHERE i.category = '24' ORDER BY i.date_added desc