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-22 04:04:05')
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 0, 120
41377 Subciety (サブサエティ) VARSITY JACKET RED
29939 PUNK DRUNKERS ロング丈でかPスタジャン BLUE
40004 VIRGO CRAZY OVER DYE INDIGO JKT NAVY
56971 NOT COMMON SENSE CIRCLELOGO C/N RIPSTOP OZONE WASHINGJACKET BLACK
44192 NOT COMMON SENSE VELCRO NYLON JKT BLACK / BROWN
41375 Subciety (サブサエティ) CHECK BDU JKT RED
47024 NOVE NV-001N D060 DENIM IND
43410 NOVE NV-001D 048 DENIM INDIGO
43393 VIRGO VG-JKT-197 VGW COVERALLS カバーオール BLACK
40563 VIRGO SNEAKERS SOLE MIDDLE BOOTS ミドルブーツ BLACK
27915 LILWHITE. (リルホワイト) -F/B-LONG COACH JKT OLIVE
56522 SILLENT FROM ME VEIN -Cable Knit Sweater- WHITE
43409 NOVE NV-001D 045 DENIM INDIGO
51307 LILWHITE(dot) LW-19AW-J02 "SYSTEM" TRACK JKT (BLK)
51308 LILWHITE(dot) LW-19AW-J02 "SYSTEM" TRACK JKT (ORG)
41968 Zephyren(ゼファレン) DENIM JACKET HARD WASH II / BANNDANNA
20282 REBEL8 WOMENS BOLTED VARSITY JACKET
34489 ALIVE ALIVE x DRAGON BALL “4 Star Ball”
44838 KILL STAR CLOTHING Lisa Luna Padded Velvet Jacket
45961 KONUS K-49440 Pullover Hoodie w/ Acid Wash Black
47022 NOVE NV-009S110 DENIM IND
47645 RIPNDIP Repeat Cotton Twill Jacket (Black)
37759 REBEL8 Foretold Jacket
42555 DISTURBIA CLOTHING Requiem Bomber
56115 SILLENT FROM ME CULTISM Long Length Shirts BLK
56116 SILLENT FROM ME CULTISM Long Length Shirts WHT
17195 ZEPHYREN (ゼファレン) CARGO SHORTS - KHAKI
44195 NOT COMMON SENSE NS NYLON PANTS BLACK / RED
45939 NOT COMMON SENSE DOBBY CHECK PANTS D/GREEN CK
32556 VIRGO Fortress Big Hood Parka BLACK
32557 VIRGO Fortress Big Hood Parka GRAY
37192 VIRGO CAT HAND MOHAIR CARDIGAN BLACK
38778 VIRGO Gradation check middle shirts BLACK
44325 VIRGO OREO SWITCH KNIT VG-KNIT-74 BLACK
21762 ICECREAM INDIANS HOODIE WHITE
23784 KILL STAR CLOTHING (キルスター・クロージング) Midnight Bomber Jacket [B]
28215 REBEL8 WOMENS BUFFALO STANCE COAT
42560 DISTURBIA CLOTHING Sweet Jane Shoes
42561 DISTURBIA CLOTHING Violet Shoes
51605 MUSIC SAVED MY LIFE M101-02L1-SS02 CRAZY PATTERN SHIRT BLACK
51606 MUSIC SAVED MY LIFE M101-02L1-PS01 CROSSES WIDE SHORTS BLACK
51613 MUSIC SAVED MY LIFE M101-02L1-PL01 2LINE JERSEY PANTS BLACK×GREEN
51658 MUSIC SAVED MY LIFE M201-02L1-SS01 OPEN COLLAR SHORT SLEEVE SHIRT BLACK
33433 VIRGO Loose atmosphere cardigan BLACK
33434 VIRGO Loose atmosphere cardigan CHARCOAL
39123 VIRGO HARD GAUGE KNIT NAVY
40007 VIRGO GUITARIST DOLMAN SHIRTS RED
40582 VIRGO HARD GAUGE KNIT ニット BLACK
42462 SABBAT13 SBT-PK-023 PATCH HOODIE(ブラック)
42463 SABBAT13 SBT-PK-023 PATCH HOODIE(イエロー)
43498 NOT COMMON SENSE FRANKEN HOODIE BLACK
43944 VIRGO VG-SH-191 VA-1 SHIRTS KHAKI
25380 BLACK SCALE REBEL SLAM CREWNECK BLK
25381 BLACK SCALE REBEL SLAM CREWNECK GRY
54170 SILLENT FROM ME VICTOR -Slim Slacks- GRAY CHECK
22363 SQUARE SETUP 2WAY SWEAT HOODY INDIGO/GRAY
29947 VIRGO COEXISTENCE PARKA NATURAL
46333 NOT COMMON SENSE NCS REMAKE LAYERED L/S TEE BLACK
46753 FILA FM9546 Jacket Flame red
46792 KONUS K-61403 Stretch Tweill Relaxed Pants Red
56198 NOT COMMON SENSE REBUILDING BREACH SHIRT
21408 FAMOUS STARS AND STRAPS PUBLIC ENEMY Coaches
23261 REBEL8 WOMENS INSTROSPECTIVE RAIN JACKET
24447 GLAMOUR KILLS THE RAINY DAZE RAINCORT
24983 PUNK DRUNKERS ベスト30パッカブルパーカ BLACK
25387 BLACK SCALE KLIMEK HOODIE BLK
28181 RUDIE'S (ルーディーズ) FOUNDATION SLIM PANTS INDIGO
34532 MUSIC SAVED MY LIFE (MSML) GRUNGE SHIRT BLUE
34533 MUSIC SAVED MY LIFE (MSML) GRUNGE SHIRT RED
37456 RUDIE'S (ルーディーズ) BRILLIANT CHECK HOOD SHIRTS RED
37514 RUDIE'S (ルーディーズ) DRAWING LONG SHIRTS NATIVE BLACK
38443 Zephyren (ゼファレン) BANDANA SHORTS CAMO
39864 MISHKA (ミシカ) MSP160527 JKT
41450 Subciety (サブサエティ) WOOL SLACKS BLACK
41452 Subciety (サブサエティ) WOOL SLACKS GRAY
42994 NineMicrophones CHECK SHIRT RED
45158 Zephyren(ゼファレン)MID CUT SNEAKER BLACK
45547 Subciety (サブサエティ) CHECK SHIRT YELLOW
45548 Subciety (サブサエティ) CHECK SHIRT PURPLE
47067 RUDIE'S (ルーディーズ) SPARK BACKPACK RED
50377 Zephyren(ゼファレン) SWITCHING SHIRT L/S MIX
51665 MUSIC SAVED MY LIFE M201-02L1-PS02 NYLON SARROUEL SHORTS BLACK
52761 Subciety MARIA WORK SHIRT WHITE
52764 Subciety PAISLEY DROP SHOULDER SHIRT BLACK
52765 Subciety PAISLEY DROP SHOULDER SHIRT NAVY
53947 NOT COMMON SENSE ”NCS FILM” HOODIE
54135 SILLENT FROM ME SHHH -Long Length Parka- BLACK
55012 Zephyren(ゼファレン)BIG SHIRT L/S - As above,So below - RED
45752 RIPNDIP Boobcuzzi Coaches Jacket (White)
15843 ROLLING CRADLE SWALLOW TAIL SHIRTL / Black/Yellow
38767 SQUARE DAMAGE DENIM SHIRTS
41901 ROLLING CRADLE RC VULGAR PANTS Green
42459 SABBAT13 SBT-SH-010 MORTAL PATCH NELSHIRTS (グリーン)
43087 NOT COMMON SENSE "FLAME" CUT OFF HOODIE BLACK
45577 TOY MACHINE TMP19SW16 FIST EMBRO SWEAT PARKA BLACK
45942 NOT COMMON SENSE FUXX THE POLICE SEAM HOODIE RED
45944 NOT COMMON SENSE GENESIS SEAM HOODIE BLACK
45945 NOT COMMON SENSE GENESIS SEAM HOODIE RED
46192 ROLLING CRADLE CHECK!CHECK!CHECK! SHIRT / Red-Yellow
46233 VIRGO VG-SH-198 LOOSE BIG SHIRTS BLACK
41333 VIRGO VG-JKT-189 U.N.V big aloha summer jkt BLUE
41334 VIRGO VG-JKT-189 U.N.V big aloha summer jkt WHITE
43055 ANIMALIA AN18A-SW05 SIDE ZIP HOODIE L/S BLACK
45723 LILWHITE(dot) LW-19SS-S03 "SWEETDREAMS" HOODIE BLACK
13728 NineMicrophones PATCHWORK ZIP PARKA -FIGHT-BLK/BGN
13803 Subciety TIE DYE ZIP PARKA-EMOTION- GRAY
14130 Subciety PATTERNED ZIP PARKA-GLORIOUS- BLK/MUS
14244 NineMicrophones PATCHWORKSHIRTS FIGHT BACK BLK/BGD
14245 NineMicrophones PATCHWORKSHIRTS FIGHT BACK BLK/WHT
16504 Subciety ZIP PARKA-LARGE GLORIOUS- BLACK
16507 Subciety ZIP PARKA-LARGE GLORIOUS- CHARCOAL
16686 Subciety ZIP PARKA-PATTERNED ALL OVER- GRAY
18352 Subciety CORDUROY EMBLEM VEST - BLACK
39020 DISTURBIA CLOTHING All-Seeing Hi-Tops Silver
39582 Subciety MULTI CAMO SHIRT S/S
40634 RUDIE'S (ルーディーズ) SPARK BACK PACK GALAXY
42387 LILWHITE(dot) (リルホワイトドット) LW-18AW-S02 -REFLECTED- HOODIE BLACK
42412 LILWHITE(dot) LW-18AU-B01 -STATEMENT- SIDE LINE SWEAT PANTS RED
45718 LILWHITE(dot) LW-19SS-S01 "PLATE LOGO" HOODIE WHITE
45721 LILWHITE(dot) LW-19SS-S02 "NIGHTHEAD" HOODIE BLACK
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[order] => price_high
[sale] => 1
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&order=price_high&sale=1&
--------
mb_parse_str
Array
(
[work] => new_arrival
[order] => price_high
[sale] => 1
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&order=price_high&sale=1