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-28 06:18:26')
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, 120
66237 glamb(グラム) Katsuki Bakugo T Black
66238 glamb(グラム) Shoto Todoroki T Black
66240 glamb(グラム) Eraser Head T Black
11076 RUDIE'S (ルーディーズ) FULL EFFECT Tee WHITE
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
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
4792 DROP DEAD CLOTHING LET'S FUCK
5625 MISHKA D.A. SCRIMMAGE T-SHIRT BLACK
6021 OF MICE & MEN Faithfulness Black T-Shirt
6147 THE WORD ALIVE Minotaur Black
6285 MISHKA (ミシカ) KEEP WATCH T-SHIRT WHITE
6291 MISHKA (ミシカ) WESTWORLD T-SHIRT 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
7282 MISHKA (ミシカ) PIXEL MOP T-SHIRT BLACK
7432 WOE IS ME Griffin Black
7445 MAYDAY PARADE All I Do Black
7506 MAYDAY PARADE Meowday Purrrade Black
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
8384 Nine Microphones Spoiled a Dog S/S WHITE
8615 DROP DEAD CLOTHING WOAH VAL CROP T-SHIRT
8772 Subciety MAD Ollie 2013 –NAGOYA- BLACK/WHITE
8921 MISHKA (ミシカ) OVERSIZE ETD BADGE T-SHIRT ATHLETIC HEATHER
8923 MISHKA (ミシカ) OVERSIZE ETD BADGE T-SHIRT BLACK
9058 ELECTRIC ZOMBIE Party Animal Re-Animated Slate
9173 MOTIONLESS IN WHITE America Black T-Shirt
9174 MOTIONLESS IN WHITE Middle Finger Black
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
10028 MISHKA (ミシカ) AOD NECRONOMICON T-SHIRT BLACK
10490 SHRAPNEL STREETWEAR Drop The Bass Tee BLACK
10720 DROP DEAD CLOTHING DROP OUT T-SHIRT
10791 MISHKA (ミシカ) BEAST OF THE EAST T-SHIRT BLACK YELLOW
10812 MISHKA (ミシカ) DAVY JONES LOCKER T-SHIRT WHITE
10814 MISHKA (ミシカ) DAVY JONES LOCKER T-SHIRT BLACK
11021 VANS APPAREL INDY TOOLS OF THE TRADE T-Shirt BLACK
11088 MISHKA (ミシカ) OVER SIZE BEAR MOP TIE-DYE T-SHIRT MAGENTA
11093 MISHKA (ミシカ) THE CYRILLIC MOSAIC POCKET TEE BLACK
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
11495 RUDIE'S DIG Tee BLACK
11502 NineMicrophones SHOUT SKULL S/S BLACK/MUSTARD
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
12143 Subciety PATCHWORK TEE S/S -GLORIOUS- BLACK/WHITE
12197 RUDIE'S × 梅村妃奈子 COLLABORATION-Tee BLACK/WHITE
12476 Subciety TIE DYE TEE S/S BGN
12477 Subciety TIE DYE TEE S/S NAVY
12511 Subciety CALAVERA S/S BLACK
12512 Subciety CALAVERA S/S WHITE
12618 Subciety SURF SKULL S/S BLACK
12622 Subciety HEART BIRD S/S BLACK
12623 Subciety HEART BIRD S/S WHITE
13528 NineMicrophones Power of will S/S WHITE
13530 NineMicrophones Power of will S/S BLACK/BGN
13597 DROP DEAD CLOTHING SPENGBAB T-SHIRT
13598 DROP DEAD CLOTHING STOP FUCKING TALKING TO ME
13601 DROP DEAD CLOTHING WE CUM IN PEACE T-SHIRT
13602 DROP DEAD CLOTHING CRAZY LIFE T-SHIRT
13610 DROP DEAD CLOTHING I WANT TO DIE T-SHIRT
13612 DROP DEAD CLOTHING F.O T-SHIRT
15365 TONIGHT ALIVE Indian Pattern White T-Shirt
15373 NEW FOUND GLORY Juggernaut Black T-Shirt
15374 NEW FOUND GLORY Prophet Black T-Shirt
15376 THE USED Heart White T-Shirt