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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-29 03:10:32')
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
16679 【ゲキクロ限定カラー】lynch. ツアーTシャツ BLUE
16682 【ゲキクロ限定カラー】lynch. ツアーTシャツ GRAY
52942 Survive Said The Prophet MIA TOUR TEE
52948 Survive Said The Prophet UNBALANCE TEE LIGHT BLUE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
52951 Survive Said The Prophet UNBALANCE TEE YELLOW
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
49720 Survive Said The Prophet NEW SCHOOL TEE (BLACK)
52941 Survive Said The Prophet VERTICAL LOGO TEE
54616 Survive Said The Prophet TAPED LOGO TEE BLACK
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
4349 ENTER SHIKARI Destabilize Tour Black
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
7432 WOE IS ME Griffin Black
9317 MEMPHIS MAY FIRE Challenger Black T-Shirt
9322 CAPTURE THE CROWN Walking Dead Black
9369 ATTILA Sugar Skull Black T-Shirt
9391 CROWN THE EMPIRE Axe Black T-Shirt
9424 WHITECHAPEL Riot Black T-Shirt
9428 THE WORD ALIVE Bullets Black T-Shirt
9433 OH SLEEPER Endseekers T-Shirt
9644 SLIP&Co. BAMBINX TEE BLACK
10228 ASKING ALEXANDRIA RIDE FOR DEATH T-Shirt
10236 METALLICA JUSTICE FOR ALL T-Shirt
10242 JOB FOR A COWBOY JOB RORSCHACH T-Shirt
10272 IRON MAIDEN KILLERS Large Print T-Shirt
11236 WOE IS ME Circus Revenge Black
11257 A SKYLIT DRIVE Gorilla Vs. Raptor Black
11283 CAPTURE THE CROWN Gargoyle Black
11284 ENTER SHIKARI Stealth Black
11285 Nine Microphones BE ON STAGE S/S BLACK
11302 MAYDAY PARADE Lightning Mic Black T-Shirt
11311 ENTER SHIKARI Return To Black
11419 CAPTURE THE CROWN Doggie Black
11432 WHITECHAPEL Priest Black T-Shirt
11440 TEXAS IN JULY Bed Of Nails Black
11445 WHITECHAPEL Ouija Black Girl T-Shirt
11451 TEXAS IN JULY Without A Head! Black
11454 THE WORD ALIVE I'd Rather Die Black
11932 AC/DC THUNDER LOGO T-Shirt
11939 AMON AMARTH LOGO RUNE T-Shirt
12026 MEGADETH EXPLODING VIC T-Shirt
12162 SPITFIRE MASSACRE S/S Tee BLACK
13900 NEW BREED The DIVIDE TEE
14880 SO SO HAPPY You Make Me Melt
14988 Agape Attire SON OF THE MOST HIGH TEE
15171 フクザワ 知らん女の自撮りTシャツ
15342 WHITECHAPEL Doom Black
15351 WHITECHAPEL Backfire Black
15386 NORTHLANE Snakes Black
15408 MEMPHIS MAY FIRE Red Logo Black
15409 MEMPHIS MAY FIRE Texas Torch Black
15427 THE WORD ALIVE Lighthouse Black
15428 THE WORD ALIVE REAL. Album Art Black Tank Top
15435 PIERCE THE VEIL Logo Black
15436 PIERCE THE VEIL Seal Black T-Shirt
15437 THE WORD ALIVE Poseiden Black
15464 MOTIONLESS IN WHITE Raven Black TEE
15467 CHIODOS This Is Love Band - T-Shirt
15496 ALL THAT REMAINS A War You Cannot Win Black
15508 WE CAME AS ROMANS Dave & Kyle Live Black T-Shirt
15509 WE CAME AS ROMANS Reasons Black
15510 WE CAME AS ROMANS Hope Crest Black
15532 MAYDAY PARADE Photo Black
15535 MAYDAY PARADE Broken Heart Black
15537 MAYDAY PARADE Chain Gang Black
15549 NEW BREED SKULL TEE
15582 TEXAS IN JULY Vice Black
15601 TEXAS IN JULY Draw The Line Black Tie Dye
16037 Subciety PAISLEY TEE-Parantica sita- BLACK
16616 this is not a business カタカナTシャツ
17973 UNEARTH SKATE RAGE
18103 KILL STAR CLOTHING HORNY T-SHIRT [B]
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
18979 MEMPHIS MAY FIRE Nautical Black
18981 MEMPHIS MAY FIRE Cartoon Matty Black
19001 WHITECHAPEL Pocket Blade Black
19004 WHITECHAPEL Simple Flag Black
19093 ATTILA South By Suck My Fuck Black
19095 ATTILA Biker Black T-Shirt
19096 ATTILA Bad Reputation Black
19107 ATTILA SLUGGER BLACK
19805 CAPTURE THE CROWN Coat Of Arms Black
19810 CAPTURE THE CROWN Leopard
19881 TEXAS IN JULY Brain Black
19884 WITHIN THE RUINS Agent Of Chaos Black
19894 FINCH Hand Heather RED T-Shirt
20115 KILL STAR CLOTHING RA T-SHIRT [B]
20126 激ロック×サボパン【激サボパンTシャツ】 BLACK
20169 FUZZ REZ ZWEEP DELAY TEE BLK
20216 【激ロック限定デザイン】NINJA KORE THE NINJA
20217 【激ロック限定デザイン】NINJA KORE MR.BOMB
20303 REBEL8 GR8FUL TEE
20483 FAR★STAR 百目♀鼠 T&ショートT
20485 FAR★STAR Sperm ショートT フリーサイズ
20553 PALISADES Wolves...TS Black
21079 ライブキッズあるある ライブキッズTシャツ
21086 ヒステリックパニック 「オトナとオモチャでアソボウゼー!!TOUR 2015」ツアーT BLK
21124 ATTILA Dirty Black
21125 BEARTOOTH Generation Of Disorder Black
21141 BEFORE MY LIFE FAILS NEW LOGO TEE BLACK
21159 BLACK CRAFT Aquarius
21573 aquarifa レイ Tシャツ ウィメンズ ブラック
21968 セプテンバーミー ユーレイTシャツ 黒
21977 セプテンバーミー YES! YES! YES! Tシャツ 黒
21991 THREE LIGHTS DOWN KINGS FIRE T-Shirts BLACK
22098 FUZZ REZ ZWEEP MODULATION TEE BLK
22102 FUZZ REZ ZWEEP BIT CRUSHER TEE BLK
22188 KILL STAR CLOTHING(キルスター・クロージング) Azrael T-Shirt
22377 小南泰葉 「EMETH」 Tシャツ
22613 Bentham cokeTシャツ BLK
22681 ライブキッズあるある ライブ行きたいTシャツ
22718 ザ・チャレンジ カラフルBOXロゴ Tシャツ BLK
23454 HER NAME IN BLOOD BEAST MODE TOUR T-Shirts
23685 SPITFIRE Malt Bighead Black
23748 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) BLK
24258 UNDEAD CORPORATION 朱美デザインTシャツ BLACK
24260 UNDEAD CORPORATION LOGO Tshirt BLK×GOLD