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-27 06:17:25')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.stock > 0
AND FIND_IN_SET(2, p.color)
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 7
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
68839 SLIPKNOT UNISEX T-SHIRT: AMUSEMENT PARK (BACK PRINT)
66943 KORN UNISEX PULLOVER HOODIE: REQUIEM (BACK PRINT)
61822 METALLICA UNISEX PULLOVER HOODIE: SKULL FLOWER WASHED
67509 RED HOT CHILI PEPPERS UNISEX PULLOVER HOODIE: CLASSIC ASTERISK
56809 MY CHEMICAL ROMANCE UNISEX HOODIE: RACEWAY
70557 SUM41 UNISEX T-SHIRT: REAPER
70934 BLINK-182 UNISEX SWEATSHIRT: BIG SMILE (SLEEVE PRINT)
69350 GUNS N' ROSES UNISEX LONG SLEEVE T-SHIRT: HOLLYWOOD TOUR (BACK & SLEEVE PRINT)
69365 NIRVANA UNISEX PULLOVER HOODIE: XEROX HAPPY FACE PINK GREY
71089 SOMOSOMO × over print × GEKIROCK CLOTHINGコラボ・パーカー GRAY
70383 chuLa × scene tokyo コラボ・パーカー MINT
70384 chuLa × scene tokyo コラボ・パーカー BLUE
70385 chuLa × scene tokyo コラボ・パーカーYELLOW
70386 chuLa × scene tokyo コラボ・パーカー RED
70387 chuLa × scene tokyo コラボ・パーカー ORANGE
70388 chuLa × scene tokyo コラボ・パーカー PINK
70389 chuLa × scene tokyo コラボ・パーカー WHITE
70437 chuLa × scene tokyo コラボ・パーカー PURPLE
68784 美園 礼音 × LONELY論理 コラボ限定Tシャツ
69116 GYROAXIA×GEKIROCK CLOTHINGコラボ限定トレーディング缶バッジ
69117 GYROAXIA×GEKIROCK CLOTHINGコラボ限定トレーディングアクリル・カード
69118 GYROAXIA×GEKIROCK CLOTHINGコラボ限定アクリル・スタンド
35598 BRING ME THE HORIZON Alone & Depressed
69364 NINE INCH NAILS UNISEX PULLOVER HOODIE: CLASSIC LOGO
67871 桔梗凛生× AFFECTER コラボ限定ジップアップパーカー
55761 【バンドリ!×ゲキクロ 第2弾復刻】白金燐子コラボ 限定 ネックストラップ
66496 10-FEET×Zephyren(ゼファレン) BIG PARKA OFF WHITE
66267 【単品販売】へきトラ劇場×GALFY×GEKIROCK CLOTHING 開店!!!! プルオーバーパーカー BLACKタイダイ
66268 【単品販売】へきトラ劇場×GALFY×GEKIROCK CLOTHING 開店!!!! スウェットパンツ BLACKタイダイ
63678 【セット販売】へきトラ劇場×GALFY×GEKIROCK CLOTHING 開店!!!! SET UP REDタイダイ
58433 Survive Said The Prophet MIXED LOGO L/S TEE GRAY
58435 Survive Said The Prophet SIDE TAG BEANIE GRAY
61672 BEASTIE BOYS UNISEX PULLOVER HOODIE: CHECK YOUR HEAD (BACK PRINT) GRAY
60845 エルフリーデ×ゲキクロ×DI:VISIONスペシャル・コラボ・パーカー GRAY
56811 AC/DC UNISEX FASHION TEE: BLACK ICE (BURN OUT)
45947 BRING ME THE HORIZON UMBRELLA (BURN OUT) GRAY
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
11278 DANGERKIDS CAD Charcoal T-Shirt
11301 ENTER SHIKARI Texas Silver
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
21115 ISSUES Too Many Moons Heather Tank Top
21118 WE CAME AS ROMANS Horse & Rider All-Over-Print
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
28546 【限定アイテム】ササノマリイ M(OTHER) Tシャツ
35690 NIRVANA Bleach Cassette Photo T-shirt
36662 GUNS N' ROSES BULLET CLASSIC GRAY