SELECT SQL_CALC_FOUND_ROWS p.product_id, p.main_image, p.main_list_comment, p.comment2, p.update_date, p.sub_title6, MAX(price02), MAX(price03), MAX(stock), pc.point_rate, p.sales_datetime, p.sales_end_datetime, IF(p.tweet=p.tweet, 1, 0) AS tweet, p.name, p.movie_s, GROUP_CONCAT(cc.name separator ' ') AS classlist, GROUP_CONCAT(pc.stock separator ' ') AS stocklist
FROM dtb_products AS p
LEFT JOIN dtb_products_class AS pc ON p.product_id = pc.product_id
LEFT JOIN dtb_classcategory AS cc ON pc.classcategory_id1 = cc.classcategory_id
WHERE p.product_id IS NOT NULL
AND p.del_flg !=1
AND p.status =1
AND (p.sales_end_datetime IS NULL OR p.sales_end_datetime >= '2022-07-04 00:18:12')
AND pc.stock > 0
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 10
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
64319 NieR (ニーア) OFF-SHOULDER PULLOVER【MADNESS GIRL】
64320 NieR (ニーア) 夏用BLUE CHECKERED HALF ZIP HOODIE
64321 NieR (ニーア) うさ耳付きTWO-TONE SHORT SLEEVE OUTER【PURPLE×BLACK】
64322 NieR (ニーア) 切替半袖TWO-TONE PARKA【HEART BEAT】
64323 NieR (ニーア) MENS FAKE LAYERED SHIRT JACKET
64324 NieR (ニーア) パッチ付きBLACK WIDE PANTS【ROSE】
64325 NieR (ニーア) SIDE LINE DESIGN PANTS
63258 沢城千春×SABBAT13×GEKIROCK CLOTHING Lying T-Shirt WHITE
63259 沢城千春×SABBAT13×GEKIROCK CLOTHING Lying T-Shirt BLACK
63260 沢城千春×SABBAT13×GEKIROCK CLOTHING Stand T-Shirt ORANGE
63261 沢城千春×SABBAT13×GEKIROCK CLOTHING Stand T-Shirt PURPLE
64317 Subciety (サブサエティ) FLOCKS CAP BLACK
64318 Subciety (サブサエティ) FLOCKS CAP NAVY
64314 Subciety (サブサエティ) SUPPORTER TEE WHITE
64315 Subciety (サブサエティ) SUPPORTER TEE GRAY
64316 Subciety (サブサエティ) SUPPORTER TEE BLACK
64309 Subciety (サブサエティ) LEAGUE TEE WHITE/BLUE
64311 Subciety (サブサエティ) LEAGUE TEE NAVY
64310 Subciety (サブサエティ) LEAGUE TEE BLACK/YELLOW
64312 Subciety (サブサエティ) Monogram TEE WHITE
64313 Subciety (サブサエティ) Monogram TEE BLACK
59303 Subciety (サブサエティ) CROWD S/S WHITE
64222 Subciety (サブサエティ) CROWD S/S WHITE/BLUE
59304 Subciety (サブサエティ) CROWD S/S BLACK
64223 Subciety (サブサエティ) CROWD S/S BLACK/YELLOW
64224 Subciety (サブサエティ) CROWD S/S BLACK/BLACK
64192 Subciety (サブサエティ) THE BASE S/S WHITE
64193 Subciety (サブサエティ) THE BASE S/S NAVY
64194 Subciety (サブサエティ) THE BASE S/S BLACK
64195 Subciety (サブサエティ) GLORIOUS S/S WHITE
64196 Subciety (サブサエティ) GLORIOUS S/S NAVY
64197 Subciety (サブサエティ) GLORIOUS S/S BLACK
64198 Subciety (サブサエティ) MARIA TEE WHITE
64199 Subciety (サブサエティ) MARIA TEE WHITE/GOLD
64200 Subciety (サブサエティ) MARIA TEE BLACK
64201 Subciety (サブサエティ) MARIA TEE BLACK/GOLD
64060 Subciety (サブサエティ) HALF SLEEVE SWEAT GRAY
64061 Subciety (サブサエティ) HALF SLEEVE SWEAT KHAKI
64062 Subciety (サブサエティ) HALF SLEEVE SWEAT BLACK
64063 Subciety (サブサエティ) SWEAT SHORTS GRAY
64064 Subciety (サブサエティ) SWEAT SHORTS KHAKI
64065 Subciety (サブサエティ) SWEAT SHORTS BLACK
64066 Subciety (サブサエティ) DENIM SHORTS ONE WASH
64067 Subciety (サブサエティ) DENIM SHORTS BLACK
63809 Subciety(サブサエティ) FIVE LIGHTS TEE WHITE
63811 Subciety(サブサエティ) FIVE LIGHTS TEE BURGUNDY
63810 Subciety(サブサエティ) FIVE LIGHTS TEE BLACK
63813 Subciety(サブサエティ) PAISLEY COACH SHIRT BLUE
63812 Subciety(サブサエティ) PAISLEY COACH SHIRT BLACK
63821 Subciety(サブサエティ) MILITARY OVER SHIRT WHITE
63819 Subciety(サブサエティ) MILITARY OVER SHIRT BLACK
63815 Subciety(サブサエティ) PAISLEY COACH SHORTS BLUE
63814 Subciety(サブサエティ) PAISLEY COACH SHORTS BLACK
63823 Subciety(サブサエティ) MONSTER CARGO PANTS WHITE
63824 Subciety(サブサエティ) MONSTER CARGO PANTS BLACK
63826 Subciety(サブサエティ) MONSTER CARGO PANTS KHAKI
63768 Subciety (サブサエティ) CROCODILE BODY BAG RED
63770 Subciety (サブサエティ) CHIMERA CHAIN NECKLACE ANTIQUE SILVER
63743 Subciety (サブサエティ) BARBER S/S WHITE
63744 Subciety (サブサエティ) BARBER S/S BLACK
63341 Subciety (サブサエティ) BLACK PANTHER TEE BLACK
63340 Subciety (サブサエティ) BLACK PANTHER TEE WHITE
63342 Subciety (サブサエティ) BLACK PANTHER TEE BURGUNDY
63374 Subciety (サブサエティ) MULTI STORAGE BELT BAG KHAKI
63373 Subciety (サブサエティ) MULTI STORAGE BELT BAG BLACK
63202 Subciety (サブサエティ) DOUGH BOY TEE WHITE
63203 Subciety (サブサエティ) DOUGH BOY TEE BLACK
63207 Subciety (サブサエティ) CAN TEE WHITE
63208 Subciety (サブサエティ) CAN TEE BLACK
63204 Subciety (サブサエティ) TAG S/S WHITE
63205 Subciety (サブサエティ) TAG S/S BLACK/PURPLE
63206 Subciety (サブサエティ) TAG S/S BLACK/ORANGE
63106 Subciety (サブサエティ) NOUGAT TEE WHITE
63108 Subciety (サブサエティ) NOUGAT TEE BROWN
63107 Subciety (サブサエティ) NOUGAT TEE BLACK
63109 Subciety (サブサエティ) SCOUT TEE WHITE
63111 Subciety (サブサエティ) SCOUT TEE BEIGE
63110 Subciety (サブサエティ) SCOUT TEE BLACK
63112 Subciety (サブサエティ) INVOICE TEE WHITE
63114 Subciety (サブサエティ) INVOICE TEE BEIGE
63113 Subciety (サブサエティ) INVOICE TEE BLACK
63115 Subciety (サブサエティ) PEPPER TEE WHITE
63116 Subciety (サブサエティ) PEPPER TEE BLACK
63103 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT WHITE
63105 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT BLUE
63104 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT BLACK
62152 Subciety (サブサエティ) BIG SILHOUETTE RUGGER SHIRT BLACK
62153 Subciety (サブサエティ) BIG SILHOUETTE RUGGER SHIRT BLUE
62154 Subciety (サブサエティ) BIG SILHOUETTE RUGGER SHIRT KHAKI
62155 Subciety (サブサエティ) BAKER BAGGY PANTS BLACK
62158 Subciety (サブサエティ) NYLON CARGO SHORTS BLACK
62159 Subciety (サブサエティ) NYLON CARGO SHORTS OLIVE
62160 Subciety (サブサエティ) NYLON CARGO SHORTS PURPLE
62161 Subciety (サブサエティ) TRIP BACK PACK BLACK
62162 Subciety (サブサエティ) TRIP BACK PACK KHAKI
62167 Subciety (サブサエティ) 3P LINE SOCKS
64259 RIPNDIP (リップンディップ) Beach Boys Tee (Purple Mineral Wash)
64261 RIPNDIP (リップンディップ) Homegrown Treats Tee (Black)
64265 RIPNDIP (リップンディップ) Summer Splash Tee (Black)
64268 RIPNDIP (リップンディップ) Aloha Nerm Short Sleeve Button Up (Black)
64287 RIPNDIP (リップンディップ) Aloha Nerm Swim Shorts (Black)
64284 RIPNDIP (リップンディップ) Aloha Nerm Sweatshorts (Lavender)
64288 RIPNDIP (リップンディップ) Nerm Doodle Cotton Twill Pants (Chocolate)
64271 RIPNDIP (リップンディップ) Lullaby Long Sleeve (Black Mineral Wash)
64280 RIPNDIP (リップンディップ) Aloha Nerm Hoodie (Lavender)
64274 RIPNDIP (リップンディップ) Summer Revenge Rhinestone Hoodie (Black)
64289 RIPNDIP (リップンディップ) Shroom Mania Strapback (Bone)
64299 RIPNDIP (リップンディップ) Nikola Beach Bag (Blue)
64305 RIPNDIP (リップンディップ) Lord Nermal Velcro Hands Backpack
64301 RIPNDIP (リップンディップ) We Out Here High Top Shoe (Black)
64302 RIPNDIP (リップンディップ) Lord Jermal Leaf Camo Slides (3M Iridescent)
64258 RIPNDIP (リップンディップ) Nerms Diner Tee (Natural)
64257 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Natural)
64267 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Gray)
64260 RIPNDIP (リップンディップ) Lifes A Beach Tee (Light Blue Mineral Wash)
64255 RIPNDIP (リップンディップ) Nikola Embroidered Tee (Black/Blue)
64256 RIPNDIP (リップンディップ) Summer Revenge Rhinestone Tee (Black)
64262 RIPNDIP (リップンディップ) Nerm Cruiser Tee (Black Mineral Wash)
64263 RIPNDIP (リップンディップ) Nerm Jam (Black Mineral Wash)
64264 RIPNDIP (リップンディップ) Abduction Tee (Black Mineral Wash)
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[type] => 10
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&type=10&
--------
mb_parse_str
Array
(
[work] => new_arrival
[type] => 10
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&type=10