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-01 16:02:52')
AND pc.classcategory_id1 IN( 15,19,61)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 180
70225 NOTBADCAT (ノットバッドキャット) cats LS Tee
64934 MISHKA (ミシカ) M21100902 SHORTS
66731 NOTBADCAT (ノットバッドキャット) ニャルボロ LS Tee WHITE
66732 NOTBADCAT (ノットバッドキャット) ラッキーストニャイク LS Tee BLACK
67906 RIPNDIP (リップンディップ) Sprinkles Swim Shorts (Black)
67905 RIPNDIP (リップンディップ) Family Tree Swim Shorts (Black)
66237 glamb(グラム) Katsuki Bakugo T Black
66238 glamb(グラム) Shoto Todoroki T Black
66240 glamb(グラム) Eraser Head T Black
66733 NOTBADCAT (ノットバッドキャット) ニャルボロ LS Tee BLACK
66730 NOTBADCAT (ノットバッドキャット) ラッキーストニャイク LS Tee WHITE
66735 NOTBADCAT (ノットバッドキャット)ハイニャイトメンソール LS Tee BLACK
66734 NOTBADCAT (ノットバッドキャット)ハイニャイトメンソール LS Tee WHITE
58826 MISHKA(ミシカ) M21000823 SHORTS
58134 MISHKA M21000809 Shorts
58363 KILL STAR CLOTHING Savage Mini Skirt [LEOPARD]
62525 KILL STAR Light Speed Leggings
62526 KILL STAR Kick It Leggings
62174 KILL STAR Arya Maxi Skirt
60607 RIPNDIP Ripntail Sweatshorts (Blue Mineral Wash)
60608 RIPNDIP Beverly Nylon Cargo Shorts (Blue)
54736 acOlaSia “LOT””SKULL”ハイカットスニーカー BLACK
58362 KILL STAR CLOTHING Wild Side Work Shirt
58376 WASTED PARIS Pants Knit Diaz Black
44087 mnml(ミニマル) CARGO DRAWCORD PANTS BLACK
46298 mnml(ミニマル) CARGO DRAWCORD PANTS Camo
57244 mnml(ミニマル) TRACK PANTS RED
55926 MISHKA MAW200904 PANTS
11076 RUDIE'S (ルーディーズ) FULL EFFECT Tee WHITE
55685 RIP DESIGN WORXX シークレットスマイルスキニーパンツ CRUSH
51128 NineMicrophones Pray with the microphone S/S BLACK
12479 Subciety TIE DYE TEE S/S GRAY
9219 Subciety MAD Ollie 2013 –SENDAI- WHITE
9218 Subciety MAD Ollie 2013 –SENDAI- BLACK
8773 Subciety MAD Ollie 2013 –NAGOYA- BLACK/GRAY
11187 Subciety A.V.E.S.T TEE -ROCKIN IN THE COFFIN-BLKW
11864 Subciety PATTERNED TEE S/S -GLORIOUS- PINK
12333 Subciety Guadalupe S/S WHITE
12458 Subciety TRUST S/S WHITE
12459 Subciety TRUST S/S BLACK/WHITE
12460 Subciety MAD HATTER S/S -Baphomet-WHITE
12620 Subciety SURF SKULL S/S NAVY
12621 Subciety SURF SKULL S/S BGN
12626 Subciety HEART BIRD S/S GREEN
11866 Subciety PATTERNED TEE S/S -GLORIOUS- DENIM
54737 acOlaSia “LOT””SKULL”ハイカットスニーカー SKULL
618 激ロックFES vol.2 Tシャツ-Red
841 激ロックFES vol.3 Tシャツ-PU
842 激ロックFES vol.3 Tシャツ-GR
844 激ロックFES vol.4 Tシャツ-PU
845 激ロックFES vol.4 Tシャツ-GR
888 IRON FIST CLOTHING-Daniel Son S/S Tee
919 The Devil Wears Prada Virus Allover Print T-Shirt
1896 IWRESTLEDABEARONCE Home Black T-Shirt
3555 Nine Microphones Pray with the microphone R-S/S BK
4227 Nine Microphones MAD SKULL S/S BK/WH
4349 ENTER SHIKARI Destabilize Tour Black
4745 DROP DEAD CLOTHING MOMMY'S VERY ANGRY
4792 DROP DEAD CLOTHING LET'S FUCK
4794 DROP DEAD CLOTHING EYE HEART DROP DEAD
4826 LOWLIFE Wallace - Riveted Belt Slate Grey
4827 LOWLIFE Wallace Riveted Belt BLACK
4828 LOWLIFE Triples Studded Belt Black/White
4936 ARKAIK CLOTHING BLACK TANK TOP(B)
5070 Subciety PRAYING HANDS R-L/S BK/WH
5625 MISHKA D.A. SCRIMMAGE T-SHIRT BLACK
6021 OF MICE & MEN Faithfulness Black T-Shirt
6147 THE WORD ALIVE Minotaur Black
6265 MISHKA (ミシカ) ANTIGONE BUTTON-UP WHITE
6285 MISHKA (ミシカ) KEEP WATCH T-SHIRT WHITE
6291 MISHKA (ミシカ) WESTWORLD T-SHIRT BLACK
6316 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK NAVY
6317 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK BLACK
6435 MISHKA (ミシカ) KEEP WATCH BASEBALL JACKET BLACK
6462 Subciety A.V.E.S.T Vol.6 TEE 1 -EAGLE MAN-GRY
6566 MISHKA DART RING T-SHIRT BLACK
6568 MISHKA (ミシカ) SKY BEAR MOP T-SHIRT BLACK
6573 MISHKA (ミシカ) DEATH ADDERS T-SHIRT BLACK
6612 MISHKA (ミシカ) The Keep Watch or Die Tee in Black
7276 KILL STAR CLOTHING OCCULT RACERBACK DRESS [B]
7282 MISHKA (ミシカ) PIXEL MOP T-SHIRT BLACK
7289 MISHKA (ミシカ) KEEP WATCH TANK TOP WHITE
7432 WOE IS ME Griffin Black
7445 MAYDAY PARADE All I Do Black
7495 OF MICE & MEN Wave Black Tank Top
7506 MAYDAY PARADE Meowday Purrrade Black
8111 RUDIE'S TONE 3/4 RAGLAN BLACK/BLACK
8139 MISHKA (ミシカ) KEEP WATCH CARDIGAN HEATHER GREY
8142 MISHKA KEEP WATCH VINTAGE JACKET HEATHER CRIMSON
8266 MISHKA (ミシカ) VERMILYEA KEEP WATCH T-SHIRT BLACK
8299 Nine Microphones Pray with the microphone S/S NAVY
8306 Nine Microphones The angel soare S/S BLK
8307 Nine Microphones The angel soare S/S NAVY
8309 Nine Microphones The angel soare S/S GRAY
8346 RUDIE'S U×G×R L/S-Tee BLACK
8384 Nine Microphones Spoiled a Dog S/S WHITE
8443 Nine Microphones Pray with the microphone 7/S NAVY
8444 Nine Microphones 9MC Crew 7/S NAVY
8446 Nine Microphones The angel soare L/S BLK/BRG
8615 DROP DEAD CLOTHING WOAH VAL CROP T-SHIRT
8772 Subciety MAD Ollie 2013 –NAGOYA- BLACK/WHITE
8778 MISHKA (ミシカ) FOLEY LETTERMAN JACKET BLACK
8921 MISHKA (ミシカ) OVERSIZE ETD BADGE T-SHIRT ATHLETIC HEATHER
8923 MISHKA (ミシカ) OVERSIZE ETD BADGE T-SHIRT BLACK
8953 RUDIE'S SAP HOOD SW BLACK
9058 ELECTRIC ZOMBIE Party Animal Re-Animated Slate
9173 MOTIONLESS IN WHITE America Black T-Shirt
9174 MOTIONLESS IN WHITE Middle Finger Black
9182 MISHKA (ミシカ) RAKE CPO JACKET ARMY GREEN
9183 MISHKA (ミシカ) RAKE CPO JACKET BLACK
9304 MISHKA DEATH ADDERS FLEECE JACKET BROWN
9494 MISHKA LAMOUR KEEP WATCH T-SHIRT BLACK
9495 MISHKA (ミシカ) KEEP WATCH T-SHIRT BURGUNDY
9497 MISHKA (ミシカ) KEEP WATCH T-SHIRT HEATHER
9502 MISHKA (ミシカ) DEATH ADDER T-SHIRT BLACK/LIGHTGREEN
9503 MISHKA (ミシカ) LUNAR SCORPION T-SHIRT BLACK
9509 MISHKA (ミシカ) ENFORCER T-SHIRT BLACK
9510 MISHKA (ミシカ) CYCO SERPENT T-SHIRT BLACK
9728 Subciety FUCK RING A.SILVER
9729 Subciety FUCK RING SILVER
9730 Subciety FUCK RING A.GOLD
10028 MISHKA (ミシカ) AOD NECRONOMICON T-SHIRT BLACK
10070 MISHKA (ミシカ) ANIMAL PARADE BUTTON UP STORMY BLACK
10071 MISHKA (ミシカ) TERRITORY BUTTON UP WHITE
10345 LOWLIFE IRON MAIDEN Live After Death Belt
10346 LOWLIFE JACK PHOTO PRINT Belt
10347 LOWLIFE Black Red Swyd Perf Belt
10490 SHRAPNEL STREETWEAR Drop The Bass Tee BLACK
10583 LOWLIFE COVER UP SLIM Belt BLACK
10608 MISHKA (ミシカ) HELLA STUFF PULLOVER WHITE
10660 MISHKA (ミシカ) ETD CRACKLED DEBOSSED BELT BLACK
10720 DROP DEAD CLOTHING DROP OUT T-SHIRT
10738 DROP DEAD CLOTHING HAVARD SHIRT
10748 DROP DEAD CLOTHING CLIQUE SWEATER
10749 DROP DEAD CLOTHING OWENS SWEATER
10755 DROP DEAD CLOTHING RUPERT SWEATER
10788 DROP DEAD CLOTHING AK'S PULLOVER HOODY
10791 MISHKA (ミシカ) BEAST OF THE EAST T-SHIRT BLACK YELLOW
10800 DROP DEAD CLOTHING CLOAQ JACKET
10812 MISHKA (ミシカ) DAVY JONES LOCKER T-SHIRT WHITE
10814 MISHKA (ミシカ) DAVY JONES LOCKER T-SHIRT BLACK
10833 MISHKA (ミシカ) LAMOUR RING OF HELL KW TANK TOP BLACK
11021 VANS APPAREL INDY TOOLS OF THE TRADE T-Shirt BLACK
11059 VANS APPAREL RUSDEN IKAT S/S SHIRT LIVING CORAL
11060 VANS APPAREL RUSDEN IKAT S/S SHIRT NAVY
11061 VANS APPAREL CHECKED OUT S/S WOVEN SHIRT BLUE
11062 VANS APPAREL CHECKED OUT S/S WOVEN SHIRT RED
11088 MISHKA (ミシカ) OVER SIZE BEAR MOP TIE-DYE T-SHIRT MAGENTA
11093 MISHKA (ミシカ) THE CYRILLIC MOSAIC POCKET TEE BLACK
11096 MISHKA (ミシカ) THE HELLA STUFF S/S BUTTONDOWN BLACK
11097 MISHKA (ミシカ) THE HELLA STUFF S/S BUTTONDOWN WHITE
11180 Subciety A.V.E.S.T TEE -LOUD NOISE OF SILENSE-BLKW
11229 Nine Microphones HEAVEN S/S Gray
11232 ENTER SHIKARI Fear Not Navy
11236 WOE IS ME Circus Revenge Black
11242 ENTER SHIKARI Police Natural
11246 BREATHE CAROLINA Mammoth Black
11251 MOTIONLESS IN WHITE Mask Black
11256 MAYDAY PARADE Photo Collage Black
11257 A SKYLIT DRIVE Gorilla Vs. Raptor Black
11284 ENTER SHIKARI Stealth Black
11285 Nine Microphones BE ON STAGE S/S BLACK
11287 Nine Microphones BE ON STAGE S/S DENIM
11301 ENTER SHIKARI Texas Silver
11302 MAYDAY PARADE Lightning Mic Black T-Shirt
11305 ENTER SHIKARI Band Charcoal
11308 MOTIONLESS IN WHITE Grim Reaper Black
11310 MOTIONLESS IN WHITE Puppet Black
11424 OF MICE & MEN Restoring Force Album Heather GRY
11440 TEXAS IN JULY Bed Of Nails Black
11441 MAYDAY PARADE Keyhole Black / White
11495 RUDIE'S DIG Tee BLACK
11502 NineMicrophones SHOUT SKULL S/S BLACK/MUSTARD
11578 KILL STAR CLOTHING GIZA TANK [B]
11708 RUDIE'S BIG-R Tee WHITE
11709 RUDIE'S BIG-R Tee TURQUOISE
11863 Subciety PATTERNED TEE S/S -GLORIOUS- NAVY
11868 Subciety PATTERNED TEE S/S -GLORIOUS- BLACK
11930 Subciety FUCK RING BLACK
11931 Subciety FUCK RING GOLD