SELECT h.`id` as page_id FROM `cms3_filter_index_56_pages_10` f 
                  LEFT JOIN `cms3_hierarchy` h on f.`obj_id`=h.obj_id 
                  LEFT JOIN `cms3_objects` o on f.`obj_id`=o.id 
                  WHERE  (f.`parent_id` IN (57) )  AND  (  f.`zone` LIKE '%Кабинет%'  OR  f.`zone` LIKE '%Холл%'  )  AND  (  f.`style` LIKE '%Арт-Деко%'  OR  f.`style` LIKE '%60-70 г. ХХ в.%'  OR  f.`style` LIKE '%Неоклассика%'  OR  f.`style` LIKE '%Современный%'  )  AND  (  f.`country` LIKE '%Франция%'  OR  f.`country` LIKE '%Дания%'  )   AND  f.`factory` NOT IN('AMBIANCE COSY','BASTIANELLI HOME','BORDIGNON CAMILLO','COLOMBO STILE','DE BAGGIS','DEL TONGO','FERRETTI & FERRETTI','JC PASSION','JESSE','LA EBANISTERIA','LINEA VERDACE','MAGGI MASSIMO','MANTELLASSI','MERITALIA','MODA','MUGALI','PIGOLI','TONCELLI','VALDICHIENTI','PRIANERA')  
                  ORDER BY f.`product_out_of_production` ASC, f.`factory_no_orders` ASC, f.`have_price` DESC, o.`name` DESC LIMIT 0,52