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-05-19 04:12:21')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 240
54642 THRASHER TH8177A S.A.D Tee WHITE
54643 THRASHER TH8177A S.A.D Tee BLACK
16679 【ゲキクロ限定カラー】lynch. ツアーTシャツ BLUE
16682 【ゲキクロ限定カラー】lynch. ツアーTシャツ GRAY
9419 WE CAME AS ROMANS Truth Black T-Shirt
14181 METALLICA RIDE LYRICS All Over TEE
29535 CARCASS UNFIT TEE
51193 SLIPKNOT UNISEX FASHION TEE: LOGO & STAR (APPLIQUE MOTIFS)
53924 THRASHER THRASHER DAVID GONZALEZ T-SHIRTS BLUE
54381 Nine Microphones -walkin'mic- S/S - WHITE
54644 THRASHER TH91257 JAN 82 S/S T-SHIRTS
56553 NineMicrophones 9MC Crew S/S White/Burgundy
56555 Subciety A.V.E.S.T TEE -ROCKIN IN THE COFFIN-BGN
56572 NineMicrophones 9MC Crew S/S Blue
56573 SO SO HAPPY Be My Monster Puff Girls T-Shirt
56574 SO SO HAPPY Lucky Wink In Grey
56575 ICECREAM MASH S/S T-SHIRT BLACK
55042 Zephyren(ゼファレン)S/S TEE - VISIONARY - WHITE
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
52950 Survive Said The Prophet UNBALANCE TEE WHITE
52951 Survive Said The Prophet UNBALANCE TEE YELLOW
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
53215 Zephyren(ゼファレン)PONCHO TEE S/S BLACK
54432 THRASHER (スラッシャー) OUTLINED CRACK S/S T-SHIRTS WHITE
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
55631 Anti Social Social Club BAT EMOJI WHITE TEE
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
54648 RUDIE'S (ルーディーズ) SOLID PHAT GRADATION-T BLACK
53248 Zephyren(ゼファレン)PONCHO BIG STRIPE TEE S/S WHITE/BLACK
595 CHILDREN OF BODOM-Bloody Reaper
910 LINKIN PARK Skull Bird T-Shirt
912 BRING ME THE HORIZON BELANGER T-Shirt
919 The Devil Wears Prada Virus Allover Print T-Shirt
1364 RANCID Out Come The Wolves Slim-Fit T-Shirt
1448 CHILDREN OF BODOM REAPER EARTH T-Shirt
2246 BRING ME THE HORIZON LADY OF LIFE T-Shirt
2251 SLIPKNOT 9 FRAMES T-shirt
2269 BLINK182 3BARS T-shirt
2270 BLINK182 CHAMP T-shirt
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
2647 Iwrestledabearonce Claw Black T-Shirt
3064 GREEN DAY NEON WINGS T-shirt
3066 GREEN DAY VANDALS T-Shirt
3156 AVENGED SEVENFOLD SWEET SCREAM T-shirt
3158 BULLET FOR MY VALENTINE SKULL BLOSSOM T-shirt
3160 CHILDREN OF BODOM REAPER LIGHTNING T-shirt
3410 UNEARTH RIBS T-Shirt
3465 DEFTONES WHITE PONY T-Shirt
3601 FOO FIGHTERS RANDOM LETTERS T-Shirt
3616 AVENGED SEVENFOLD ALLOVER DEATHBATS T-Shirt
3617 BLACK VEIL BRIDES ANDY Babydoll
3880 EVANESCENCE WANT Babydoll
4349 ENTER SHIKARI Destabilize Tour Black
4457 SYSTEM OF A DOWN AERIALS T-Shirt
4596 BLINK182 BOXES T-Shirt
4671 KORN CLASSIC T-Shirt
5577 MARILYN MANSON SKULL CROSS T-Shirt
5579 SLIPKNOT MASK HELL T-Shirt
5601 CHELSEA GRIN CROW T-Shirt
5638 OF MICE & MEN EAGLE T-Shirt
5665 METALLICA TIP SCALES T-Shirt
5714 MISS MAY I TIGER T-Shirt
5802 A DAY TO REMEMBER Out Of Time Cards T-Shirt
6021 OF MICE & MEN Faithfulness Black T-Shirt
6022 OF MICE & MEN Ice Age Black
6023 WOE IS ME - Number[s] Stack Black
6145 PROTEST THE HERO Don't Judge A Band White W/ Black
6147 THE WORD ALIVE Minotaur Black
6423 LINKIN PARK LIVING THINGS T-Shirt
6581 A DAY TO REMEMBER BROKEN RECORD T-Shirt
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
6585 GREEN DAY SPIRAL T-Shirt
6586 GREEN DAY DOOKIE VINTAGE T-Shirt
6621 THE USED CD COVER T-Shirt
6622 THE USED USED COLLAGE FACE T-Shirt
7432 WOE IS ME Griffin Black
7437 CHUNK!NO,CAPTAIN CHUNK! Bear Blue T-Shirt
7439 CHUNK!NO,CAPTAIN CHUNK! Eiffel Tower White T-Shirt
7445 MAYDAY PARADE All I Do Black
7448 ISSUES I Have - Heather Grey
7466 MEMPHIS MAY FIRE Richer Black
7477 ISSUES These Colors Don't Bleed Black
7506 MAYDAY PARADE Meowday Purrrade Black
7675 AVENGED SEVENFOLD WORLD DIES T-Shirt
7676 BLINK182 DRIPTYPE T-Shirt
7677 ENTER SHIKARI ALBUM T-Shirt
7682 TOOL CALIFORNIA REPUBLIC T-Shirt
7685 RED HOT CHILI PEPPERS FLY T-Shirt
7687 HOLLYWOOD UNDEAD H.U.4.L. T-Shirt
7711 MUSE ECLIPSE T-Shirt
7713 THE OFFSPRING BREAKING CHAINS Babydoll
7858 BRING ME THE HORIZON Suicide Season Green T-shirt
7859 BRING ME THE HORIZON Sempiternal Album Tee
7861 BRING ME THE HORIZON Suicide Season Girlie Red
7862 BRING ME THE HORIZON Suicide Season Red T-shirt
7952 BRING ME THE HORIZON Suicide Season Tank Top
8024 THE CAB White Tee(B)
8211 OUR LAST NIGHT Evolution Heather GRY/BLK
8336 PARKWAY DRIVE Deep Blue Skyline T-Shirt BLACK
8337 PARKWAY DRIVE Kombi WHITE
8338 PARKWAY DRIVE Anchor Atlas T-Shirt WHITE
8354 PENNYWISE All or Nothing T-Shirt BLACK
8363 CONVERGE Florian White T-Shirt
8377 ALESANA Skeleton Heart T-Shirt BLACK
9022 ISSUES Effing Tri-Heather Gray T-SHIRT
9023 ISSUES Effing Black T-SHIRT
9026 OF MICE & MEN Wave Black T-Shirt
9173 MOTIONLESS IN WHITE America Black T-Shirt
9174 MOTIONLESS IN WHITE Middle Finger Black
9175 MOTIONLESS IN WHITE Chris Photo Black
9176 MOTIONLESS IN WHITE Devil's Night Black
9178 MOTIONLESS IN WHITE Frank White
9179 MOTIONLESS IN WHITE London In Terror Black
9313 MEMPHIS MAY FIRE Identity Navy Blue
9317 MEMPHIS MAY FIRE Challenger Black T-Shirt
9322 CAPTURE THE CROWN Walking Dead Black
9365 ESKIMO CALLBOY E.C. Camo T-Shirt
9369 ATTILA Sugar Skull Black T-Shirt
9372 BLESS THE FALL Lyric Black T-Shirt
9374 BLESS THE FALL Moon White T-Shirt
9378 A SKYLIT DRIVE Channels Heather Gray T-Shirt
9383 PIERCE THE VEIL Photo Black T-Shirt
9386 CHELSEA GRIN Evolve Black T-Shirt
9391 CROWN THE EMPIRE Axe Black T-Shirt
9400 MAYDAY PARADE Heart Photo White T-Shirt
9401 MISERY SIGNALS Eagle Flame BlackT-Shirt
9403 MISS MAY I New Lion Black T-Shirt
9404 SHADOWS FALL Wasteland Black T-Shirt
9409 SLEEPING WITH SIRENS Detailed Feather Whit T-Shirt
9410 SLEEPING WITH SIRENS Feather White T-Shirt
9424 WHITECHAPEL Riot Black T-Shirt
9427 FACELESS Casting The Darkness Black T-Shirt
9428 THE WORD ALIVE Bullets Black T-Shirt
9430 TEXAS IN JULY Draw The Line Red/Orange Tie Dye
9432 TEXAS IN JULY One Reality Black T-Shirt
9433 OH SLEEPER Endseekers T-Shirt
9643 ICECREAM RACING DOG S/S T-SHIRT PURPLE
9644 SLIP&Co. BAMBINX TEE BLACK
9692 SUICIDAL TENDENCIES ST TS 28 Possessed BLK
10227 ASKING ALEXANDRIA HELL GATE T-Shirt
10228 ASKING ALEXANDRIA RIDE FOR DEATH T-Shirt
10229 AVENGED SEVENFOLD END OF DAYS T-Shirt
10230 BLACK VEIL BRIDES RAVEN Babydoll
10231 METALLICA NEVER RED T-Shirt
10232 METALLICA NEVERMORE T-Shirt
10237 METALLICA TOUR 86 T-Shirt
10239 METALLICA HEART EXPLOSIVE T-Shirt
10241 LINKIN PARK GLITCH PORTRAIT T-Shirt
10242 JOB FOR A COWBOY JOB RORSCHACH T-Shirt
10245 LAMB OF GOD CANDLELIGHT T-Shirt
10247 HATEBREED WINGED SKULL T-Shirt
10248 BLINK182 BARS Babydoll T-shirt
10253 MESHUGGAH CATCH 33 T-Shirt
10254 NOFX BUZZ T-Shirt
10255 NOFX OLD SKULL T-Shirt
10256 NAPALM DEATH SCUM VINTAGE T-Shirt
10257 GUNS N' ROSES APPETITE TOUR T-Shirt
10260 RANCID 40 oz T-Shirt
10261 RANCID MONSTER PRINT T-Shirt
10262 PARKWAY DRIVE BAY CREST T-Shirt
10264 FIVE FINGER DEATH PUNCH WOTF NINJA T-Shirt
10265 FIVE FINGER DEATH PUNCH THE CREW T-Shirt
10266 FIVE FINGER DEATH PUNCH THE WAY T-Shirt
10269 FALLING IN REVERSE CITY CROSSES T-Shirt
10270 FALLING IN REVERSE MEDUSA T-Shirt
10271 GREEN DAY PATCHWORK T-Shirt
10272 IRON MAIDEN KILLERS Large Print T-Shirt
10273 IRON MAIDEN OVERSIZED TROOPER Large Print T-Shirt
10274 IRON MAIDEN TROOPER 2 T-Shirt
10310 ESKIMO CALLBOY Cinema T-Shirt
10311 ESKIMO CALLBOY Polar Bear T-Shirt
10312 ESKIMO CALLBOY Puke Girl T-Shirt
10915 FIVE FINGER DEATH PUNCH DAY OF THE FIST T-Shirt(B)
10920 ASKING ALEXANDRIA RIDE FOR DEATH T-Shirt(B)
11229 Nine Microphones HEAVEN S/S Gray
11231 BLACK VEIL BRIDES Swirl Black
11232 ENTER SHIKARI Fear Not Navy
11234 CAPTURE THE CROWN Woman & Skull Black
11236 WOE IS ME Circus Revenge Black
11237 FOR ALL THOSE SLEEPING The Birds White
11241 ERRA Self Control Black
11242 ENTER SHIKARI Police Natural
11243 ENTER SHIKARI Blue Tour Navy
11246 BREATHE CAROLINA Mammoth Black
11248 PROTEST THE HERO Crest White
11249 PROTEST THE HERO Bird Dive Navy Blue
11250 ESKIMO CALLBOY Hairy Black T-Shirt
11251 MOTIONLESS IN WHITE Mask Black
11253 WITHIN THE RUINS Hand Black
11254 BLESS THE FALL We Are The Saints Black
11256 MAYDAY PARADE Photo Collage Black
11257 A SKYLIT DRIVE Gorilla Vs. Raptor Black
11260 I SEE STARS Digital Renegade Black
11261 CHUNK!NO,CAPTAIN CHUNK! Bats Navy
11262 WITHIN THE RUINS Face Black
11277 MAKE ME FAMOUS Lose Your Fear Black
11278 DANGERKIDS CAD Charcoal T-Shirt
11280 PROTEST THE HERO Floating Ship Black
11283 CAPTURE THE CROWN Gargoyle Black
11284 ENTER SHIKARI Stealth Black
11285 Nine Microphones BE ON STAGE S/S BLACK
11287 Nine Microphones BE ON STAGE S/S DENIM
11288 BLACK VEIL BRIDES Stitch Black
11295 SECRETS Floral Skull Black
11296 THE DEVIL WEARS PRADA Trooper Slate Gray
11299 I SEE STARS Wolf Black
11301 ENTER SHIKARI Texas Silver
11302 MAYDAY PARADE Lightning Mic Black T-Shirt
11304 MISERY SIGNALS Absent Light Cover Art Black
11305 ENTER SHIKARI Band Charcoal
11308 MOTIONLESS IN WHITE Grim Reaper Black
11310 MOTIONLESS IN WHITE Puppet Black
11311 ENTER SHIKARI Return To Black
11335 NEW BREED BREAK ON THROUGH T-Shirt
11418 CAPTURE THE CROWN Don't Be A... Black
11419 CAPTURE THE CROWN Doggie Black
11422 BLESS THE FALL Hollow Bodies White T-Shirt
11423 ESKIMO CALLBOY Established Black
11424 OF MICE & MEN Restoring Force Album Heather GRY
11427 IWRESTLEDABEARONCE Letters To Stallone Black
11428 MISERY SIGNALS Rebirth Denim Blue
11429 LIKE MOTHS TO FLAMES Fuck This Life Black
11431 CROWN THE EMPIRE End Of The World Black
11432 WHITECHAPEL Priest Black T-Shirt
11433 CHUNK!NO,CAPTAIN CHUNK! Story Black
11434 ERRA Augment Album Art White T-Shirt
11437 ATTILA Double Skull Black
11438 LIKE MOTHS TO FLAMES Snakes & Heart Black T-Shirt
11439 PROTEST THE HERO Dog Black T-Shirt
11440 TEXAS IN JULY Bed Of Nails Black