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-21 18:58:15')
AND FIND_IN_SET(2, p.color)
AND pc.classcategory_id1 IN( 11)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 60
44970 GREEN DAY Dookie Ragran T-Shirts[B]
59296 GoneR GR29CTW001 GoneR × PICTURE MOUSE Collavoration T-Shirts Stone Blue
24306 キバオブアキバ ANUBIS Tシャツ Grey/BGN
55675 RIP DESIGN WORXX ディスグースマスクTシャツ GRAY
64860 Wall Of Graphic(ウォールオブグラフィック)Point Tシャツ チャコール
56995 VIRGO Off the dye GRAY
18028 四星球 シンプルロゴTシャツ Charcoal
63698 AFFECTER (アフェクター) AFE COLLEGE LOGO L/S Tee Gray
62121 STAPLE×Hello Kitty Worldwide Tee HEATHER GRAY
59081 Subciety (サブサエティ) Separation L/S - GRAY
53062 RIP DESIGN WORXX RIPDW ツーフェイスSkulown L/S Tシャツ GRAY
60973 PUNK DRUNKERS SHARK.TEE - ASH
59111 MAGICAL MOSH MISFITS RATFINK x MxMxM "MAGICAL MOSH RATFINK" TEE GRAY
60651 Subciety (サブサエティ) CLASSIC PARKA GRAY
64148 SABBAT13(サバトサーティーン) STORY TELLING T (BG)
34155 Xmas Eileen Xmas Eileen カレッジTシャツ GRAY
34344 a crowd of rebellion 10th Anniversary Tour 2017 T-Shirts Charcoal Gray
18038 四星球 テヘペロTシャツ GREY
57415 THRASHER (スラッシャー) TH8528PLGONZ HOODIE GRAY
59146 ROLLING CRADLE LIP RINGER TEE GRAIGE
60952 PUNK DRUNKERS [PDSx太鼓の達人]太鼓マスターTEE - SUMI
62665 PUNK DRUNKERS[PDSxCOCALERO]八福神TEE - H.BLACK
22508 ドラマチックアラスカ 人間ロックTシャツ ゲキクロ限定カラー
62674 PUNK DRUNKERS (パンクドランカーズ) メニメニプリントTEE - D.H.NAVY
56596 MAGICAL MOSH MISFITS MxMxM HOODIE GRAY
57376 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT GRAY
29949 amazarashi new logo T-shirt OATMEAL
41066 OBEY x Misfits Fiend Club Custom Box Pigment LS Tee BLACK
54619 Survive Said The Prophet EMBRONDERY COMFORT TEE GRAY
64189 over print(オーバープリント) back pile shorts (mint)
29951 amazarashi kyomubyo T-shirt typeA
59393 MAGICAL MOSH MISFITS MxMxM パイル PARKA TEE PURPLE
26270 DESCENDENTS Thou Shalt Not Commit Adulthood Shirt
28614 ROLLING STONES 50 YEARS TONGUE
31535 SILVERSTEIN ROBOT TEE Charcoal
31542 ALL SPACESUITS TEE
21116 ISSUES Many Moons Ago Heather Athletic Gray T-Shir
36855 NIRVANA Floral Logo-Dark Heather t-shirt
61152 AFFECTER (アフェクター) TAG HOODIE GRAY
34514 GREEN DAY Dookie Vintage T-Shirt
64360 DI:VISION (ディヴィジョン) FICTION LS TEE CHACOAL
35507 SLIPKNOT Logo T-Shirt
36676 LINKIN PARK PERSPECTIVE
50178 LINKIN PARK Patches Tee Gray
23836 T/ssue LOGO HOODIE GRAY
45655 BRING ME THE HORIZON WOUND WITH BURN OUT FINISHING charcoal
17727 METALLICA Puppet Strings All Over T-Shirt
50312 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) charcoal
56068 NineMicrophones PARKA-Power of will-GRAY
59038 Subciety (サブサエティ) Separation PARKA - GRAY
60422 GALFY (ガルフィー) わんわん大学ロンTee T.GRAY
35690 NIRVANA Bleach Cassette Photo T-shirt
35700 RED HOT CHILI PEPPERS Asterwrist Grey t-shirt
58433 Survive Said The Prophet MIXED LOGO L/S TEE GRAY
65165 Subciety (サブサエティ) NOVEL GLORIOUS TEE-GRAY/BLACK
61081 VIRGO LOOSE FIT SWEAT GRAY
23926 a flood of circle SEAGULL SWEAT GRY
23821 ENTH LOGO HOODIE GRAY
39908 SANTA CRUZ Classic Dot S/S T-Shirt Silver
45947 BRING ME THE HORIZON UMBRELLA (BURN OUT) GRAY