Rsa97

SELECT `page_id`
  FROM `table`
  GROUP BY `page_id`
  HAVING COUNT(*) = SUM((`key` = 'type' AND `value` = '2') 
                         OR (`key` = 'count' AND `value` = '12') 
                         OR (`key` = 'real' AND `value` = 'direct'))