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 `newbuilt`, `t4`.value AS `total_square`, `t5`.value AS `land_size`, `t6`.value AS `price`, `t7`.lower AS `square_price_lower`, `t7`.upper AS `square_price_upper`, `t8`.lower AS `rental_lower`, `t8`.upper AS `rental_upper`, `t9_opts`.`option` AS `city_district`, `t9`.`value` AS `city_district_id`, `t10`.value AS `additional_info`, `t11`.value AS `long_description`, `t12_opts`.`option` AS `person`, `t12`.`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 = 22 LEFT JOIN parameters_numeric `t4` ON i.id = `t4`.item AND `t4`.parameter = 37 LEFT JOIN parameters_numeric `t5` ON i.id = `t5`.item AND `t5`.parameter = 12 LEFT JOIN parameters_numeric `t6` ON i.id = `t6`.item AND `t6`.parameter = 19 LEFT JOIN parameters_range `t7` ON i.id = `t7`.item AND `t7`.parameter = 30 LEFT JOIN parameters_range `t8` ON i.id = `t8`.item AND `t8`.parameter = 34 LEFT JOIN parameters_numeric `t9` ON i.id = `t9`.item AND `t9`.parameter = 15 LEFT JOIN parameters_options `t9_opts` ON `t9`.value = `t9_opts`.value AND `t9_opts`.parameter = 15 LEFT JOIN parameters_textual `t10` ON i.id = `t10`.item AND `t10`.parameter = 14 LEFT JOIN parameters_textual `t11` ON i.id = `t11`.item AND `t11`.parameter = 36 LEFT JOIN parameters_numeric `t12` ON i.id = `t12`.item AND `t12`.parameter = 31 LEFT JOIN parameters_options `t12_opts` ON `t12`.value = `t12_opts`.value AND `t12_opts`.parameter = 31 WHERE i.category = '9' ORDER BY i.date_added desc