"Back"

SQL Select

Executed SQL
SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = 1) AND (is_system = 1) AND (category_id = 37 OR category_id IS NULL) AND (product_id IN('337', '341', '406', '523')) ORDER BY `category_id` DESC
product_id request_path
337 furniture/by-room/dining-room/chair.html
341 furniture/by-room/dining-room/chinese-stool.html
406 furniture/by-room/dining-room/tolpuddle-armchair.html
523 furniture/by-room/dining-room/capulet-table.html
337 chair.html
341 chinese-stool.html
406 tolpuddle-armchair.html
523 capulet-table.html