"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 = 141 OR category_id IS NULL) AND (product_id IN('243', '450', '468', '469', '470', '471', '502', '503', '504', '505', '449', '298')) ORDER BY `category_id` DESC
product_id request_path
505 accessories-gifts/gifts/gifts-for-him/agate-box-ii.html
470 accessories-gifts/gifts/gifts-for-him/blow-fist-flat-dome.html
502 accessories-gifts/gifts/gifts-for-him/keepsake-box-i.html
469 accessories-gifts/gifts/gifts-for-him/hemmingway-wine-holder.html
468 accessories-gifts/gifts/gifts-for-him/umbra-umbrella-stand.html
503 accessories-gifts/gifts/gifts-for-him/keepsake-box-ii.html
450 accessories-gifts/gifts/gifts-for-him/lia-cloisonne-tile-box.html
449 accessories-gifts/gifts/gifts-for-him/crystal-quartz-noir-ii-box.html
504 accessories-gifts/gifts/gifts-for-him/quartz-box-i.html
298 accessories-gifts/gifts/gifts-for-him/zhou-cloisonne-tile-box.html
243 accessories-gifts/gifts/gifts-for-him/table-decor.html
471 accessories-gifts/gifts/gifts-for-him/curio-ii-dome.html
504 quartz-box-i.html
503 keepsake-box-ii.html
505 agate-box-ii.html
502 keepsake-box-i.html
471 curio-ii-dome.html
470 blow-fist-flat-dome.html
469 hemmingway-wine-holder.html
468 umbra-umbrella-stand.html
450 lia-cloisonne-tile-box.html
449 crystal-quartz-noir-ii-box.html
298 zhou-cloisonne-tile-box.html
243 table-decor.html