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 `price`, `t4`.value AS `total_square`, `t5`.value AS `living_square`, `t6`.value AS `kitchen_square`, `t7`.value AS `rooms_count`, `t8`.value AS `firstlast`, `t9`.value AS `floor`, `t10`.value AS `floors_total`, `t11`.value AS `phone`, `t12_opts`.`option` AS `city_district`, `t12`.`value` AS `city_district_id`, `t13`.value AS `additional_info`, `t14`.value AS `long_description`, `t15_opts`.`option` AS `person`, `t15`.`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 = 19 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 = 11 LEFT JOIN parameters_numeric `t6` ON i.id = `t6`.item AND `t6`.parameter = 10 LEFT JOIN parameters_numeric `t7` ON i.id = `t7`.item AND `t7`.parameter = 4 LEFT JOIN parameters_numeric `t8` ON i.id = `t8`.item AND `t8`.parameter = 21 LEFT JOIN parameters_numeric `t9` ON i.id = `t9`.item AND `t9`.parameter = 5 LEFT JOIN parameters_numeric `t10` ON i.id = `t10`.item AND `t10`.parameter = 6 LEFT JOIN parameters_numeric `t11` ON i.id = `t11`.item AND `t11`.parameter = 7 LEFT JOIN parameters_numeric `t12` ON i.id = `t12`.item AND `t12`.parameter = 15 LEFT JOIN parameters_options `t12_opts` ON `t12`.value = `t12_opts`.value AND `t12_opts`.parameter = 15 LEFT JOIN parameters_textual `t13` ON i.id = `t13`.item AND `t13`.parameter = 14 LEFT JOIN parameters_textual `t14` ON i.id = `t14`.item AND `t14`.parameter = 36 LEFT JOIN parameters_numeric `t15` ON i.id = `t15`.item AND `t15`.parameter = 31 LEFT JOIN parameters_options `t15_opts` ON `t15`.value = `t15_opts`.value AND `t15_opts`.parameter = 31 WHERE i.category = '7' ORDER BY i.date_added desc