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='scon-1900-pl-shr-container-1000015791/' and product_recordactive=1 where catalogue_url like 'zariadenie-vozidiel/'  and catalogue_index like '%|26285|%' and catalogue_recordactive=1  and catalogue_type=1