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-05-21 06:08:10')
AND pc.stock > 0
AND pc.price03 IS NOT NULL
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 120, 120
45722 LILWHITE(dot) LW-19SS-S02 "NIGHTHEAD" HOODIE WHITE
47860 Subciety (サブサエティ) CHECK SHIRTS-BABYLON- RED
56119 SILLENT FROM ME EVIDENCE Plain Parka WHT
25422 SQUARE (スクエア) ALOHA 13 4/3 HOODY NAVY
27357 SQUARE CARGO SHORT PANTS D TIGER CAMO
27358 SQUARE CARGO SHORT PANTS BEIGE
27359 SQUARE CARGO SHORT PANTS OLIVE
34259 ROLLING CRADLE BIG POCKET SHORTS / Green
40555 SABBAT13 S-BONE BIG NEL SHIRTS YELLOW
41796 ROLLING CRADLE CARGO CAMO SHORTS Beige
41797 ROLLING CRADLE CARGO CAMO SHORTS Green
41897 ROLLING CRADLE RC VULGAR SHIRT Green
47109 NOT COMMON SENSE NCS REMAKE SEAM TEE BLACK
47325 RIPNDIP Multi Hoodie (White)
47647 RIPNDIP Run It Nylon Track Jacket (Watermelon)
47650 RIPNDIP RIPNTAIL Hoodie (Black)
7181 Subciety DENIM SHORTS -STUDS- BLACK
20113 KILL STAR CLOTHING KALI DENIM VEST [B]
26382 Zephyren (ゼファレン) LONG CHECK SHIRT S/S -Resolve- WHITE
26385 Zephyren (ゼファレン) LONG CHECK SHIRT S/S -Resolve- GRAY
48284 BLACK CRAFT Unholy - Large Nylon Backpack
24962 Subciety (サブサエティ) EMBLEM SHIRT S/S-CAMOUFLAGE- GREEN
24963 Subciety (サブサエティ) EMBLEM SHIRT S/S-CAMOUFLAGE- BEIGE
13800 Subciety TIE DYE PARKA-GLORIOUS- BGN
23014 Subciety EMBLEM WORK SHIRT S/S-CHAMBRAY- BLUE
24964 Subciety (サブサエティ) EMBROIDERY SHIRT S/S-GLORIOUS- WHITE
24966 Subciety (サブサエティ) EMBROIDERY SHIRT S/S-GLORIOUS- OD
25386 BLACK SCALE GUADALUPE WARM UP JERSEY BLK
25647 Subciety DOBBY CHECK SHIRT L/S-Praha- KHAKI
25649 Subciety OMBRE CHECK SHIRT L/S-THRON- RED
25847 Subciety TAPERED WORK PANTS BEIGE
26213 RUDIE'S (ルーディーズ) SAVANNA SHORTS BLACK
26601 Zephyren (ゼファレン) TIE DYE TRIBAL MESH SHORTS BLACK
29173 Subciety (サブサエティ) OMBRE CHECK WESTERN SHIRT L/S-Praha- RED
29404 NineMicrophones (ナインマイクロフォンズ) CHECK SHIRT L/S-Comrade- BLACK
33376 Zephyren (ゼファレン) ALOHA SHORTS WHITE
33513 Zephyren (ゼファレン) ALOHA SHIRT S/S -Resolve- NAVY
39586 Subciety CHECK SHIRT GREEN
39587 Subciety CHECK SHIRT NAVY
40042 Zephyren BIG SHIRT S/S -Resolve- GEO WHITE
42385 LILWHITE(dot) (リルホワイトドット) LW-18AW-S01 -STATEMENT- HOODIE BLACK
45726 LILWHITE(dot) LW-19SS-B01 "INFERIOR" SWEAT PANTS BLACK
46243 Subciety(サブサエティ) CAMOUFLAGE SHIRT-BABYLON-
49883 Zephyren(ゼファレン)LONG SHIRT S/S -Resolve- BLACK / 如意宝珠
49884 Zephyren(ゼファレン)LONG SHIRT S/S -Resolve- WHITE / 如意宝珠
50905 Subciety (サブサエティ) CHECK SHIRT -TAG- RED
52069 Zephyren(ゼファレン) DEFORMATION PANTS BLACK
53231 Zephyren(ゼファレン)SWITCHING SHIRT S/S BLACK
54998 Zephyren(ゼファレン)LONG SHIRT L/S PAINT
36779 DISTURBIA CLOTHING TRYALS BOOT
20011 ROLLING CRADLE FUCK×FUCK SHIRT / White
37184 VIRGO NATIVE CIRCLE L/S NATURAL
37506 VIRGO NY side line set pants NAVY
37600 ROLLING CRADLE CRAZY COLOR BOA SHORTS / Red-Navy
37601 ROLLING CRADLE CRAZY COLOR BOA SHORTS / Charcoal-Purple
37774 THRASHER TH5088 ANTI-LOGO COACH BLK/WHT
39850 VIRGO DIAGONAL DAMAGED Charcoal
41694 ROLLING CRADLE FLORAL SHORTS / White
42766 VIRGO VG-PT-287 VGW swimsuit2 水陸両用ショーツ BLK/CHA
42767 VIRGO VG-PT-287 VGW swimsuit2 水陸両用ショーツ PP/WHT
43412 NOVE NV-009S70 DENIM INDIGO
43499 NOT COMMON SENSE FRANKEN 2 L/S TEE WHITE
43500 NOT COMMON SENSE FRANKEN 2 L/S TEE BLACK
43501 NOT COMMON SENSE FRANKEN 2 L/S TEE S/GREEN
46185 NOT COMMON SENSE MAD DOG LAYERED L/S TEE WHITE×RED
47764 VIRGO VG-SH-199 MICROCOSM SHIRTS WHITE
48381 ROLLING CRADLE OXFORD SHIRT / White
48382 ROLLING CRADLE OXFORD SHIRT / Blue
23004 Subciety ALOHA SHIRT S/S NAVY
37185 ANIMALIA AN17A-SW07 WANNABE BLACK
10070 MISHKA (ミシカ) ANIMAL PARADE BUTTON UP STORMY BLACK
10071 MISHKA (ミシカ) TERRITORY BUTTON UP WHITE
11097 MISHKA (ミシカ) THE HELLA STUFF S/S BUTTONDOWN WHITE
14649 NineMicrophones PATCHWORK SWEATER BLACK/BURGUNDY
15231 ZEPHYREN (ゼファレン) ZIP PARKA -SKULL HEAD- BLK
15758 MISHKA (ミシカ) Crypt Keeper Button Up Shirt
15898 Subciety CHECK SHIRTS L/S-Conductor- GRAY
16508 Subciety PARKA-LARGE GLORIOUS- BLACK
17198 Zephyren WORK SHORTS - BEIGE
18360 Subciety EMBLEM SHIRT L/S - BLACK.STAR
18412 Subciety ZIP PARKA-NX- - BLACK
23021 Subciety OMBRE CHECK SHIRT S/S-THRON- MUSTARD
23022 Subciety OMBRE CHECK SHIRT S/S-THRON- RED
25616 Subciety EMBLEM SHIRT L/S MUSTARD
25711 Subciety PARKA-SALOON- BLACK
26378 Zephyren (ゼファレン) CHECK SHIRT S/S -Resolve- WHITE
26379 Zephyren (ゼファレン) CHECK SHIRT S/S -Resolve- RED
26380 Zephyren (ゼファレン) CHECK SHIRT S/S -Resolve- NAVY
26381 Zephyren (ゼファレン) CHECK SHIRT S/S -Resolve- GRAY
29168 Subciety (サブサエティ) EMBLEM SHIRT L/S-CHECK- BLUE
29983 BLACK SCALE HARA-KIRI TEE BLACK
29985 BLACK SCALE STOMACH PAIN TEE WHITE
29986 BLACK SCALE STOMACH PAIN TEE BLACK
29987 BLACK SCALE TREATED WORLD TOUR TEE BLACK
29989 BLACK SCALE WING TEE WHITE
29990 BLACK SCALE WING TEE BLACK
29991 BLACK SCALE ENDOPLASMATIC TEE WHITE
29992 BLACK SCALE ENDOPLASMATIC TEE BLACK
33076 Zephyren (ゼファレン) S/S SHIRT -CocaCola- WHITE
33077 Zephyren (ゼファレン) S/S SHIRT -CocaCola- BLACK
33373 Zephyren (ゼファレン) STAND COLLAR SHIRT S/S -Resolve- WHITE
34488 ALIVE ALIVE x DRAGON BALL “Capsule Corporation” White
34523 MUSIC SAVED MY LIFE (MSML) SLEEVELESS HOODIE BROWN
34853 NineMicrophones INDIGO CHECK SHIRT L/S RED
34855 NineMicrophones INDIGO CHECK SHIRT L/S KHAKI
34856 NineMicrophones TWIST CHECK SHIRT L/S BLACK
37921 Subciety (サブサエティ) COACH JACKET-lithium- RED/WHITE
41692 Subciety BANDANNA SHORTS BLACK
41693 Subciety BANDANNA SHORTS RED
41811 Subciety CHECKER BASKET SHORTS BLUE
42896 REBEL8 FUCKED UP COACHES JACKET CAMO
43381 MISHKA (ミシカ) EX18SH01 SHOES
44103 REBEL8 Roach Pullover Black
44107 REBEL8 Laurels Coach Jacket Black
45146 NineMicrophones COACH JACKET-STAY REAL- GREEN
45549 Subciety (サブサエティ) NOCOLLAR EMBLEM SHIRT WHITE
46735 Subciety(サブサエティ) 105-20122 EMBLEM SHIRT L/S CHARCOAL
47360 RUDIE'S (ルーディーズ) PHAT SHORTS BLACK
47364 RUDIE'S (ルーディーズ) HOOK WORK SHORTS BEIGE
50424 NineMicrophones PARKA-9MC LOCO- SILVER
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[order] => price_high
[sale] => 1
[page] => 2
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&order=price_high&sale=1&page=2
--------
mb_parse_str
Array
(
[work] => new_arrival
[order] => price_high
[sale] => 1
[page] => 2
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&order=price_high&sale=1&page=2