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 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 >= '2024-05-19 17:51:47')
AND FIND_IN_SET(14, p.color)
AND pc.classcategory_id1 IN( 12,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
7437 CHUNK!NO,CAPTAIN CHUNK! Bear Blue T-Shirt
11287 Nine Microphones BE ON STAGE S/S DENIM
17603 ICECREAM BALLERS T-SHIRT ROYAL
18030 四星球 シンプルロゴTシャツ Blue
18039 四星球 テヘペロTシャツ Blue
18062 【ゲキクロ限定カラー】 四星球 ドット絵Tシャツ BLUE
18969 MEMPHIS MAY FIRE Anchor Aqua
19835 THE SUMMER SET Floral Triangle Teal
21130 BEFORE MY LIFE FAILS BMLFCULT Color Tee NVY/PUR
23769 9mm Parabellum Bullet 9tee BLUE
23929 a flood of circle AFOC LOGO TEE BLUE
24257 UNDEAD CORPORATION 朱美デザインTシャツ Tie Dye
24304 キバオブアキバ POPKILLER コラボTシャツ
24652 PROTEST THE HERO Keys White/Navy - Baseball Tee
24740 MEMPHIS MAY FIRE Shield Royal Blue - T-Shirt
25304 CROWN THE EMPIRE The Fallout Tie Dye - T-Shirt
25409 FINCH Flame Blue/White - Baseball Shirt
25486 PIERCE THE VEIL Album Black - T-ShirtStitches Heather Blue - Tank Top
26271 DESCENDENTS Van
26399 【限定アイテム】モーモールルギャバン ロゴTシャツ(すしおデザイン)
29567 Aldious LIVE 2016 Tシャツ ブラック x ブルー
31525 NIRVANA KURT COBAIN BUS PHOTO TEE
34345 a crowd of rebellion 10th Anniversary Tour 2017 T-Shirts Light Blue
35601 BRING ME THE HORIZON WOUND WITH BURN OUT FINISHING
36541 RED HOT CHILI PEPPERS -Kaleidoscope-Light Blue
36773 BRING ME THE HORIZON Steel City on blue t-shirt
37235 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ スカイ
37823 Xmas Eileen DIS IS LOVEコーチジャケット(青)
41075 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 WHITE / BLUE
42641 KEYTALK ロングスリーブ Tシャツver.2 ブルー
48418 BRING ME THE HORIZON UMBRELLA WITH BURN OUT FINISHING
48488 RUDIE'S SPARK DRY-T BLUE
50240 MISHKA MAW190545 JACKET
50249 ROLLING CRADLE 2TONE HOODED SHIRT / Blue-Green
50367 MODERN DAY BABYLON Ocean Atlas T-shirt
50369 MODERN DAY BABYLON Travelers T-shirt
52864 BILLIE EILISH UNISEX LONG SLEEVED TEE: SMILE (BACK & ARM PRINT) BLUE
52865 BILLIE EILISH UNISEX LONG SLEEVED TEE: MANINMAN BLUE
53142 HEDWiNG HD1-018 “Pierre” Tie-dye T-shirt Navy
53915 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA BLUE
54055 FILA FM9787 L/S TEE BLUE
54086 SUICIDAL TENDENCIES x MxMxM “MAGICAL TENDENCIES” WORK SHIRT BLUE
54097 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO L/S TEE SAX
54128 ROLLING CRADLE TIEFYE TEE BLUE
54213 SLEEPING TABLET M [ FRAYED HEM LOOSE SHIRTS ] BLUE
54291 PUNK DRUNKERS タイダイーズTEE - GREEN
54292 PUNK DRUNKERS タイダイーズTEE - PURPLE
54412 ROLLING CRADLE THUNDER GATE SAROUEL DENIM / INDIGO
54416 ROLLING CRADLE DRAW LOGO SUPER BIG TEE / BLUE
54430 THRASHER GONZ HOODIE
54593 PARADOX PX17-SH01 REFLECTOR SHIRTS ECHO
54649 mnml(ミニマル) STRIOED BOXY TEE BLUE/YELLOW
54675 FILA FFM9802 ユニセックス クルーネックシャツ NAVY
54699 MISHKA(ミシカ) MSS200030 T-SHIRTS ORANGE/PURPLE
54714 PUNK DRUNKERS [PDSxKUDAN]PUNKUDAN式 総柄ベアショーツ BLUE
54712 PUNK DRUNKERS [PDSxKUDAN]PUNKUDAN式 総柄ベアシャツ BLUE
54684 MAGICAL MOSH MISFITS MxMxM ZOMBIES TEE BLUE
54682 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL SCREAMING HAND” TEE DOKU
54681 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL SCREAMING HAND” TEE BLACK
54680 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL SCREAMING HAND” TEE WHITE
54678 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL SCREAMING HAND” PANTS GRAY
23014 Subciety EMBLEM WORK SHIRT S/S-CHAMBRAY- BLUE
53234 Zephyren(ゼファレン)SWITCHING SHIRT S/S MIX
55549 PUNK DRUNKERS 切替イージーパンツ BLUE/CHARCOAL
54717 PUNK DRUNKERS 2FACE開衿シャツ BLUE
55628 Anti Social Social Club SAMSIES BLUE HOODIE
55710 RIPNDIP Catch Em All Tee (Blue Spiral Dye)
54762 PSYCHOLOGICAL METAMORPHOSIS PMLP CHINO EAZY PANTS SAX
54766 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS SAX
53156 HEDWiNG HD4-003 Jellyfish Climbing Shorts Blue
54224 Subciety COACH JKT-MIDDLE LOGO- BLUE
56028 RUDIE'S PHAT HIGHNECK HOOD SWEAT BLUE
56033 PARADOX PRINTED CHECK SHIRTS (BLUE)
54998 Zephyren(ゼファレン)LONG SHIRT L/S PAINT
55013 Zephyren(ゼファレン)BIG SHIRT L/S - As above,So below - GREEN
56126 N.B.O. WASH UFO T
56151 MAGICAL MOSH MISFITS MxMxM FLAME LONG TEE BLUE
55918 MISHKA MAW200214 SHIRTS
55926 MISHKA MAW200904 PANTS
56204 Anti Social Social Club Headrush All Over White Hoodie
56213 Anti Social Social Club Headrush All Over White Tee
54772 PUNK DRUNKERS [PDSxPAC-MAN]名人コーデュロイJKT - BLUE
56287 MUSIC SAVED MY LIFE (MSML) TIE DYE SWEAT PARKA
56183 GALFY 燃える薔薇デニム BLUE
54235 Subciety BANDANA QUILTING JKT BLACK/NAVY
56744 TOY MACHINE BOA FLEECE REVERSIBLE JACKET - WHITE/BLACK
56799 ROLLING CRADLE CHECK HOOD JACKET BLUE
56538 ROLLING CRADLE FLIGHT JACKET / DENIM
54830 PUNK DRUNKERS UMAパーカ - BLACK/BLUE
55917 MISHKA MAW200210 SHIRTS
55976 MISHKA(ミシカ) MAW200511 JACKET
56888 MISHKA(ミシカ) MAW200901 PANTS
56885 MISHKA(ミシカ) MAW200508 JACKET
54822 PUNK DRUNKERS 手インターデニム - INDIGO
55970 ANIMALIA AN20A-SH02 “R.I.B. SHIRTS” BLUE
57070 SALUTE CACTUS STARS JEANS
57068 SALUTE DENIM HANDCUFFS JEANS
57067 SALUTE DENIM HANDCUFFS JACKET
57072 SLIGHTLY NUMB SAPPY ALOHA SHIRT
57198 MAGICAL MOSH MISFITS ぷよぷよ x まじかる “ぷよぷよもっしゅみすふぃっつ” LONG TEE BLUE
56835 Subcietyx攻殻機動隊 TACHIKOMA L/S TEE SHIRT BLUE
56484 SALUTE Flower Anarchy Hoodie BLUE
57338 MISHKA M21000508 JACKET
56642 PUNK DRUNKERS 鮫人刺繍トレーナー - BLUE
57352 SUPPLIER (サプライヤー) MARBLE CREW SWEAT LIGHT BLUE
57353 SUPPLIER (サプライヤー) MARBLE CREW SWEAT NAVY
57355 SUPPLIER (サプライヤー) TINPLATE ZIP HOODIE BLUE
56622 PUNK DRUNKERS しみシャツ - LT.BLUE
57128 SABBAT13 SPOOK INSIDE L/S T BLUE
56578 GALFY パリピGジャン 青空
56581 GALFY パリピGカーゴ 青空
58002 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT BLUE
58013 ROLLING CRADLE THUNDER GATE SKINNY DENIM / INDIGO
58014 ROLLING CRADLE THUNDER GATE SKINNY DENIM / CHEMICAL
58044 ROLLING CRADLE RIP-STOP JACKET BLUE
58045 ROLLING CRADLE RIP-STOP PANTS BLUE
57308 HEDWiNG Disappear Logo Shef Pants
58158 TOY MACHINE MONSTER T-Shirt BLUE
58305 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] GRAY
58329 ANIMALIA AN21S-SW03 INDIGO Z/U HOODIE -CHIMAYO INDIGO