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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =17
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-22 16:06:43')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
57319 TOY MACHINE NEW BLOOD LOGO SIX PANEL CAP(SMOKE PINK)
57320 TOY MACHINE FLAME FIST MEBROIDERY SIX PANEL CAP(GREEN TEA)
57309 【予約商品】HEDWiNG Flamingo Skater Cap Black
57310 【予約商品】HEDWiNG Flamingo Skater Cap Off pink
56401 Subciety SNAP BACK CAP-SERVER- BLACK/WHITE
57102 Zephyren 2021 NEW YEAR BAG
57221 TOY MACHINE CLAIRVOYANT BB CAP - BLACK
57222 TOY MACHINE CLAIRVOYANT BB CAP - WHITE
56339 NineMicrophones SNAP BACK CAP-NM/CS- BLACK/RED
57205 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 WHITE
57204 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 BLACK
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
57063 ANIMALIA AN20A-CP03 “R.I.B.” BOMBER CAP BLACK
57064 ANIMALIA AN20A-CP03 “R.I.B.” BOMBER CAP OLIVE
56960 MAGICAL MOSH MISFITS MxMxM モコモコ PILOT CAP(2WAY) BLACK
55798 【バンドリ!×ゲキクロ 第2弾復刻】PSYCHOLOGICAL METAMORPHOSIS×戸山香澄コラボ 限定 キャップ
55790 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 キャップ
55786 【バンドリ!×ゲキクロ 第2弾復刻】HEDWiNG×山吹沙綾コラボ 限定 キャップ
55766 【バンドリ!×ゲキクロ 第2弾復刻】SABBAT13×宇田川あこコラボ 限定 キャップ
55762 【バンドリ!×ゲキクロ 第2弾復刻】アマツカミ×白金燐子コラボ 限定 キャップ
55758 【バンドリ!×ゲキクロ 第2弾復刻】KAVANE Clothing×レイヤ コラボ 限定 キャップ
55750 【バンドリ!×ゲキクロ 第2弾復刻】UNUSUAL×マスキング コラボ 限定 キャップ
55742 【バンドリ!×ゲキクロ 第2弾復刻】RUDIE'S×チュチュ コラボ 限定 キャップ
56300 RIP DESIGN WORXX Ashly Smileローキャップ
56813 AC/DC UNISEX BASEBALL CAP: RED LOGO
55995 ROLLING CRADLE NEW ERA CAP 59FIFTY-CIRCLE LOGO- / NAVY
56215 Anti Social Social Club Headrush Cap
55672 RIP DESIGN WORXX ディスグースマスクキャップ BLACK
56164 MUSIC SAVED MY LIFE (MSML) BOX LOGO DAD CAP BLACK
56165 MUSIC SAVED MY LIFE (MSML) BOX LOGO DAD CAP WHITE
55880 GoneR -La Neta- GRL02CP001 Logo Cotton Twill Cap Camo
55884 GoneR -La Neta- GRL02CP001 Logo Cotton Twill Cap Black
55882 GoneR -La Neta- GRL02CP001 Logo Cotton Twill Cap Heather Gray
55886 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Black
55881 GoneR -La Neta- GRL02CP001 Logo Cotton Twill Cap Stone
55885 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Baige
56145 Unlucky Morpheus GOSTA×ANKM コラボキャップ
45600 Zephyren(ゼファレン)LO CAP - PROVE - WHITE
55544 HEDWiNG Graffiti Logo Cap
38450 Zephyren (ゼファレン) LONG STRAP LO CAP -ENGRAVE- WHITE
54753 KAVANE Clothing "FLARE"CAP
55945 TOY MACHINE TOYMONSTER BB CAP - BLACK
35493 RUDIE'S SPARK SNAPBACK CAP WHT/BLK
24859 RUDIE'S PHAT SNAPBACKCAP BLACK
52880 【バンドリ!×ゲキクロ 第5弾】KAVANE Clothing×北沢 はぐみコラボ 限定 キャップ
52886 【バンドリ!×ゲキクロ 第5弾】HEDWiNG×奥沢 美咲コラボ 限定 キャップ
54465 【バンドリ!×ゲキクロ第1弾復刻】MISHKA×戸山香澄コラボ 限定 キャップ
54499 【バンドリ!×ゲキクロ第1弾復刻】acOlaSia×今井リサコラボ 限定 キャップ
54504 【バンドリ!×ゲキクロ第1弾復刻】SABBAT13×宇田川あこコラボ 限定 キャップ
55673 RIP DESIGN WORXX ディスグースマスクキャップ CREAM
55640 Anti Social Social Club WEIRD CAP BLACK
55641 Anti Social Social Club ASHTON BLACK CAP
47820 Subciety SNAP BACK CAP-THE BASE- BLACK/WHITE
47822 Subciety SNAP BACK CAP -GLORIOUS- BLACK/WHITE
52821 Subciety LOW CAP ORANGE
52609 GoneR -La Neta- La Neta 6 Panel Cap WHITE/BLACK
52610 GoneR -La Neta- La Neta 6 Panel Cap BEIGE/BLACK
52611 GoneR -La Neta- La Neta 6 Panel Cap CAMO/BLACK
9234 Subciety MESH CAP -OMG- DARK GREEN
11110 REBEL8 STANDARD ISSUE LOGO NEW ERA
13478 MISHKA (ミシカ) DEATH ADDER TIE DYE NEW ERA PURPLE
14305 MISHKA (ミシカ) DEATH ADDER NEW ERA BURGUNDY
17532 MISHKA (ミシカ) ETERNAL KEEP WATCH NEW ERA 5950
24600 ROLLING CRADLE RC LOGO NEW ERA CAP -CLASSIC- / Navy
24601 ROLLING CRADLE RC LOGO NEW ERA CAP -CLASSIC- / Blue-Red
27814 Crossfaith Snapback(2016Spring)
27818 Crossfaith 2016 SUMMER SILVER 5 PANEL
28120 Xmas Eileen 『WORLD COUNTDOWN』メッシュキャップ WHT
28134 KILL STAR CLOTHING (キルスター・クロージング) No Fun Snapback [B]
29067 ANIMALIA AN16A-CP03 CAP BLACK
32199 Gluttonous Slaughter (グラトナス・スローター) BDC CAP -BRUTAL- スナップバックキャップ
34467 REBEL8 BOGEY STRAPBACK PINK
35541 REBEL8 Discarded Paradise Snapback
36926 VIRGO VGW CAP WHITE
36927 VIRGO VGW CAP BLACK
36964 フクザワ まったりさん帽子
39304 REBEL8 TERRITORY SNAPBACK
39498 STAY SICK CLOTHING Checkered Flag White
40217 Zephyren LONG STRAP LO CAP -ENGRAVE - SKY
41308 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO CAP BEIGE
41313 PSYCHOLOGICAL METAMORPHOSIS PLMP JET CAP RED
42625 Bentham コーデュロイ ロゴキャップ
42889 NOT COMMON SENSE "NCS"ReMAKE CAP
43112 VIRGO VG-GD-561 VG BERET NAVY
44046 SANTA CRUZ SCREAMING HAND HAT WHITE×BLACK
44047 SANTA CRUZ STRIP HATS BLACK
45142 TOY MACHINE TMP19HW12 PYLAMID SECT EBRO CAP RED
45337 THRASHER 3131363 FLAME OLD TIMER HAT BLACK
45746 ROLLING CRADLE ARIZONA CAP / Red
47340 RIPNDIP Prisma Corduroy 6 Panel (Black)
47341 RIPNDIP Taped Nylon Camper (Black)
47344 RIPNDIP RIPNTAIL Corduroy 6 Panel (White)
47446 ANIMALIA AN19A-CP08 '49 Cap : LOGO BLACKxWHT刺繍
47449 ANIMALIA AN19A-CP08 '49 Cap : LOGO WHITExBLK刺繍
47620 LILWHITE(dot) LW-19SU-H01 “THE END” LOW CAP BLACKxMULTI
47625 LILWHITE(dot) LW-19SU-H03 “NOT A PSYCHIC” LOW CAP ORANGE-CAMO
47632 SANTA CRUZ CLASSIC MID PROFILE SNAPBACK HATS BLACK
47633 SANTA CRUZ CLASSIC DOT HIGH PROFILE MESH TRUCKER HATS BLACK
47635 SANTA CRUZ DOT BLOCKER SNAPBACK UNSTRUCTURED HATS BLACK
47724 ROLLING CRADLE FIRE CAP / Red-Royal
47725 ROLLING CRADLE FIRE CAP / Red-Black
47849 ROLLING CRADLE HANDWRITING LOGO CAP / Red
48246 NOT COMMON SENSE WWF×NCS TS CAP BLACK
48247 NOT COMMON SENSE WWF×NCS TS CAP ORANGE
48318 RIPNDIP Tucked In Dad Hat (White)
48320 RIPNDIP Color Block Two Tone 6 Panel (Tan / Burgundy)
49099 FILA FLH-P04 CAP PURPLE
49100 FILA FLH-P01 RED
49634 RUDIE'S 91CREW PANELCAP PURPLE
49894 RUDIE'S BRISTLE SNAPBACKCAP BLACK
50361 ANIMALIA AN19M-CP02 CORDURA® JET CAP-LOGO BLACK
50362 ANIMALIA AN19M-CP03 CORDURA® BUCKET HAT-LOGO BLACK
50482 FILA CAP
50484 FILA CAP Heritage BLACK
51211 TOY MACHINE TMF19HW17 EMBRO CORDY CAP BLACK
51212 TOY MACHINE TMF19HW17 EMBRO CORDY CAP TAN
51281 VANS APPAREL VANS X BAKER JOCKEY BLACK
51283 VANS APPAREL SHALLOW VNOA3161 BLACK
51406 ANIMALIA AN19W-CP03 LOGO SNAPBACK CAP BLACKxWHT刺繍
51407 ANIMALIA AN19W-CP03 LOGO SNAPBACK CAP BLACKxRED刺繍
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 17
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=17
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 17
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=17