QAnZX7Ah

1Query works too slow when there is no results
2CREATE TABLE IF NOT EXISTS `main_pages_options` (
3  `page_id` int(11) NOT NULL,
4  `value` varchar(255) NOT NULL,
5  `option_id` int(11) NOT NULL,
6  UNIQUE KEY `page_id` (`page_id`,`option_id`),
7  FULLTEXT KEY `value` (`value`)
8) ENGINE=MyISAM ;
9
10SELECT page_id
11FROM main_pages_options
12  WHERE (option_id = 1 AND value = 'Test 1') 
13  OR (option_id = 2 AND value = 'Test 2') 
14  OR (option_id = 3 AND value = 'Test 3')
15GROUP BY page_id 
16HAVING COUNT(*) = 3
17
18SELECT page_id
19FROM main_pages_options
20  WHERE (option_id = 1 AND value = 'Test 7') 
21  OR (option_id = 2 AND value = 'Test 2') 
22  OR (option_id = 3 AND value = 'Test 3')
23GROUP BY page_id 
24HAVING COUNT(*) = 3