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='regalovy-system-sortimo-do-maleho-vozidla-modul-8-sr-5-modul-8-sr5-s/' and product_recordactive=1 where catalogue_url like 'zariadenie-vozidiel/'  and catalogue_index like '%|26285|%' and catalogue_recordactive=1  and catalogue_type=1