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 >= '2021-01-27 22:15:03')
AND pc.stock > 0
AND pc.price03 IS NOT NULL
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
39981 SILLENT FROM ME MESS -Pullover- Black
51279 SILLENT FROM ME KNOWLEDGE -Wool Slacks- BLACK
47650 RIPNDIP RIPNTAIL Hoodie (Black)
50668 Subciety (サブサエティ) SPORT JACKET BLACK
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
54656 MISHKA(ミシカ) MSS200830 PANTS
7616 Subciety EMBROIDERY POLO S/S MUSIC DESTROY BLACK
5070 Subciety PRAYING HANDS R-L/S BK/WH
6317 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK BLACK
6616 MISHKA The Keep Watch or Die Tank in Navy
9182 MISHKA (ミシカ) RAKE CPO JACKET ARMY GREEN
9306 MISHKA (ミシカ) KEEP WATCH CARDIGAN RED BERRY
10027 MISHKA (ミシカ) AOD NECRONOMICON CREWNECK BLACK
13324 MISHKA (ミシカ) CREEPING DEATH SPLIT ZIP HOODIE BLACK
13515 RUDIE'S ENOUGH ZIPHOOD SW BLACK
13516 RUDIE'S ENOUGH ZIPHOOD SW GRAY
13800 Subciety TIE DYE PARKA-GLORIOUS- BGN
13803 Subciety TIE DYE ZIP PARKA-EMOTION- GRAY
14130 Subciety PATTERNED ZIP PARKA-GLORIOUS- BLK/MUS
14237 Subciety EMBROIDERY ZIP PARKA CHARCOAL/TRIBE CROSS
14587 ROLLING CRADLE FAT STRIPE SLIM SHIRT /Blue
14720 ROLLING CRADLE PYRAMID POWER FLEECE JKT / Navy
14809 THRASHER GIRL'S OG DIAMOND LOGO ZIP
14843 MISHKA (ミシカ) AUTOPS DEATH ZIP UP HOODIE
15211 ZEPHYREN (ゼファレン) EMBROIDERY SHIRT -Charmed- GRAY/CHECK
15231 ZEPHYREN (ゼファレン) ZIP PARKA -SKULL HEAD- BLK
15662 ZEPHYREN (ゼファレン) SWEAT -VISIONARY- BLK
15842 ROLLING CRADLE SWALLOW TAIL SHIRTL / Gray/Red
15843 ROLLING CRADLE SWALLOW TAIL SHIRTL / Black/Yellow
15898 Subciety CHECK SHIRTS L/S-Conductor- GRAY
16504 Subciety ZIP PARKA-LARGE GLORIOUS- BLACK
16507 Subciety ZIP PARKA-LARGE GLORIOUS- CHARCOAL
16508 Subciety PARKA-LARGE GLORIOUS- BLACK
16686 Subciety ZIP PARKA-PATTERNED ALL OVER- GRAY
16687 Subciety ZIP PARKA-PATTERNED ALL OVER- SOUNDSYSTEM
18360 Subciety EMBLEM SHIRT L/S - BLACK.STAR
18412 Subciety ZIP PARKA-NX- - BLACK
18429 Subciety PARKA-SALOON- - BLACK/RED
18435 Subciety PARKA-New Jack- CHARCOAL/NAVY
19371 ZEPHYREN (ゼファレン) TIE DYE TRIBAL ZIP PARKA GRAY
19408 ZEPHYREN (ゼファレン) TIE DYE PARKA -VISIONARY - NAVY
20037 ZEPHYREN (ゼファレン) ZIP PARKA -Never Despair- BLACK
20639 Subciety SWING TOP-GLORIOUS- KHAKI
20666 Subciety CRAZY CHECK SHIRT L/S-Praha- GREEN
20689 Subciety (サブサエティ) SWEAT S/S-FLAG- BLACK
20699 Subciety SWEAT-CAMOUFLAGE SALOON- BLACK
20716 Subciety PARKA-CAMOUFLAGE SALOON- BLACK
20722 Subciety (サブサエティ) PARKA-COLLEGE- GRAY/BURGUNDY
20732 Subciety SALOON L/S-CAMOUFLAGE- WHITE
20751 Subciety BASEBALL TEE 7/S-COLLEGE- GRAY
20847 Subciety CLIMBING SHORTS BEIGE
21301 ROLLING CRADLE STONED SWEAT / Black
21672 SABBAT13 SCARE PULL-OVER PARKA BLK
21673 SABBAT13 SCARE PULL-OVER PARKA GRY
21732 ROLLING CRADLE WAVELET SHIRT / White
21781 RUDIE'S TUSK STADIUM JKT BLK
21782 RUDIE'S TUSK STADIUM JKT GRY
21981 ROLLING CRADLE MP-LOPS SWALLOW TAIL SHIRT / Olive
21982 ROLLING CRADLE MP-LOPS SWALLOW TAIL SHIRT / Blue
22007 ROLLING CRADLE Sotrm trooper Sweat BLK
22148 Subciety EMBLEM HEAVY FLANNEL SHIRT BLACK
22355 Zephyren (ゼファレン) PARKA -Zephees- BLK
22510 SABBAT13 ARCH ZIP-PARKA (BK)
22511 SABBAT13 MORTAL PARKA (BK)
22590 Zephyren (ゼファレン) CHECK SHIRT L/S -Resolve- NAVY
22849 ROLLING CRADLE UNREASONABLE MONSTER SWEAT / White
22888 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- BLACK/BURGUNDY
22921 Zephyren (ゼファレン) GEKIROCK CLOTHING x Zephyren LONG SHIRT MUSTARD YELLOW
22953 ROLLING CRADLE BOX BOX FOAM LOGO HOODIE / Red
22959 Zephyren (ゼファレン) CAMOUFLAGE SHIRT L/S -Charmed SQ Tone- CAMO I
23616 ROLLING CRADLE RC THUNDER OX SHIRT / White-Red
23617 ROLLING CRADLE RC THUNDER OX SHIRT / White-Black
23705 THRASHER SKATE AND DESTROY WORK SHIRT OD
23712 THRASHER MAG emb Oxford L/S SHIRTS WHT
23738 ROLLING CRADLE FREAK OUT LONG Tee / Gray
23739 ROLLING CRADLE FREAK OUT LONG Tee / Red
23740 ROLLING CRADLE FREAK OUT LONG Tee / Black
23887 ROLLING CRADLE FLUFFY HALF HOODIE / Red
24783 ZEPHYREN (ゼファレン) TIE DYE TRIBAL PARKA -Resolve - NAVY
25345 PARADOX SOUVENIR PULLOVER PINK
25572 Subciety EMBLEM SHIRT HOODY RED
25616 Subciety EMBLEM SHIRT L/S MUSTARD
25631 Subciety EMBROIDERY SHIRT L/S-GLORIOUS- NAVY
25646 Subciety DOBBY CHECK SHIRT L/S-Praha- BURGUNDY
25647 Subciety DOBBY CHECK SHIRT L/S-Praha- KHAKI
25648 Subciety OMBRE CHECK SHIRT L/S-THRON- BLACK
25649 Subciety OMBRE CHECK SHIRT L/S-THRON- RED
25663 Subciety PAISLEY WORK SHIRT L/S-EMOTION- SAX
25699 Subciety (サブサエティ) PARKA-MUSIC DESTROYー BLACK
25710 Subciety PARKA-SALOON- WHITE
25711 Subciety PARKA-SALOON- BLACK
27111 Zephyren (ゼファレン) CAMOUFLAGE QUILT PARKA GREEN
27196 Zephyren (ゼファレン) HEAVY WEIGHT ZIP PARKA -BEYOND- GRAY
28852 THRASHER TH8501TD2 MAG LOGO HOODIE WHT/BLUE
28854 THRASHER TH8501TD2 MAG LOGO HOODIE YEL/YEL
28855 THRASHER TH8501TD2 MAG LOGO HOODIE RED/RED
28863 THRASHER TH8503SE SKATE AND DESTROY HOODIE BLACK
28864 THRASHER TH8503SE SKATE AND DESTROY HOODIE GRAY
28873 THRASHER TH8501SD2 MAG LOGO HOODIE BLK
28877 THRASHER TH8508SD2 FLAME LOGO HOODIE BLK
29164 Subciety (サブサエティ) EMBLEM SHIRT L/S-CAMOUFLAGE- BLACK
29168 Subciety (サブサエティ) EMBLEM SHIRT L/S-CHECK- BLUE
29169 Subciety (サブサエティ) EMBLEM SHIRT L/S-CHECK- YELLOW
29173 Subciety (サブサエティ) OMBRE CHECK WESTERN SHIRT L/S-Praha- RED
29174 Subciety (サブサエティ) OMBRE CHECK WESTERN SHIRT L/S-Praha- BLUE
29219 Subciety (サブサエティ) PARKA S/S-SURF BEAT- BLACK
29698 SABBAT13 MORTAL ZIP-PARKA GREY
29845 RUDIE'S DRAWING LONG CHECK SHIRTS BLACK
29847 RUDIE'S PHAT REFLECT WORK PANTS NAVY
29923 Subciety (サブサエティ) Subciety×MarkGonzales COACH JACKET WHITE
29939 PUNK DRUNKERS ロング丈でかPスタジャン BLUE
30108 MISHKA (ミシカ) EAD END CREWNECK WHITE
32215 ROLLING CRADLE MAGIC BALL SWEAT BLACK
33611 MISHKA (ミシカ) Lamour Keep Watch Crewneck
34088 Zephyren(ゼファレン) ZIP PARKA -melt hand- BURGUNDY
34523 MUSIC SAVED MY LIFE (MSML) SLEEVELESS HOODIE BROWN
34524 MUSIC SAVED MY LIFE (MSML) SLEEVELESS HOODIE NAVY
34589 Subciety (サブサエティ) CARDIGAN-rockabilly- BLACK
34594 Subciety (サブサエティ) LONG KNIT OLIVE-DRAB
34597 Subciety (サブサエティ) SWEAT-Hemp GLORIOUS- ORANGE
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[sale] => 1
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&sale=1
--------
mb_parse_str
Array
(
[work] => new_arrival
[sale] => 1
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&sale=1