select product_id from product join catalogue on catalogue_product_id = product_id and catalogue_instance=1 join pricelist on pricelist_product_id=product_id and pricelist_instance=1 where catalogue_parent_id = 112112 and product_recordactive = 1 and product_instance=1 and catalogue_recordactive = 1 group by product_id order by catalogue_order LIMIT 0, 24
Obývacie izby | REA