2 izbové byty

Unable to execute COUNT statement [SELECT COUNT(*) FROM (SELECT DISTINCT product.id, product.id_manufacturer, product.title, product.model, product.fulltext_search, product.description, product.note, product.addition_description, product.price_buy, product.price_sell, product.dph, product.barcode, product.add_barcode, product.code, product.type, product.s_group, product.weight, product.hidden, product.hidden_for_eshop, product.old, product.old_by_system, product.removed, product.removed_at, product.is_dynamic, product.item_order, product.ext_link, product.link, product.capacity, product.unit, product.shipping_price, product.shipping_wholesale_price, product.parent, product.lang, product.created_by, product.bound_to_client, product.variety, product.batch, product.made_in, product.sale_preallocation, product.purchase_preallocation, product.currency, product.agreement_price, product.price_info, product.created_at, product.updated_at FROM product INNER JOIN product_category_product ON (product.id=product_category_product.id_product) WHERE product_category_product.id IN (:p1,:p2,:p3,:p4,:p5,:p6,:p7,:p8,:p9,:p10,:p11,:p12,:p13,:p14,:p15,:p16,:p17,:p18,:p19,:p20,:p21,:p22,:p23,:p24,:p25,:p26,:p27,:p28,:p29) AND product.lang=:p30 AND (product.hidden=:p31 OR product.hidden IS NULL ) AND (product.old=:p32 OR product.old IS NULL ) AND (product.removed=:p33 OR product.removed IS NULL )) propelmatch4cnt]