select catalogue_id,catalogue_type, catalogue_parent_id, catalogue_product_id,product_recordactive from catalogue join product on product_id=catalogue_product_id and product_url='9322-respirator-aura-ffp2-s-vydychovym-ventilom-7100004175/' and product_recordactive=1 where catalogue_url like 'ochranne-pomocky-a-bezpecnost-na-pracovisku/respiratory/'  and catalogue_index like '%|26285|%' and catalogue_recordactive=1  and catalogue_type=1