SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, 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 =587
)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 >= '2024-04-28 03:17:42')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
27484 MISHKA (ミシカ) JV KEEP WATCH BASKETBALL JERSEY White
45564 GALFY 色絶妙ナイロンジャケット BLACK
13366 IRON FIST CLOTHING CALICO JACK JERSEY ROMPER BLACK
13869 FAMOUS STARS AND STRAPS BUBBLE JERSEY V-Neck MINT
14984 Agape Attire GLORY TO THE KING BASEBALL JERSEY
15025 DROP DEAD CLOTHING Deezel Arches Baseball Jersey
16394 NineMicrophones GAME SHIRT-Sixth man- RED
16785 FAMOUS STARS AND STRAPS TRISTAR JERSEY
17421 MISHKA (ミシカ) ETERNAL VOYAGE FOOTBALL JERSEY
17434 SPITFIRE Speedhead Jersey T-Shirt
17460 ICECREAM MAJESTIC PLAYERS JERSEY BLUE
18750 NineMicrophones BASEBALL SHIRT -Comrade- - BLACK
18752 NineMicrophones BASEBALL SHIRT -Comrade- - NAVY
18840 MISHKA (ミシカ) BLIND SPOT BASKETBALL JERSEY
18874 MISHKA (ミシカ) LAMOUR GRAPPLER BASEBALL JERSEY Teal/Red
18875 MISHKA (ミシカ) DEATH RAY MESH JERSEY TANK TOP
18989 ATTILA A Logo Black Baseball Jersey
19167 ROLLING CRADLE STRIPE CAMO BB-SHIRT / Blue
20117 KILL STAR CLOTHING ADDAMS CROP TOP [MESH]
20340 SUICIDAL TENDENCIES JERSEY SHORTS
20402 DROP DEAD CLOTHING Smudge Jersey
20559 PALISADES Mind Games Black Jersey
20592 FAMOUS STARS AND STRAPS BARON JERSEY TANK
20593 FAMOUS STARS AND STRAPS LOCKED IN JERSEY TANK
21200 Stay Sick Clothing 666 Black - Hockey Jersey
21208 Stay Sick Clothing Stay Sick White
21746 MISHKA (ミシカ) SPLIT ICONS HOCKEY JERSEY
21897 ROLLING CRADLE SUKA-JERSEY:TIGER / Red
22155 FAMOUS STARS AND STRAPS FIRST STRING MESH JERSEY
22156 FAMOUS STARS AND STRAPS RAISED ON RAP LS MESH JERS
22160 FAMOUS STARS AND STRAPS Misfits Mesh Jersey
22599 MISHKA (ミシカ) Brotherhood KW Jersey Navy
22602 MISHKA (ミシカ) Brotherhood KW Jersey BLK
23660 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) Baseline Jersey Tank WHITE
23661 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) Slapshot Jersey BLACK
24272 DEADHEARTZ DEAD Game shirt GRY
24276 PUNK DRUNKERS あいつフットボールシャツ RED/NAVY
24518 STAY SICK CLOTHING Sick Black
24524 STAY SICK CLOTHING FUK U 2 Black Baseball Jersey
25055 DEADHEARTZ “16SS” BB SHIRT / CAMO
25386 BLACK SCALE GUADALUPE WARM UP JERSEY BLK
25504 ROLLING CRADLE WAIKIKI BASE BALL-SHIRT / Blue
25505 ROLLING CRADLE WAIKIKI BASE BALL-SHIRT / Tropical
26415 RUDIE'S NINEONE COLLEGE GAME SHIRTS BLACK
26416 RUDIE'S NINEONE COLLEGE GAME SHIRTS NAVY
27483 MISHKA (ミシカ) JV KEEP WATCH BASKETBALL JERSEY Black
27488 MISHKA (ミシカ) WE GET OURS BASEBALL JERSEY
27489 MISHKA (ミシカ) KEEP WATCH BASEBALL JERSEY
27860 DISTURBIA CLOTHING ALIEN NATION MESH CROP
28283 STAY SICK CLOTHING Stay Sick Black
29046 PassCode MESH SHORTS / 01
29410 NineMicrophones (ナインマイクロフォンズ) FOOTBALL SHIRT-9MC Crew- BLACK
29411 NineMicrophones (ナインマイクロフォンズ) FOOTBALL SHIRT-9MC Crew- NAVY
30110 MISHKA (ミシカ) Keep Watch Hocky Jersey
31718 DISTURBIA CLOTHING Pris Mesh Hoody
31726 DISTURBIA CLOTHING DIS Hockey Shirt
31776 MARILYN MANSON×KILL STAR CLOTHING Ka-Boom Ka-Boom Hockey Jersey [B]
31780 MARILYN MANSON×KILL STAR CLOTHING Use Your Fist Hockey Team Dress [B]
33224 Zephyren (ゼファレン) MESH SHORTS -ENGRAVE- BLACK
34037 deathsight mesh shorts BLACK
34129 PUNK DRUNKERS ベトベースボールシャツ BLACK
34130 PUNK DRUNKERS ベトベースボールシャツ WHITE
34317 SQUARE JUNK PATTERN MESH TANKTOP Black
34318 SQUARE JUNK PATTERN MESH TANKTOP White
34319 SQUARE JUNK PATTERN MESH TANKTOP Red
34322 SQUARE JUNK PATTERN MESH PANTS RED
34324 SQUARE JUNK PATTERN MESH PANTS White
34325 SQUARE PSYCHO PLANT MESH PANTS Black
34326 SQUARE PSYCHO PLANT MESH PANTS Sky
36626 RIP DESIGN WORXX ベースボールシャツ BLK/WHE
36627 RIP DESIGN WORXX ベースボールシャツ GRY/NVY
36799 METALLICA 1981-Authentic Button Down Baseball Jersey
36811 SLIPKNOT Embroidered and Applique-Authentic Basketball Jersey
36884 deathsight 17S MESH SHIORTS
37333 RIP DESIGN WORXX クラウンタイガーランニングジャージ BLK/WHT
37334 RIP DESIGN WORXX クラウンタイガーランニングジャージ BLK/RED
37395 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) OUT OF CONTROL SWEATS
40732 PUNK DRUNKERS メッシュショーツ NAVY/RED
40733 PUNK DRUNKERS メッシュショーツ BLACK
42950 THRASHER TH5152 MAG TRACK JACKET BLACK
42951 THRASHER TH5153 OATH TRACK JACKET BLACK
43911 PUNK DRUNKERS カンフージャージ(上/トップス) YELLOW
43912 PUNK DRUNKERS カンフージャージ(上/トップス) BLACK
44237 FILA FM9514 TRACK JACKET BLACK
44315 MAGICAL MOSH MISFITS MxMxM ジャージ 上 DOKU
44316 MAGICAL MOSH MISFITS MxMxM ジャージ 下 BLACK
44317 MAGICAL MOSH MISFITS MxMxM ジャージ 下 DOKU
44351 Civil Regime 18CV-HL840J ENERGY TECHNO JACKET NEON
44352 Civil Regime 18CV-HL840J ENERGY TECHNO JACKET RED
44916 MISHKA (ミシカ) 2019 福袋 -NEW YEAR BAG-
45034 PUNK DRUNKERS [PDSx野性爆弾くっきー]くっきージャージ(上/トップス) BLACK
45035 PUNK DRUNKERS [PDSx野性爆弾くっきー]くっきージャージ(上/トップス) RED
45036 PUNK DRUNKERS [PDSx野性爆弾くっきー]くっきージャージ(下/パンツ) BLACK
45037 PUNK DRUNKERS [PDSx野性爆弾くっきー]くっきージャージ(下/パンツ) RED
45127 MUSIC SAVED MY LIFE (MSML) M1H5T-PT03 2LINE COLOR JERSEY BLACK
45128 MUSIC SAVED MY LIFE (MSML) M1H5T-PT03 2LINE COLOR JERSEY MUSTARD
45129 MUSIC SAVED MY LIFE (MSML) M1H5T-PT03 2LINE COLOR JERSEY RED
45379 Subciety 2019 福袋 -NEW YEAR BAG-
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
45559 GALFY 色絶妙ナイロンジャケット L.PURPLE
45560 GALFY 色絶妙ナイロンジャケット NAVY
45825 LILWHITE(dot) LW-19SS-J01 "X-RAY" MESH TRACK JKT BLACK
45826 LILWHITE(dot) LW-19SS-J01 "X-RAY" MESH TRACK JKT ORANGE
45839 MISHKA MSS190537 JACKET
45880 PARADOX PX15-TJ01 TRACK JACKET BLACK
45881 PARADOX PX15-TJ01 TRACK JACKET ORANGE
45925 SABBAT13 SBT-JKT-021 TRACK JKT(ブラック)
45926 SABBAT13 SBT-JKT-021 TRACK JKT(イエロー)
45927 SABBAT13 SBT-JKT-021 TRACK JKT(レッド)
45958 KONUS K-61400 Track Pants w/ Knit Tape Black
47440 LILWHITE(dot) LW-19SU-J02 “RETRIBUTION” TRACK JKT BLACK
47647 RIPNDIP Run It Nylon Track Jacket (Watermelon)
47651 RIPNDIP Run It Nylon Track Pants (Watermelon)
48299 REBEL8 AFFILIATION CHAMPION SHORTS BLACK
48300 REBEL8 HIGH STAKES SHORTS GREY
49208 EPTM.(エピトミ) EP8367 COLOR BLOCK BASKETBALL SHORTS BLACK/OFF WHITE/RED
49209 EPTM.(エピトミ) EP8367 COLOR BLOCK BASKETBALL SHORTS BLACK/RED/GREEN
49711 RIP DESIGN WORXX スネークタイダイメッシュハーフパンツ BLACK/RED
49712 RIP DESIGN WORXX スネークタイダイメッシュハーフパンツ WINE/BLUE
49713 RIP DESIGN WORXX スネークタイダイメッシュハーフパンツ KHAKI/GRAY