Back Catalog

Array ( [0] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/insert-air-pillow-cover-sexy-schoolgirl-p-4746.html [product_id] => 4746 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Insert Air Pillow DX Cover 51 Sexy Schoolgirl [value] => Insert Air Pillow DX Cover 51 Sexy Schoolgirl [special] => [link] => https://www.kanojotoys.com/insert-air-pillow-cover-sexy-schoolgirl-p-4746.html [product_id] => 4746 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4746 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4746 ) ) [1] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/insert-air-pillow-cover-p-4740.html [product_id] => 4740 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Insert Air Pillow DX Cover 53 [value] => Insert Air Pillow DX Cover 53 [special] => [link] => https://www.kanojotoys.com/insert-air-pillow-cover-p-4740.html [product_id] => 4740 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4740 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4740 ) ) [2] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/toys-heart-lucky-bag-2018-spring-red-p-4705.html [product_id] => 4705 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Toy's Heart Lucky Bag 2018 Spring Red [value] => Toy's Heart Lucky Bag 2018 Spring Red [special] => [link] => https://www.kanojotoys.com/toys-heart-lucky-bag-2018-spring-red-p-4705.html [product_id] => 4705 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4705 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4705 ) ) [3] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/toys-heart-lucky-bag-2018-spring-purple-p-4706.html [product_id] => 4706 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Toy's Heart Lucky Bag 2018 Spring Purple [value] => Toy's Heart Lucky Bag 2018 Spring Purple [special] => [link] => https://www.kanojotoys.com/toys-heart-lucky-bag-2018-spring-purple-p-4706.html [product_id] => 4706 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4706 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4706 ) ) [4] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/taimanin-murasaki-love-lubricant-p-4669.html [product_id] => 4669 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Taimanin Murasaki Love Lubricant [value] => Taimanin Murasaki Love Lubricant [special] => [link] => https://www.kanojotoys.com/taimanin-murasaki-love-lubricant-p-4669.html [product_id] => 4669 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4669 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4669 ) ) [5] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/boku-fera-dorei-blowjob-slave-onahole-p-4664.html [product_id] => 4664 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Boku no Fera Dorei My Blowjob Slave Onahole [value] => Boku no Fera Dorei My Blowjob Slave Onahole [special] => [link] => https://www.kanojotoys.com/boku-fera-dorei-blowjob-slave-onahole-p-4664.html [product_id] => 4664 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4664 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4664 ) ) [6] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/japanese-schoolgirl-damp-panties-smell-bottle-p-4624.html [product_id] => 4624 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Japanese Schoolgirl Damp Panties Smell Bottle [value] => Japanese Schoolgirl Damp Panties Smell Bottle [special] => [link] => https://www.kanojotoys.com/japanese-schoolgirl-damp-panties-smell-bottle-p-4624.html [product_id] => 4624 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4624 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4624 ) ) [7] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/young-japanese-wife-used-panties-random-bag-p-4612.html [product_id] => 4612 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Young Japanese Wife Used Panties Random Bag [value] => Young Japanese Wife Used Panties Random Bag [special] => [link] => https://www.kanojotoys.com/young-japanese-wife-used-panties-random-bag-p-4612.html [product_id] => 4612 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4612 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4612 ) ) [8] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/insert-cushion-pillow-p-4588.html [product_id] => 4588 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Insert Cushion Pillow [value] => Insert Cushion Pillow [special] => [link] => https://www.kanojotoys.com/insert-cushion-pillow-p-4588.html [product_id] => 4588 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4588 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4588 ) ) [9] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/japanese-office-lady-used-panties-bag-p-4589.html [product_id] => 4589 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Japanese Office Lady Used Panties Bag [value] => Japanese Office Lady Used Panties Bag [special] => [link] => https://www.kanojotoys.com/japanese-office-lady-used-panties-bag-p-4589.html [product_id] => 4589 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4589 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4589 ) ) [10] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/chiaki-used-japanese-female-flight-attendant-cosplay-costume-p-4515.html [product_id] => 4515 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Chiaki Used Japanese Female Flight Attendant Cosplay Costume [value] => Chiaki Used Japanese Female Flight Attendant Cosplay Costume [special] => [link] => https://www.kanojotoys.com/chiaki-used-japanese-female-flight-attendant-cosplay-costume-p-4515.html [product_id] => 4515 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4515 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4515 ) ) [11] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/junko-used-japanese-female-nurse-costume-p-4516.html [product_id] => 4516 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Junko Used Japanese Female Nurse Costume [value] => Junko Used Japanese Female Nurse Costume [special] => [link] => https://www.kanojotoys.com/junko-used-japanese-female-nurse-costume-p-4516.html [product_id] => 4516 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4516 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4516 ) ) [12] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/tawawa-after-school-gcup-paizuri-breasts-p-4521.html [product_id] => 4521 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Tawawa After School G-Cup Paizuri Breasts [value] => Tawawa After School G-Cup Paizuri Breasts [special] => [link] => https://www.kanojotoys.com/tawawa-after-school-gcup-paizuri-breasts-p-4521.html [product_id] => 4521 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4521 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4521 ) ) [13] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/yurina-used-policewoman-uniform-cosplay-costume-p-4514.html [product_id] => 4514 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Yurina Used Policewoman Uniform Cosplay Costume [value] => Yurina Used Policewoman Uniform Cosplay Costume [special] => [link] => https://www.kanojotoys.com/yurina-used-policewoman-uniform-cosplay-costume-p-4514.html [product_id] => 4514 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4514 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4514 ) ) [14] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/milky-body-onahole-p-4472.html [product_id] => 4472 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Milky Body Onahole [value] => Milky Body Onahole [special] => [link] => https://www.kanojotoys.com/milky-body-onahole-p-4472.html [product_id] => 4472 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4472 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4472 ) ) [15] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/bitch-body-human-toilet-insults-sticker-p-4426.html [product_id] => 4426 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Bitch Body Human Toilet Insults Sticker [value] => Bitch Body Human Toilet Insults Sticker [special] => [link] => https://www.kanojotoys.com/bitch-body-human-toilet-insults-sticker-p-4426.html [product_id] => 4426 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4426 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4426 ) ) [16] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/magical-beast-catgirl-zwei-onahole-p-4395.html [product_id] => 4395 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Magical Beast Catgirl Zwei Onahole [value] => Magical Beast Catgirl Zwei Onahole [special] => [link] => https://www.kanojotoys.com/magical-beast-catgirl-zwei-onahole-p-4395.html [product_id] => 4395 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4395 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4395 ) ) [17] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/magical-beast-catgirl-drei-onahole-p-4396.html [product_id] => 4396 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Magical Beast Catgirl Drei Onahole [value] => Magical Beast Catgirl Drei Onahole [special] => [link] => https://www.kanojotoys.com/magical-beast-catgirl-drei-onahole-p-4396.html [product_id] => 4396 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4396 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4396 ) ) [18] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/magical-beast-catgirl-eins-onahole-p-4394.html [product_id] => 4394 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Magical Beast Catgirl Eins Onahole [value] => Magical Beast Catgirl Eins Onahole [special] => [link] => https://www.kanojotoys.com/magical-beast-catgirl-eins-onahole-p-4394.html [product_id] => 4394 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4394 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4394 ) ) [19] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/penitama-crossdresser-panties-cock-sock-penis-sheath-p-4383.html [product_id] => 4383 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Penitama Crossdresser Panties Cock Sock Penis Sheath [value] => Penitama Crossdresser Panties Cock Sock Penis Sheath [special] => [link] => https://www.kanojotoys.com/penitama-crossdresser-panties-cock-sock-penis-sheath-p-4383.html [product_id] => 4383 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4383 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4383 ) ) [20] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/schoolgirl-end-menstrual-cycle-smell-bottle-p-4333.html [product_id] => 4333 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Schoolgirl End of Menstrual Cycle Smell Bottle [value] => Schoolgirl End of Menstrual Cycle Smell Bottle [special] => [link] => https://www.kanojotoys.com/schoolgirl-end-menstrual-cycle-smell-bottle-p-4333.html [product_id] => 4333 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4333 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4333 ) ) [21] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/nipple-pump-p-4284.html [product_id] => 4284 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Nipple Pump DX [value] => Nipple Pump DX [special] => [link] => https://www.kanojotoys.com/nipple-pump-p-4284.html [product_id] => 4284 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4284 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4284 ) ) [22] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/sujiman-cute-round-stomach-girl-onahole-p-4321.html [product_id] => 4321 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Sujiman Cute Round Stomach Girl Onahole [value] => Sujiman Cute Round Stomach Girl Onahole [special] => [link] => https://www.kanojotoys.com/sujiman-cute-round-stomach-girl-onahole-p-4321.html [product_id] => 4321 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4321 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4321 ) ) [23] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/menopausal-aunt-old-stained-panties-smell-bottle-p-4318.html [product_id] => 4318 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Menopausal Aunt Old Stained Panties Smell Bottle [value] => Menopausal Aunt Old Stained Panties Smell Bottle [special] => [link] => https://www.kanojotoys.com/menopausal-aunt-old-stained-panties-smell-bottle-p-4318.html [product_id] => 4318 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4318 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4318 ) ) ) 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