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-18 18:39:58')
AND pc.classcategory_id1 IN( 11)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 733)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
51199 SLIPKNOT UNISEX TEE: WANYK LOGO (BACK PRINT)
35289 SLIPKNOT UNISEX T-SHIRT: BAND FRAME
35502 SLIPKNOT Blocks T-Shirt
52593 SLIPKNOT UNISEX LONG SLEEVED TEE: SHROUDED GROUP (BACK & ARM PRINT)
36789 SLIPKNOT Gray Chapter Skeleton Hooded Sweatshirt
57297 SLIPKNOT UNISEX PULLOVER HOODIE: CHOIR (BACK PRINT)
51195 SLIPKNOT UNISEX PULLOVER HOODIE: SPLATTER (BACK PRINT)
52907 KORN UNISEX TEE: DEATH DREAM
66943 KORN UNISEX PULLOVER HOODIE: REQUIEM (BACK PRINT)
35645 MARILYN MANSON THE PALE EMPEROR T-SHIRTS
35642 MARILYN MANSON RED LIPS T-SHIRTS
70709 Survive Said The Prophet SPARKLE COACH JACKET
70708 Survive Said The Prophet MAKE / BREAK TOUR HOODIE
70718 Survive Said The Prophet SHAPES L/S TEE
70716 Survive Said The Prophet OMEN TEE
70714 Survive Said The Prophet MAKE / BREAK TEE (BLACK)
70715 Survive Said The Prophet MAKE / BREAK TEE (WHITE)
70717 Survive Said The Prophet MUSEUM TEE
70711 Survive Said The Prophet SurvivE L/S TEE(Glow-in-the-dark)
51202 SLIPKNOT UNISEX TEE: WANYK BACK HIT (BACK PRINT)
35292 SLIPKNOT PAUL GRAY
62570 Survive Said The Prophet REDEFINE TOUR HOODIE BLACK
62571 Survive Said The Prophet REDEFINE TOUR HOODIE WHITE
62572 Survive Said The Prophet TRADITIONAL TEE
62573 Survive Said The Prophet "INFINI" TEE NATURAL
35635 KORN SKULLDELIS T-SHIRTS
35295 SLIPKNOT WAVES
49512 SLIPKNOT .5 THE GRAY CHAPTER
35637 KORN STAGE T-SHIRTS
45953 Crossfaith ORNAMENT TEE BLACK
51194 SLIPKNOT UNISEX PULLOVER HOODIE: GRAPHIC GOAT (BACK PRINT)
52575 MARILYN MANSON UNISEX ZIPPED HOODIE: CROSS LOGO (EX TOUR/BACK PRINT)
52908 KORN UNISEX TEE: SCRATCHED TYPE (BACK PRINT)
5577 MARILYN MANSON SKULL CROSS T-Shirt
5579 SLIPKNOT MASK HELL T-Shirt
12044 KORN RILLA T T-Shirt
13791 SLIPKNOT STAR CREST T-Shirt
14103 SLIPKNOT THORNS ALL OVER T-Shirt
14117 KORN MOSAIC TEE
17748 a crowd of rebellion The Crow Black TEE
17749 a crowd of rebellion The Crow Off White
17750 a crowd of rebellion Band Logo Black
17751 a crowd of rebellion Band Logo Off White
17752 a crowd of rebellion The Crow Hoodie
19156 a crowd of rebellion Blood Sphere Ver2 WHITE
19157 a crowd of rebellion Blood Sphere Ver2 BLACK
19158 a crowd of rebellion 【お犬様】
25561 a crowd of rebellion Tシャツ 宇宙人
25562 a crowd of rebellion Tシャツ あーす
25563 a crowd of rebellion Tシャツ ごま達 反逆
26174 SUICIDE SILENCE Stronger Than Faith
26177 SUICIDE SILENCE WATERGRAVE TEE
26437 【限定アイテム】a crowd of rebellion 激クロ&VV限定Tシャツ BLUExPINK
26438 【限定アイテム】a crowd of rebellion ゲキクロ&VV 限定Tシャツ WHITExRED
26439 【限定アイテム】a crowd of rebellion 激クロ&VV限定Tシャツ GREENxWHITE
27811 Crossfaith GLITCH ON BLACK LONGSLEEVE SHIRT
27816 Crossfaith Longsleeve Shirt(2016Spring)
27819 Crossfaith 限定デザイン Tシャツ
28580 SLIPKNOT GRAPHIC GOAT T-Shirts
28714 SUICIDE SILENCE MANGLED GEARS
28716 SUICIDE SILENCE YOU CAN'T STOP ME
28717 SUICIDE SILENCE SKULL KINGDOM
28718 SUICIDE SILENCE PURPLE TIME STEALER
32271 【ゲキクロ限定】 a crowd of rebellion Xanthium Tour 2017 冬期講習 Tシャツ
34344 a crowd of rebellion 10th Anniversary Tour 2017 T-Shirts Charcoal Gray
34345 a crowd of rebellion 10th Anniversary Tour 2017 T-Shirts Light Blue
35284 SLIPKNOT Slipknot Men's Hooded Top: Skull Teeth
35287 SLIPKNOT Fashion Tee Logo Star
35290 SLIPKNOT CREATURES
35291 SLIPKNOT Masks 2
35293 SLIPKNOT RUSTY FACE
35294 SLIPKNOT SHATTERED
35501 SLIPKNOT New Masks T-Shirt
35503 SLIPKNOT Dead Effect T-Shirt
35504 SLIPKNOT Skeptic T-Shirt
35505 SLIPKNOT Fuck Me UpT-Shirt
35506 SLIPKNOT Skull Group T-Shirt
35507 SLIPKNOT Logo T-Shirt
35508 SLIPKNOT The Wheel T-Shirt
35509 SLIPKNOT Goat Star Logo T-Shirt
35510 SLIPKNOT Giant Star T-Shirt
35511 SLIPKNOT Prepare for Hell 2014-2015 Tour
36499 【ゲキクロ限定】 a crowd of rebellion Gingerol T-Shirt Orange
36502 【ゲキクロ限定】 a crowd of rebellion Gingerol Longsleeve White
36503 【ゲキクロ限定】 a crowd of rebellion Gingerol Longsleeve Black
36540 MARILYN MANSON -Striped Face Jumbo Print-2012 Tour Backprint-
36544 SLIPKNOT Distressed Group Room Longsleeve
36678 MARILYN MANSON VILLAIN 2012
36697 SLIPKNOT THE GRAY CHAPTER
36811 SLIPKNOT Embroidered and Applique-Authentic Basketball Jersey
36861 SLIPKNOT Smashed-2015 World Tour-Black t-shirt
36994 SLIPKNOT -Broken Glass-Black t-shirt
36995 SLIPKNOT Knotfest-Brain Ripper-Black t-shirt
36998 SLIPKNOT PENTAGRAM TEE
37234 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ ライトピンク
37235 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ スカイ
37237 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ ホワイト
39171 KORN Baby Hoody
39173 KORN Asthma Tee
40981 a crowd of rebellion T-Shirts
49830 SLIPKNOT US Flag 2015-North American Tour-Black t-shirt
49850 MARILYN MANSON HOLLYWOOD
49851 MARILYN MANSON KILL FOR ME
51200 SLIPKNOT UNISEX TEE: WANYK RED PATCH (BACK PRINT)
51201 SLIPKNOT UNISEX TEE: WANYK ORANGE (BACK PRINT)
52592 SLIPKNOT UNISEX PULLOVER HOODIE: LOGO & STAR (APPLIQUE MOTIFS)
52996 SLIPKNOT UNISEX LONG SLEEVED TEE: SUBLIMINAL VERSES (BACK & ARM PRINT)
52997 SLIPKNOT UNISEX TEE: TORN APART (BACK PRINT)
49720 Survive Said The Prophet NEW SCHOOL TEE (BLACK)
52941 Survive Said The Prophet VERTICAL LOGO TEE
54613 Survive Said The Prophet INSIDE YOUR HEAD TEE WHITE
54614 Survive Said The Prophet INSIDE YOUR HEAD TEE BLACK
54615 Survive Said The Prophet TAPED LOGO TEE WHITE
54616 Survive Said The Prophet TAPED LOGO TEE BLACK
54618 Survive Said The Prophet EMBRONDERY COMFORT TEE GREEN
54619 Survive Said The Prophet EMBRONDERY COMFORT TEE GRAY
52995 SLIPKNOT UNISEX PULLOVER HOODIE: LOGO (BACK PRINT)
52942 Survive Said The Prophet MIA TOUR TEE
52946 Survive Said The Prophet CONCRETE COACH JKT WHITE
52948 Survive Said The Prophet UNBALANCE TEE LIGHT BLUE