Back Catalog

Array ( [0] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/hanako-japanese-escort-used-panties-p-6433.html [product_id] => 6433 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Hanako Japanese Escort Used Panties [value] => Hanako Japanese Escort Used Panties [special] => [link] => https://www.kanojotoys.com/hanako-japanese-escort-used-panties-p-6433.html [product_id] => 6433 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 6433 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 6433 ) ) [1] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/love-paradise-onahole-p-6390.html [product_id] => 6390 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Ai Love Paradise Onahole [value] => Ai Love Paradise Onahole [special] => [link] => https://www.kanojotoys.com/love-paradise-onahole-p-6390.html [product_id] => 6390 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 6390 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 6390 ) ) [2] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/otoko-outlet-treasure-chest-over-items-p-6387.html [product_id] => 6387 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Otoko no Ko Outlet Treasure Chest (Over 22 Items) [value] => Otoko no Ko Outlet Treasure Chest (Over 22 Items) [special] => [link] => https://www.kanojotoys.com/otoko-outlet-treasure-chest-over-items-p-6387.html [product_id] => 6387 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 6387 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 6387 ) ) [3] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/mature-pregnant-woman-meiki-double-hole-onahole-p-6333.html [product_id] => 6333 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Mature Pregnant Woman Meiki Double Hole Onahole [value] => Mature Pregnant Woman Meiki Double Hole Onahole [special] => [link] => https://www.kanojotoys.com/mature-pregnant-woman-meiki-double-hole-onahole-p-6333.html [product_id] => 6333 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 6333 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 6333 ) ) [4] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/plastic-anoscope-with-anal-lubricant-p-6292.html [product_id] => 6292 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Plastic Anoscope with Anal Lubricant [value] => Plastic Anoscope with Anal Lubricant [special] => [link] => https://www.kanojotoys.com/plastic-anoscope-with-anal-lubricant-p-6292.html [product_id] => 6292 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 6292 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 6292 ) ) [5] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/toys-heart-dream-box-p-6293.html [product_id] => 6293 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Toys Heart Dream Box [value] => Toys Heart Dream Box [special] => [link] => https://www.kanojotoys.com/toys-heart-dream-box-p-6293.html [product_id] => 6293 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 6293 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 6293 ) ) [6] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/nami-college-girl-used-panties-p-6227.html [product_id] => 6227 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Nami College Girl Used Panties [value] => Nami College Girl Used Panties [special] => [link] => https://www.kanojotoys.com/nami-college-girl-used-panties-p-6227.html [product_id] => 6227 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 6227 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 6227 ) ) [7] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/mina-hostess-worn-panties-p-6185.html [product_id] => 6185 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Mina Hostess Worn Panties [value] => Mina Hostess Worn Panties [special] => [link] => https://www.kanojotoys.com/mina-hostess-worn-panties-p-6185.html [product_id] => 6185 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 6185 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 6185 ) ) [8] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/ayumi-policewoman-used-panties-p-6086.html [product_id] => 6086 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Ayumi Policewoman Used Panties [value] => Ayumi Policewoman Used Panties [special] => [link] => https://www.kanojotoys.com/ayumi-policewoman-used-panties-p-6086.html [product_id] => 6086 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 6086 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 6086 ) ) [9] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/six-type-naturalfeeling-onahole-2019-limited-edition-p-6053.html [product_id] => 6053 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => SI-X Type N Natural-Feeling Onahole (2019 Limited Edition) [value] => SI-X Type N Natural-Feeling Onahole (2019 Limited Edition) [special] => [link] => https://www.kanojotoys.com/six-type-naturalfeeling-onahole-2019-limited-edition-p-6053.html [product_id] => 6053 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 6053 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 6053 ) ) [10] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/six-type-function-pursuit-onahole-2019-limited-edition-p-6054.html [product_id] => 6054 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => SI-X Type R Function Pursuit Onahole (2019 Limited Edition) [value] => SI-X Type R Function Pursuit Onahole (2019 Limited Edition) [special] => [link] => https://www.kanojotoys.com/six-type-function-pursuit-onahole-2019-limited-edition-p-6054.html [product_id] => 6054 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 6054 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 6054 ) ) [11] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/reiko-live-streamer-babe-used-panties-p-6016.html [product_id] => 6016 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Reiko Live Streamer Babe Used Panties [value] => Reiko Live Streamer Babe Used Panties [special] => [link] => https://www.kanojotoys.com/reiko-live-streamer-babe-used-panties-p-6016.html [product_id] => 6016 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 6016 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 6016 ) ) [12] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/young-wife-meiki-asahi-mizuno-onahole-p-6001.html [product_id] => 6001 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Young Wife Meiki Asahi Mizuno Onahole [value] => Young Wife Meiki Asahi Mizuno Onahole [special] => [link] => https://www.kanojotoys.com/young-wife-meiki-asahi-mizuno-onahole-p-6001.html [product_id] => 6001 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 6001 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 6001 ) ) [13] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/otoko-bra-and-panties-bumper-box-set-p-5915.html [product_id] => 5915 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Otoko no Ko Bra and Panties Bumper Box Set [value] => Otoko no Ko Bra and Panties Bumper Box Set [special] => [link] => https://www.kanojotoys.com/otoko-bra-and-panties-bumper-box-set-p-5915.html [product_id] => 5915 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 5915 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 5915 ) ) [14] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/crystal-ice-tsubomisango-glass-butt-plug-p-5893.html [product_id] => 5893 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Crystal Ice Tsubomisango Glass Butt Plug [value] => Crystal Ice Tsubomisango Glass Butt Plug [special] => [link] => https://www.kanojotoys.com/crystal-ice-tsubomisango-glass-butt-plug-p-5893.html [product_id] => 5893 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 5893 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 5893 ) ) [15] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/aino-virgin-used-panties-p-5785.html [product_id] => 5785 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Aino Virgin Used Panties [value] => Aino Virgin Used Panties [special] => [link] => https://www.kanojotoys.com/aino-virgin-used-panties-p-5785.html [product_id] => 5785 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 5785 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 5785 ) ) [16] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/feminine-lace-underwear-for-men-p-5516.html [product_id] => 5516 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Feminine Lace Underwear for Men [value] => Feminine Lace Underwear for Men [special] => [link] => https://www.kanojotoys.com/feminine-lace-underwear-for-men-p-5516.html [product_id] => 5516 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 5516 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 5516 ) ) [17] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/sora-gamer-girl-stained-used-panties-p-5636.html [product_id] => 5636 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Sora Gamer Girl Stained Used Panties [value] => Sora Gamer Girl Stained Used Panties [special] => [link] => https://www.kanojotoys.com/sora-gamer-girl-stained-used-panties-p-5636.html [product_id] => 5636 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 5636 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 5636 ) ) [18] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/afterschool-uniform-costume-p-5564.html [product_id] => 5564 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => After-school Uniform Costume [value] => After-school Uniform Costume [special] => [link] => https://www.kanojotoys.com/afterschool-uniform-costume-p-5564.html [product_id] => 5564 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 5564 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 5564 ) ) [19] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/tenga-sweet-love-cup-p-5413.html [product_id] => 5413 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Tenga Sweet Love Cup [value] => Tenga Sweet Love Cup [special] => [link] => https://www.kanojotoys.com/tenga-sweet-love-cup-p-5413.html [product_id] => 5413 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 5413 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 5413 ) ) [20] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/otoko-costume-treasure-box-p-5363.html [product_id] => 5363 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Otoko no Ko Costume Treasure Box [value] => Otoko no Ko Costume Treasure Box [special] => [link] => https://www.kanojotoys.com/otoko-costume-treasure-box-p-5363.html [product_id] => 5363 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 5363 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 5363 ) ) [21] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/akari-tokyo-party-girl-stained-used-panties-p-4297.html [product_id] => 4297 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Akari Tokyo Party Girl Stained Used Panties [value] => Akari Tokyo Party Girl Stained Used Panties [special] => [link] => https://www.kanojotoys.com/akari-tokyo-party-girl-stained-used-panties-p-4297.html [product_id] => 4297 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4297 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4297 ) ) [22] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/buckle-lock-combination-expansion-kit-denma-massager-wand-holder-p-5237.html [product_id] => 5237 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Buckle Lock Combination Expansion Kit Denma Massager Wand Holder [value] => Buckle Lock Combination Expansion Kit Denma Massager Wand Holder [special] => [link] => https://www.kanojotoys.com/buckle-lock-combination-expansion-kit-denma-massager-wand-holder-p-5237.html [product_id] => 5237 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 5237 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 5237 ) ) [23] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/puberty-imouto-younger-sister-crotch-sweat-smell-p-5333.html [product_id] => 5333 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Puberty Imouto Younger Sister Crotch Sweat Smell [value] => Puberty Imouto Younger Sister Crotch Sweat Smell [special] => [link] => https://www.kanojotoys.com/puberty-imouto-younger-sister-crotch-sweat-smell-p-5333.html [product_id] => 5333 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 5333 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 5333 ) ) ) SELECT p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_quantity, p.products_tax_class_id, p.products_sort_order, p.products_date_available, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c LEFT JOIN categories c ON c.categories_id = p2c.categories_id) LEFT JOIN specials s on p.products_id = s.products_id WHERE c.hidden = '0' AND p2c.categories_id > 0 AND p.products_status = '1' AND p.products_quantity = 0 AND p.products_date_available IS NULL and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' order by p.products_date_added DESC, pd.products_name