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-01 16:24:39')
AND pc.price02 > 2727
AND price02 <= 4545
AND FIND_IN_SET(2, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
45947 BRING ME THE HORIZON UMBRELLA (BURN OUT) GRAY
68839 SLIPKNOT UNISEX T-SHIRT: AMUSEMENT PARK (BACK PRINT)
70557 SUM41 UNISEX T-SHIRT: REAPER
71056 over print (オーバープリント) DENIM CAP chacoal
71007 PUNK DRUNKERS クレイジーマウスTEE - SUMI
50312 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) charcoal
35598 BRING ME THE HORIZON Alone & Depressed
69992 SABBAT13(サバトサーティーン) SPOOK KNIT CAP GRAY
69133 gibous(ギボス) damage gibous life cap
69073 NieR (ニーア) CAMOUFLAGE UNISEX SARROUEL PANTS
68246 TOY MACHINE (トイマシーン) W MOUSEKATER CANVAS TOTE-BAG GRAY
64188 over print(オーバープリント) back pile shorts (ash gray)
64189 over print(オーバープリント) back pile shorts (mint)
66871 over print(オーバープリント)×RIPDW Arm cover(black)
67518 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ CREW SWEAT ]SUMI
60664 MISHKAM M61000413 CREW
64861 Wall Of Graphic(ウォールオブグラフィック)W.O.G ワイドデニム
64116 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ CREW SWEAT ] SAX
62710 PUNK DRUNKERS べちゃロゴTEE / O.Fシリーズ - SUMI
62702 PUNK DRUNKERS (パンクドランカーズ) とびすぎちゅういTEE - ASH
62720 PUNK DRUNKERS (パンクドランカーズ) 健康ランドスウェットショーツ - M.GRAY
65154 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY SWEAT GRAY
64360 DI:VISION (ディヴィジョン) FICTION LS TEE CHACOAL
65165 Subciety (サブサエティ) NOVEL GLORIOUS TEE-GRAY/BLACK
64880 over print(オーバープリント) Folding umbrella (Grayish white)
64177 over print (オーバープリント) white stich CAP (smoky mint)
64077 AFFECTER (アフェクター) COLLEGE LOGO CAP GRAY
63361 over print (オーバープリント) plane 3/4S Tee (chacoal / ivory)
63356 over print (オーバープリント) PASS name LS Tee (light gray)
63358 over print (オーバープリント) PASS name LS Tee (chacoal)
63157 over print (オーバープリント) plane LS Tee (heather gray)
60632 TRAVAS TOKYO【トラバストーキョー】Furry bear Hoodie Gray
62134 ROLLING CRADLE CIRCLE LOGO BAG GRAY
63242 DXMOUVE(ドゥモーヴェ) 臓器の観客柄 切替半袖プルオーバー グレー
58433 Survive Said The Prophet MIXED LOGO L/S TEE GRAY
58435 Survive Said The Prophet SIDE TAG BEANIE GRAY
60422 GALFY (ガルフィー) わんわん大学ロンTee T.GRAY
61839 Subciety (サブサエティ) EMBROIDERY PARKA GRAY
61081 VIRGO LOOSE FIT SWEAT GRAY
61152 AFFECTER (アフェクター) TAG HOODIE GRAY
59202 VIRGO DEFOLIATION GLOVES GRY×KHA
60806 TOY MACHINE (トイマシーン) AMERICAN MONSTER SWEAT PARKA - M. GREY
60374 GoneR GR30PK001 Chalice Parka Hether Grey
58975 Subciety (サブサエティ) WESTERN SHIRT - BLACK/GRAY
60224 NieR (ニーア) 狼NieRちゃんハーフパンツ
50514 Zephyren(ゼファレン) PARKA -PROVE- GRAY
60137 SPRAY GROUND SG ALL DAY BACKPACK (DLXV)
59038 Subciety (サブサエティ) Separation PARKA - GRAY
59393 MAGICAL MOSH MISFITS MxMxM パイル PARKA TEE PURPLE
52902 MY CHEMICAL ROMANCE UNISEX TEE: RACEWAY
57856 Subciety (サブサエティ) SHOULDER BAG- GRAY
56811 AC/DC UNISEX FASHION TEE: BLACK ICE (BURN OUT)
56598 MAGICAL MOSH MISFITS MxMxM どろどろドクロ HOODIE GRAY
56533 SILLENT FROM ME VEIN -Cable Knit Beanie- MIXED
56282 MUSIC SAVED MY LIFE (MSML) CUT OFF BIG SWEAT CHACOAL GRAY
55671 DI:VISION REFLECTION WAIST BAG GRAY
56068 NineMicrophones PARKA-Power of will-GRAY
54998 Zephyren(ゼファレン)LONG SHIRT L/S PAINT
54876 PUNK DRUNKERS INDOORニットCAP - CHARCOAL
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
47515 Subciety WORK SHIRT S/S-Basjoe- GRAY
40411 GoneR GR17LD003 『G』 Sweat Shorts Grey
24868 GoneR Logo T-Shirts Ver.3 Grey
24882 GoneR (ゴナー) GoneR Dot T-One Piece Heather Grey
3599 FOO FIGHTERS GUITAR T-Shirt
3600 FOO FIGHTERS REEL TO REEL T-Shirt
4660 SUGARFIX CLOTHING Creature Stole My Twinkie Lace T
6874 GLAMOUR KILLS GIRLS SLAY ON DRAPE TANK
7448 ISSUES I Have - Heather Grey
9336 MISHKA (ミシカ) NEW ERA: KEEP WATCH ORANGE
9673 FAMOUS STARS AND STRAPS At The Movles silver
10005 FAMOUS STARS AND STRAPS American Fame Beanie GRY
10241 LINKIN PARK GLITCH PORTRAIT T-Shirt
11278 DANGERKIDS CAD Charcoal T-Shirt
11301 ENTER SHIKARI Texas Silver
11333 ANGRY FROG REBIRTH logo Raglan T-Shirt GRAY
11424 OF MICE & MEN Restoring Force Album Heather GRY
12062 NIRVANA GALAXY IN UTERO T-Shirt
12368 ROLLING CRADLE MISSILE Pillkn Gray
15326 CHUNK!NO,CAPTAIN CHUNK! Navajo Grey/Black Baseball
15333 YELLOWCARD You're The Light Silver
15401 MEMPHIS MAY FIRE Logo Heather Gray
15434 ISSUES Monster Heather Grey
15456 MOTIONLESS IN WHITE Icon Black On Charcoal Heather
15473 CROWN THE EMPIRE Oh Catastrophe Heather Tank Top
15495 PROTEST THE HERO Dino Ice Grey
15515 WE CAME AS ROMANS Ancestor Heather Grey Tank Top
15517 WE CAME AS ROMANS Scratchy Text Dark Heather
15571 OF MICE & MEN Faithfulness Heather Grey
15876 BURNING THE REGISTER CHAOS BEANIE CHC
15898 Subciety CHECK SHIRTS L/S-Conductor- GRAY
16564 REBEL8 WOMENS GREY LOGO BOYFRIEND TEE
16849 ZEPHYREN (ゼファレン) PARKA -RAMPAGE- GRAY
16946 ZEPHYREN (ゼファレン) S/S HOODY -SKULL HEAD- GRAY
17727 METALLICA Puppet Strings All Over T-Shirt
17728 METALLICA PUSHHEAD BORIS MENS TEE
18027 ALL SKATEROY T-shirts
18040 四星球 MMM4パーカー
18071 DEADHEARTZ 3/4SLEEVE GRY/BLK
18972 MEMPHIS MAY FIRE Blue Fun Crest Heather
18973 MEMPHIS MAY FIRE BLUE LOGO HEATHER GREY
19127 MOTIONLESS IN WHITE Logo Black On Dark Heather
19133 SLEEPING WITH SIRENS Feather Charcoal Grey T-Shirt
19134 SLEEPING WITH SIRENS Tough As Nails Silver T-Shirt
19326 ZEPHYREN (ゼファレン) BASEBALL TEE - WHT/BEYOND
19453 ZEPHYREN (ゼファレン) R-7/S TEE -BEYOND - GRAY/BLACK
19469 Zephyren L/S TEE -BEYOND - GRAY
19475 ZEPHYREN (ゼファレン) L/S TEE -SKULL HEAD - GRAY
19479 ZEPHYREN (ゼファレン) R-L/S TEE -BEYOND - GRAY/BLACK
19808 CAPTURE THE CROWN Grim Concrete/Cherry
19870 CROWN THE EMPIRE Oh, Catastrophe Heather Grey Tee
20168 FUZZ REZ ZWEEP 1st LOGO TEE
20339 AGAPE ATTIRE CLASSIC SCRIPT TANK
20467 RIP DESIGN WORXX スタンダードロゴTシャツ GRY
20602 FAMOUS STARS AND STRAPS 3 TIMES MENS TEE GRAY
21115 ISSUES Too Many Moons Heather Tank Top
21116 ISSUES Many Moons Ago Heather Athletic Gray T-Shir
21186 PUNK DRUNKERS 虎トレーナー GRAY
21253 RIP DESIGN WORXX Number69グレー
21392 FAMOUS STARS AND STRAPS ETERNITY Girl's Muscle Tee