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 =1
)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-03-02 04:15:57')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
57968 【バンドリ!×ゲキクロ 第6弾】HEDWiNG×桐ヶ谷透子コラボ 限定 Tシャツ
58075 【バンドリ!×ゲキクロ 第6弾】KAVANE clothing×二葉つくしコラボ 限定 Tシャツ
57965 【バンドリ!×ゲキクロ 第6弾】CIVARIZE×八潮瑠唯コラボ 限定 Tシャツ
58072 【予約商品】RUDIE'S x CRAYON SHINCHAN PEACE PKT-T BLACK
58073 【予約商品】RUDIE'S x CRAYON SHINCHAN PEACE PKT-T WHITE
58077 【予約商品】RUDIE'S x CRAYON SHINCHAN MICROPHONE-T BLACK
58078 【予約商品】RUDIE'S x CRAYON SHINCHAN MICROPHONE-T ORANGE
58079 【予約商品】RUDIE'S x CRAYON SHINCHAN ACTIONKAMEN-T BLACK
58080 【予約商品】RUDIE'S x CRAYON SHINCHAN ACTIONKAMEN-T LAVENDER
58081 【予約商品】RUDIE'S x CRAYON SHINCHAN FAMILY-T BLACK
58082 【予約商品】RUDIE'S x CRAYON SHINCHAN FAMILY-T NATURAL
57236 BRING ME THE HORIZON UNISEX TEE: HEX PHSH COVER (BACK PRINT)
57239 BRING ME THE HORIZON UNISEX TEE: WIPE THE SYSTEM (BACK PRINT)
57270 BRING ME THE HORIZON UNISEX TEE: FLOWERS (BACK PRINT)
58063 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT
58064 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TILT
58065 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TAPED
58066 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT PHOTO
58050 【予約商品】XrossOverBig SilhouetteT (Black)
58051 【予約商品】XrossOverBig SilhouetteT (White)
58052 【予約商品】XrossOver XOver logoT (Black)
58053 【予約商品】XrossOver XOver logoT (White)
58034 TOY MACHINE MONSTER 3/4 SLEEVE TEE-BLACK
58033 TOY MACHINE MONSTER 3/4 SLEEVE TEE-WHITE
58035 TOY MACHINE SECT MARK PRINT SS TEE - WHITE
58036 TOY MACHINE SECT MARK PRINT SS TEE - BLACK
58018 THRASHER TH91292 T-Shirt BLACK
58019 THRASHER TH91292 T-Shirt WHITE
58020 THRASHER TH91292 T-Shirt PINK
58021 THRASHER TH91292 T-Shirt GREEN
56609 PUNK DRUNKERS 大統領TEE - WHITE
57812 PARADOX SELECTABLE LAYERED T-SHIRTS BLACK×WHITE
57813 PARADOX SELECTABLE LAYERED T-SHIRTS BLACK×BURGUNDY
57810 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×BLACK
57811 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×MINT
57801 BRING ME THE HORIZON Label Rip Yellow Amo T-shirt
8372 FALLING IN REVERSE Lips T-Shirt BLACK
15470 CROWN THE EMPIRE Beak White T-Shirt
36803 LINKIN PARK Angels t-shirt
57798 CRADLE OF FILTH Krampus T-shirt + ornament
57799 CRADLE OF FILTH Blue Wings T-shirt
57802 FEVER333 Black Cat Fever Tee T-shirt
56423 Subciety LABO. S/S - BLACK
56422 Subciety LABO. S/S - WHITE
56664 PUNK DRUNKERS グレイトフルマッポ刺繍TEE - GREEN
56665 PUNK DRUNKERS グレイトフルマッポ刺繍TEE - PURPLE
57384 FILA FS3028 T-Shirt WHITE
57385 FILA FS3028 T-Shirt NAVY
57390 FILA FS3008 T-Shirt WHITE
57391 FILA FS3008 T-Shirt BLACK
57392 FILA FS3021 T-Shirt CHARCOAL
57393 FILA FS3021 T-Shirt BLACK
56142 Unlucky Morpheus Unfinished Tシャツ
57357 MISHKA M21000030 T-Shirt WHITE
57358 MISHKA M21000013 T-Shirt BLACK
57359 MISHKA M21000013 T-Shirt WHITE
57360 MISHKA M21000013 T-Shirt GREEN
57361 MISHKA M21000059 T-Shirt BLACK
57362 MISHKA M21000059 T-Shirt YELLOW
57363 MISHKA M21000059 T-Shirt ORANGE
56777 KEYTALK×GEKIROCK CLOTHING 限定コラボ・Tシャツ WHITE
56776 KEYTALK×GEKIROCK CLOTHING 限定コラボ・Tシャツ BLACK
56932 TEARS OF TRAGEDY×GEKIROCK CLOTHING 限定コラボ・Tシャツ BLACK
56933 TEARS OF TRAGEDY×GEKIROCK CLOTHING 限定コラボ・Tシャツ WHITE
57294 BRING ME THE HORIZON UNISEX TEE: PARASITE (BACK PRINT)
55894 SALUTE WASHED FLOWER VINTAGE TEE PURPLE
57237 BRING ME THE HORIZON UNISEX TEE: LOVE (BACK PRINT)
57238 BRING ME THE HORIZON UNISEX TEE: THE END (BACK PRINT)
35590 BRING ME THE HORIZON COLOURS T-SHIRTS
45659 BRING ME THE HORIZON AMO SYMBOLS TEE
45950 BRING ME THE HORIZON WONDERFUL LIFE BLACK
45949 BRING ME THE HORIZON HEXAGRAM AMO SMALL YELLOW
45951 BRING ME THE HORIZON PLASMA TEE BLACK
43351 BRING ME THE HORIZON ALIEN TEE
50311 BRING ME THE HORIZON CROOKED YOUNG (APPLIQUE MOTIFS)
50312 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) charcoal
50313 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) NAVY/RED
35566 BRING ME THE HORIZON CANYON T-Shirts
35578 BRING ME THE HORIZON GOAT T-SHIRTS
36532 BRING ME THE HORIZON -Sempiternal- Black T-Shirt
56066 Subciety 2021 福袋 -NEW YEAR BAG-
57102 Zephyren 2021 NEW YEAR BAG
57205 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 WHITE
57204 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 BLACK
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
56322 NineMicrophones Lipsand Microphone S/S WHITE
56323 NineMicrophones Lipsand Microphone S/S GRAY
56325 NineMicrophones NM/CS S/S BLACK
56326 NineMicrophones NM/CS S/S BURGUNDY
57089 RUDIE'S RUDIE'S x BYRD / LOOK SLICK-T BLACK
57090 RUDIE'S RUDIE'S x BYRD / LOOK SLICK-T WHITE
55759 【バンドリ!×ゲキクロ 第2弾復刻】KAVANE Clothing×レイヤ コラボ 限定 Tシャツ
55755 【バンドリ!×ゲキクロ 第2弾復刻】acOlaSia×ロック コラボ 限定 Tシャツ
55751 【バンドリ!×ゲキクロ 第2弾復刻】UNUSUAL×マスキング コラボ 限定 Tシャツ
55747 【バンドリ!×ゲキクロ 第2弾復刻】DI:VISION×パレオ コラボ 限定 Tシャツ
55743 【バンドリ!×ゲキクロ 第2弾復刻】RUDIE'S×チュチュ コラボ 限定 Tシャツ
54608 FOG ESSENTIALS Essentials Boxy Photo Series T-Shirt White
55801 FOG ESSENTIALS "LA"Limit Tee White
55802 FOG ESSENTIALS "LA"Limit Tee Black
56045 【ゲキクロ限定】KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"OVERSIZE CUTSEW(ゲキクロ限定カラー)
56043 KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"OVERSIZE CUTSEW(Blk)
56044 KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"OVERSIZE CUTSEW(Wht)
4598 NIRVANA SMILE T-Shirt
10233 METALLICA DORRIS T-Shirt
36530 BRING ME THE HORIZON PAINTED T-Shirt
45953 Crossfaith ORNAMENT TEE BLACK
52713 BABYMETAL LOGO TEE
52903 MY CHEMICAL ROMANCE UNISEX TEE: SHREDDED
52908 KORN UNISEX TEE: SCRATCHED TYPE (BACK PRINT)
54743 FOO FIGHTERS UNISEX TEE: FLASH WINGS
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
55729 OASIS UNISEX TEE: DECCA LOGO BLACK
55732 SLAYER UNISEX TEE: REPENTLESS
56810 AC/DC UNISEX TEE: ANGUS STATUE
56811 AC/DC UNISEX FASHION TEE: BLACK ICE (BURN OUT)
56812 AC/DC UNISEX TEE: THOSE ABOUT TO ROCK
56820 THE 1975 UNISEX TEE: BLACK TOUR
56821 THE 1975 UNISEX TEE: ABIIOR SIDE FACE TIME (BACK PRINT)
56822 BILLIE EILISH UNISEX TEE: SWEET DREAMS
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 1
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=1
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 1
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=1