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-04-30 17:16:07')
AND pc.price02 > 909
AND price02 <= 2727
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 `category_type` IS NULL
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
69783 SLAYERxDC SHOES(ディーシーシューズ) LANYARD
36532 BRING ME THE HORIZON -Sempiternal- Black T-Shirt
35581 BRING ME THE HORIZON SHADOW MOSES
68080 ANIMALIA (アニマリア) SOX - Panther -
49833 SLIPKNOT Barcode-CD Wallet
35640 PANTERA Logo Key Chain
45657 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: AMO SYMBOLS
60184 BLINK-182 UNISEX T-SHIRT: SIX ARROW SMILEY PURPLE
50311 BRING ME THE HORIZON CROOKED YOUNG (APPLIQUE MOTIFS)
56813 AC/DC UNISEX BASEBALL CAP: RED LOGO
56816 SLIPKNOT FACE MASK: S LOGO
56817 BLACK SABBATH FACE MASK: WAVY LOGO
56818 PANTERA FACE MASK: LOGO
56819 THE ROLLING STONES FACE MASK: CLASSIC TONGUE
56822 BILLIE EILISH UNISEX TEE: SWEET DREAMS
55806 SUBLIME×SULLEN LIVIN DIZZY STANDARD Tee
36849 METALLICA Flame Skulls-Black Lightweight T-shirt
2506 BREATHE CAROLINA Logo Black Rubber
2508 BREATHE CAROLINA Hell Is What You Make It Black
3551 BREATHE CAROLINA - Breathe Red
3847 LIKE MOTHS TO FLAMES I Don't Give A Fuck Black
3858 WE CAME AS ROMANS I'm Alive Black
4157 A SKYLIT DRIVE Breathe Easy White
7571 LIKE MOTHS TO FLAMES Learn Your Place Black
8978 CHUNK!NO,CAPTAIN CHUNK! Pardon My French Black
9026 OF MICE & MEN Wave Black T-Shirt
9394 DANCE GAVIN DANCE WWJCD Black
9423 WE CAME AS ROMANS Alive Red Rubber Bracelet
11160 MEMPHIS MAY FIRE Shield Heather Hooded
11214 Iwrestledabearonce Late Crest Black/Heather Crew
11288 BLACK VEIL BRIDES Stitch Black
11427 IWRESTLEDABEARONCE Letters To Stallone Black
11469 GET SCARED Logo Die-Cut Black Wristband
11470 WE CAME AS ROMANS Zox
11472 PIERCE THE VEIL Splatter Logo White Wristband
13903 LINKIN PARK GOTHIC LOGO WALLET
14429 GREEN DAY DOOKIE VINTAGE T-Shirt(B)
14433 THE DEVIL WEARS PRADA Custom BlackGrey Pants(B)
15350 WHITECHAPEL Two Tone Sawblade Black Wristband
15379 THE SUMMER SET Love Like This Black
15406 MEMPHIS MAY FIRE Unconditional Black
15460 MOTIONLESS IN WHITE Creatures White Dog Tag
15476 ATTILA Album Art Black
15512 WE CAME AS ROMANS Fade Away Black
15536 MAYDAY PARADE Umbrellas Black
15539 MAYDAY PARADE Logo & Broken Heart Sheet
15597 BREATHE CAROLINA We Are Savages Glow-In-The-Dark
17482 WHITECHAPEL Hold The World Black(B)
17542 AGAINST ME! Heads T-Shirt WHITE(B)
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
17757 a crowd of rebellion Towel Blue
18023 WARBRINGER LIVING WEAPON
18044 PENNYWISE Large Gray Logo
18897 【a crowd of rebellion × ゲキクロ】限定デザインZOX STRAPS
19156 a crowd of rebellion Blood Sphere Ver2 WHITE
19157 a crowd of rebellion Blood Sphere Ver2 BLACK
19158 a crowd of rebellion 【お犬様】
19801 CHUNK!NO,CAPTAIN CHUNK! Gray Text
19878 IWRESTLEDABEARONCE Bear Paw Black Cinch Bag
20554 PALISADES Kanji White Glow-in-the-Dark Wristband
21136 BEFORE MY LIFE FAILS Sunglasses - Fires
22705 5 SECONDS OF SUMMER Outer Space Tote
24555 BLESS THE FALL To Those Left Behind Black
24659 GET SCARED Ouija - Necklace
24707 MEMPHIS MAY FIRE M Logo Blue - Cinch Bag
25169 AUGUST BURNS RED Album White - T-Shirt
25226 MISS FORTUNE Logo Green (Glow In The Dark) - Wristband
25244 CHUNK!NO,CAPTAIN CHUNK! Get Lost, Find Yourself Blue
25256 CAPTURE THE CROWN Blue Logo Black - Wristband
25258 CAPTURE THE CROWN I'll End You Black
25419 MAYDAY PARADE Lines White Wristband
25441 MAYDAY PARADE Charm - Friendship Bracelet Set
25444 MAYDAY PARADE Logo Black - Leather Key Chain
25462 OF MICE & MEN Shell Gold - Necklace
25476 PALISADES Wolves Will Eat Your Skin Black - Wristband
25496 BREATHE CAROLINA - Savages - Bottle Opener Necklace
25561 a crowd of rebellion Tシャツ 宇宙人
25562 a crowd of rebellion Tシャツ あーす
25563 a crowd of rebellion Tシャツ ごま達 反逆
25567 a crowd of rebellion ロゴどん!タオル ver.2
26138 CONVERGE Logo Bumper Sticker 2x12
26140 CONVERGE Old Logo 18 Sticker
26143 ARCHITECTS Coffin
26145 ARCHITECTS Daybreaker Rubber Bracelet
26147 ARCHITECTS Reaper Black
26191 BAD RELIGION Crossbuster Shot Glass
26195 BAD RELIGION Shadow Cross Coffee Mug - Coffee Mug
26197 BAD RELIGION Suffer Album Cover
26201 BEASTIE BOYS ENAMEL LOGO PIN
26251 DESCENDENTS Bonus Cup Mug
26260 DESCENDENTS I Don't Want To Grow Up - Drink Coozie
26264 DESCENDENTS Live Cartoon Mug
26267 DESCENDENTS Milo Goes To College Coffee Mug
26273 DESCENDENTS I Don't Want To Grow Up Coffee Mug YEL
26276 DESCENDENTS EVERYTHING SUCKS LAPEL PIN
26437 【限定アイテム】a crowd of rebellion 激クロ&VV限定Tシャツ BLUExPINK
26438 【限定アイテム】a crowd of rebellion ゲキクロ&VV 限定Tシャツ WHITExRED
26439 【限定アイテム】a crowd of rebellion 激クロ&VV限定Tシャツ GREENxWHITE
28027 ATTILA VILLAINS T-Shirt
28311 FRONZILLA FZ Black/White Baseball T-Shirt
28719 BRING ME THE HORIZON KALEIDOSCOPE TEE
29547 BEHEMOTH PIT OF SNAKES TEE BLACK
29550 DECAPITATED NIHILITY TEE
29551 DECAPITATED WINDS OF CREATION TEE
31781 KILL STAR CLOTHING (キルスター・クロージング) Bolt Superstar Long Socks [B]
32271 【ゲキクロ限定】 a crowd of rebellion Xanthium Tour 2017 冬期講習 Tシャツ
32275 【ゲキクロ限定】 a crowd of rebellion Xanthium Tour 2017 タオル
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
34347 a crowd of rebellion 10th Anniversary Tour 2017 Towel
34353 a crowd of rebellion 10th Anniversary Tour 2017 iPhone Case
34520 ROLLING STONES 50th Anniversary Cotton Tote Bag
35285 SLIPKNOT Standard Keychain
35529 BULLET FOR MY VALENTINE LOGO BEANIE
35534 BULLET FOR MY VALENTINE Standard Keychain: Logo
35559 BRING ME THE HORIZON This is Sempiternal KEY CHAIN
35605 FIVE FINGER DEATH PUNCH Brass Knuckle KEY HOLDER