URL Rewrite #6
Description
URL Rewrite:
SELECT url_rewrite.* FROM url_rewrite WHERE (request_path IN ('cameradept/camera-equipment/l', 'cameradept/camera-equipment/')) AND (store_id IN ('1')) - > []
SELECT url_rewrite.* FROM url_rewrite WHERE (request_path IN ('cameradept/cameral', 'cameradept/camera-equipment//')) AND (store_id IN ('1')) - > []
SELECT url_rewrite.* FROM url_rewrite WHERE (request_path IN ('catalog/product/view/id/109340/category/8679', 'catalog/product/view/id/109340/category/8679/')) AND (store_id IN ('1')) - > []
SELECT url_rewrite.*, relation.category_id, relation.product_id FROM url_rewrite LEFT JOIN catalog_url_rewrite_product_category AS relation ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('catalog/product/view/id/109340/category/8679', 'catalog/product/view/id/109340/category/8679/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL) - > []
SELECT url_rewrite.*, relation.category_id, relation.product_id FROM url_rewrite LEFT JOIN catalog_url_rewrite_product_category AS relation ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_id IN ('109340')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL) - > []
SELECT url_rewrite.*, relation.category_id, relation.product_id FROM url_rewrite LEFT JOIN catalog_url_rewrite_product_category AS relation ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_type IN ('product')) AND (url_rewrite.entity_id IN ('456', '3618', '5142', '5174', '5689', '5690', '17711', '21247', '24160', '38761', '38779', '38782', '42506', '49597', '106283', '111329', '113135')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL) - > []
S