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 11:09:31')
AND pc.price02 > 2727
AND price02 <= 4545
AND pc.stock > 0
AND pc.classcategory_id1 IN( 12,44)
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 MAX(price02)
LIMIT 0, 120
23928 a flood of circle AFOC LOGO TEE WHT
28546 【限定アイテム】ササノマリイ M(OTHER) Tシャツ
37235 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ スカイ
54615 Survive Said The Prophet TAPED LOGO TEE WHITE
62572 Survive Said The Prophet TRADITIONAL TEE
19836 MAYDAY PARADE Upstage White Tank Top
24757 WHITECHAPEL Sawblade Grey on Navy - T-Shirt
25132 SEAWAY Colour Blind Logo Black - T-Shirt
25307 CHIODOS This is Love CRAIG Black - T-Shirt
28295 THE BROWNING Skull Black
28569 EXODUS HORNED SKUL
28026 ATTILA A T-Shirt
42666 夢みるアドレセンス"メロンソーダ" 限定Tシャツ
26543 UROBOROS TシャツB
28020 MYKA RELOCATE MYK-T01 TEE
52941 Survive Said The Prophet VERTICAL LOGO TEE
52942 Survive Said The Prophet MIA TOUR TEE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
15428 THE WORD ALIVE REAL. Album Art Black Tank Top
15601 TEXAS IN JULY Draw The Line Black Tie Dye
18983 WE CAME AS ROMANS Wont Fade Away Navy
18987 WE CAME AS ROMANS Howl At The Moon White
19881 TEXAS IN JULY Brain Black
25148 WE CAME AS ROMANS Slytherin' Carcoal - T-Shirt
37032 PANTERA Reinventing Band
39163 BLACK SABBATH LOTW white Tee
23859 BACKDATE NOVEMBER タイダイ Tee
70717 Survive Said The Prophet MUSEUM TEE
28113 Xmas Eileen ビーチサンダル&ビニールバッグSET BLK
28114 Xmas Eileen ビーチサンダル&ビニールバッグSET WHT
25164 WE CAME AS ROMANS Regular Dudes Black - T-Shirt
35502 SLIPKNOT Blocks T-Shirt
35589 BRING ME THE HORIZON The H T-Shirts
35602 DISTURBED FIRE BEHIND T-SHIRTS
36657 FIVE FINGER DEATH PUNCH EAGLE PUNCH
36662 GUNS N' ROSES BULLET CLASSIC GRAY
36695 SLAYER LARGE BLACK EAGLE
23747 9mm Parabellum Bullet Photo Tシャツ
23748 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) BLK
23749 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) NVY
52512 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) ORANGE
70714 Survive Said The Prophet MAKE / BREAK TEE (BLACK)
70715 Survive Said The Prophet MAKE / BREAK TEE (WHITE)
39093 BABYMETAL CROSSBONE EYE SKELETON MENS SOFT TEE
50367 MODERN DAY BABYLON Ocean Atlas T-shirt
41074 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 WHITE / PURPLE
700 METALLICA-KILL EM ALL
1097 RED HOT CHILI PEPPERS Asterisk Logo White
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
8372 FALLING IN REVERSE Lips T-Shirt BLACK
10233 METALLICA DORIS T-Shirt
10258 GUNS N' ROSES CROSS T-Shirt
11984 ANTHRAX WORSHIP MUSIC T-Shirt
12020 EVANESCENCE SHINE T-Shirt
28592 MARILYN MANSON CROWN T-Shirts
28694 AUGUST BURNS RED DOVE
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
35645 MARILYN MANSON THE PALE EMPEROR T-SHIRTS
35655 PANTERA Red Vulgar T-Shirts
36830 GREEN DAY American Idiot Black T-shirt
37810 BULLET FOR MY VALENTINE Logo T-shirt Black
37811 ALL TIME LOW UNISEX TEE: SCRATCH
43345 BRING ME THE HORIZON Sempiternal TEE
45947 BRING ME THE HORIZON UMBRELLA (BURN OUT) GRAY
45953 Crossfaith ORNAMENT TEE BLACK
51199 SLIPKNOT UNISEX TEE: WANYK LOGO (BACK PRINT)
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
51425 GREEN DAY Unisex Tee: Drips
51426 GREEN DAY Unisex Tee: Hypno 4
52510 BILLIE EILISH UNISEX TEE GRAFFITI WHITE
52713 BABYMETAL UNISEX TEE: LOGO
52866 BILLIE EILISH UNISEX TEE AGONY WHITE
52867 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) PINK
52868 BILLIE EILISH UNISEX TEE GRAFFITI BLACK
52869 BILLIE EILISH UNISEX TEE: BLING BLACK
52870 BILLIE EILISH UNISEX TEE: BLING WHITE
52871 BILLIE EILISH UNISEX TEE: PLEASE YOU
52903 MY CHEMICAL ROMANCE UNISEX TEE: SHREDDED
52907 KORN UNISEX TEE: DEATH DREAM
52928 RAGE AGAINST THE MACHINE UNISEX TEE: MOTOTOV (BACK PRINT)
53184 ALL TIME LOW UNISEX TEE: DA BOMB
53188 BLINK-182 UNISEX TEE: SIX ARROW SMILEY BLACK
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53193 OF MICE & MEN UNISEX TEE: CENTENNIAL
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
54740 ANTHRAX UNISEX TEE: AMONG THE LIVING
54741 ANTHRAX UNISEX TEE: STATE OF EUPHORIA
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
55731 SLAYER UNISEX TEE: SOLDIER CROSS V.2
55732 SLAYER UNISEX TEE: REPENTLESS
55734 SLAYER UNISEX TEE: SILVER EAGLE
56810 AC/DC UNISEX TEE: ANGUS STATUE
56811 AC/DC UNISEX FASHION TEE: BLACK ICE (BURN OUT)
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
59253 NIRVANA Unisex Tee:Xerox Happy Face Pink
59255 NIRVANA Unisex Tee:White Happy Face
59257 NINE INCH NAILS Unisex Tee: Classic Logo
59258 Kurt Cobain Unisex Tee: Coloured Side View
59266 Ed Sheeran Unisex Tee: Divide
59275 METALLICA UNISEX TEE: Ride The Lightning Tracks (Back Print)
59276 METALLICA UNISEX TEE: Heart Explosive (Back Print)
59278 BABYMETAL PENTAGRAM TEE
60185 BLINK-182 UNISEX T-SHIRT: NEON LOGO
60189 MY CHEMICAL ROMANCE MY CHEMICAL ROMANCE UNISEX T-SHIRT: THE BLACK PARADE COVER
60191 MARILYN MANSON UNISEX T-SHIRT: WE ARE CHAOS (BACK PRINT)
66944 KORN UNISEX T-SHIRT: BLOCKS
66953 MY CHEMICAL ROMANCE UNISEX T-SHIRT: CIRCLE MARCH
66968 MEGADETH UNISEX T-SHIRT: PEACE SELLS… TRACK LIST (BACK PRINT)
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
67504 RED HOT CHILI PEPPERS UNISEX T-SHIRT: BLACK & WHITE LOGO
67508 SUM41 UNISEX T-SHIRT: OUT FOR BLOOD (BACK PRINT)
67929 BLINK-182 UNISEX T-SHIRT: LONELY NIGHTS
67931 BLUR UNISEX T-SHIRT: CIRCLE LOGO
67934 BRING ME THE HORIZON UNISEX T-SHIRT: ZOMBIE HANDS
67940 BRING ME THE HORIZON UNISEX T-SHIRT: WARRIOR
67941 EVANESCENCE UNISEX T-SHIRT: SYNTHESIS
67942 FALL OUT BOY UNISEX T-SHIRT: SAVE ROCK AND ROLL
67943 FALL OUT BOY UNISEX T-SHIRT: PUNK SCRATCH