"Back"

SQL Select

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
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 = 38 OR category_id IS NULL) AND (product_id IN('242', '302', '335', '336', '339', '365', '366', '367', '368', '369', '371', '372')) ORDER BY `category_id` DESC
product_id request_path
372 furniture/by-room/salon/ariel-side-table.html
366 furniture/by-room/salon/duddells-sofa.html
368 furniture/by-room/salon/molton-sofa.html
365 furniture/by-room/salon/delancey-sofa.html
339 furniture/by-room/salon/slipper-sofa.html
369 furniture/by-room/salon/escamillo-side-table.html
336 furniture/by-room/salon/2-seat-sofa.html
335 furniture/by-room/salon/love-seat.html
371 furniture/by-room/salon/rosalind-side-table.html
302 furniture/by-room/salon/wu-marble-table-for-cloisonne-tiles.html
242 furniture/by-room/salon/crosby-sofa.html
367 furniture/by-room/salon/belgravia-sofa.html
371 rosalind-side-table.html
369 escamillo-side-table.html
372 ariel-side-table.html
368 molton-sofa.html
367 belgravia-sofa.html
366 duddells-sofa.html
365 delancey-sofa.html
339 slipper-sofa.html
336 2-seat-sofa.html
335 love-seat.html
302 wu-marble-table-for-cloisonne-tiles.html
242 crosby-sofa.html