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 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-04-25 21:01:55')
AND pc.stock > 0
AND FIND_IN_SET(2, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 240, 120
65435 RIPNDIP (リップンディップ) OG Prisma Short Sleeve Tee (Slate Grey)
65157 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY HALFZIP SWEAT GRAY
65347 SUPPLIER (サプライヤー) BONE EMBROIDERY WASHED DENIM GRAY
65320 over print (オーバープリント) space monkey LS Tee×Monchhichi gray
64286 RIPNDIP (リップンディップ) Nerm Doodle Twill Shorts (Chocolate)
64288 RIPNDIP (リップンディップ) Nerm Doodle Cotton Twill Pants (Chocolate)
64262 RIPNDIP (リップンディップ) Nerm Cruiser Tee (Black Mineral Wash)
64264 RIPNDIP (リップンディップ) Abduction Tee (Black Mineral Wash)
64865 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE GRAY
64315 Subciety (サブサエティ) SUPPORTER TEE GRAY
64063 Subciety (サブサエティ) SWEAT SHORTS GRAY
64077 AFFECTER (アフェクター) COLLEGE LOGO CAP GRAY
60682 DI:VISION ENVIOUS HOODIE GRAY
62198 Zephyren(ゼファレン) CHECK SHIRT S/S - Resolve - GRAYⅠ
62180 ROLLING CRADLE GLEN CHECK SHIRT-1st type- / GRAY
62910 PSYCHOLOGICAL METAMORPHOSIS CG SWEAT PANTS - GRAY
61944 glamb (グラム) Paisley Pajamas SH - Black
61945 glamb (グラム) Paisley Pajamas SH - White
61119 VIRGO VGW BUDDY SWT PANTS GRAY
62639 LONELY論理 NEW LOGO TOTE BAG GRAY
62606 HYPER CORE SICKS MUTE BEARスウェット
58433 Survive Said The Prophet MIXED LOGO L/S TEE GRAY
58435 Survive Said The Prophet SIDE TAG BEANIE GRAY
61707 SUPPLIER (サプライヤー) LOONEY CREW SWEAT LIGHT GRAY
61709 SUPPLIER (サプライヤー) LAYER LOGO SWEAT PANTS LIGHT GRAY
61672 BEASTIE BOYS UNISEX PULLOVER HOODIE: CHECK YOUR HEAD (BACK PRINT) GRAY
61071 VIRGO COSMIC FLOWER 2FACE JKT L.GRY/AQUA
61567 SUPPLIER (サプライヤー) 1st ANV. LEATHER VARSITY JACKET
59198 VIRGO CROSS V WOOL CAP GRAY
60845 エルフリーデ×ゲキクロ×DI:VISIONスペシャル・コラボ・パーカー GRAY
61274 LONELY論理 3EMBROIDERY CREWNECK GRAY
61276 LONELY論理 3EMBROIDERY HOODIE GRAY
60842 GoneR Ska Sweat Parka Mix Grey
61050 Artemis Classic グレーパイソンロングウォレット[ACW0024]
61049 Artemis Classic グレーパイソンミディアムウォレット[ACW0023]
58978 Subciety (サブサエティ) STRIPE OVER SHIRT - GRAY
60507 ANIMALIA AN21A-SW04 CROSS-NECK HEAVY OZ HOODIE GRAY
60223 NieR (ニーア) 襟付きGRAY RIB CUTSEW【ネクタイセット】
59871 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 GRAY
58451 Subciety ×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA GRAY
58596 SLEEPING TABLET REVERIE [ PATTERNED PAJAMA PANTS ] GRAY
58604 SLEEPING TABLET NOBLE [ SILKY PAJAMA PANTS ] GRAY
58594 SLEEPING TABLET REVERIE [ PATTERNED PAJAMA SHIRTS ] GRAY
58343 SILLENT FROM ME OBSCURE -Mesh Knit Sweater- MIXED
57005 VIRGO Relaxed uniform shirts CHARCOAL
58163 NOT COMMON SENSE HARD CORE TEE BLACK
58164 NOT COMMON SENSE DEAD TUDE TEE BLACK
58095 WASTED PARIS T-shirt Marble Dye Nebula Green
58096 WASTED PARIS T-shirt Marble Dye Nebula Gray
58099 WASTED PARIS Hoodie Columbia Bridge Lilac
57418 THRASHER (スラッシャー) TH8401PL MAG LOGO SWEAT GRAY
50552 FOG ESSENTIALS Pullover Hoodie LIGHT HEATHER
56850 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT GRAY
56858 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” GRAY CHECK
56811 AC/DC UNISEX FASHION TEE: BLACK ICE (BURN OUT)
55876 GoneR GR26ZP001 Rose Photo Zip Parka Heather gray
36568 RUDIE'S (ルーディーズ) CAN BADGE SOLID PHAT GRAY
56027 RUDIE'S (ルーディーズ) PHAT HIGHNECK HOOD SWEAT GRAY
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
20758 Subciety POCKET TEE S/S-GLORIOUS- GRAY
17668 Subciety TIE DYE TEE-GLORIOUS- GREY
11229 Nine Microphones HEAVEN S/S Gray
11278 DANGERKIDS CAD Charcoal T-Shirt
11301 ENTER SHIKARI Texas Silver
13399 ICECREAM FAST DOG TEE SU14 GRAY
13803 Subciety TIE DYE ZIP PARKA-EMOTION- GRAY
15515 WE CAME AS ROMANS Ancestor Heather Grey Tank Top
15517 WE CAME AS ROMANS Scratchy Text Dark Heather
18972 MEMPHIS MAY FIRE Blue Fun Crest Heather
18973 MEMPHIS MAY FIRE BLUE LOGO HEATHER GREY
18984 WE CAME AS ROMANS Varsity Custom Heather Grey Crew
19134 SLEEPING WITH SIRENS Tough As Nails Silver T-Shirt
20065 ICECREAM VARSITY GREY
20067 ICECREAM ICEFA HEATHER GREY
20339 AGAPE ATTIRE CLASSIC SCRIPT TANK
20654 Subciety EMBLEM VEST STRIPE
20722 Subciety (サブサエティ) PARKA-COLLEGE- GRAY/BURGUNDY
20751 Subciety BASEBALL TEE 7/S-COLLEGE- GRAY
21115 ISSUES Too Many Moons Heather Tank Top
21118 WE CAME AS ROMANS Horse & Rider All-Over-Print
22099 FUZZ REZ ZWEEP MODULATION TEE GRY
22508 ドラマチックアラスカ 人間ロックTシャツ ゲキクロ限定カラー
24700 MEMPHIS MAY FIRE Logo Two Tone - TankTop
24756 WHITECHAPEL Sawblade Maroon on Charcoal - T-Shirt
24768 NORTHLANE All-Over Print Black - T-Shirt
25135 SEAWAY Colour Blind Logo Grey - Pullover
25148 WE CAME AS ROMANS Slytherin' Carcoal - T-Shirt
25161 WE CAME AS ROMANS Cracked Hope Heather Grey - Crewneck
25313 EMAROSA Side Fox Tr-Blend Heather Grey - TankTop
26173 PARKWAY DRIVE PWD Black-Gray Beanie
26290 DROPKICK MURPHYS Jolly Roger Patch
26442 【ゲキクロ限定】amazarashi sekaibuki T-shirt L.V edition typeB
28546 【限定アイテム】ササノマリイ M(OTHER) Tシャツ
28823 RIP DESIGN WORXX RIPDW LOGO LONG T-SHIRT(グレー)
29589 ICECREAM ICJP16T034 T-SHIRT GRAY
31797 フクザワ 車缶バッジ
35690 NIRVANA Bleach Cassette Photo T-shirt
36284 HOLDTUBE HT-0172 REGULAR GO CAMP
36618 RIP DESIGN WORXX エレメントTシャツ GRAY
36662 GUNS N' ROSES BULLET CLASSIC GRAY
36963 フクザワ 【秘密】ノート
36982 フクザワ 【監視】 ペンケース
39908 SANTA CRUZ Classic Dot S/S T-Shirt Silver
41452 Subciety (サブサエティ) WOOL SLACKS GRAY
51173 brokker “METALLICA” フィギュア
54619 Survive Said The Prophet EMBRONDERY COMFORT TEE GRAY
27818 Crossfaith 2016 SUMMER SILVER 5 PANEL