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