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 21:35:58')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 60
27818 Crossfaith 2016 SUMMER SILVER 5 PANEL
37046 MARILYN MANSON×KILL STAR CLOTHING Cryptorchid Harness Dress
16679 【ゲキクロ限定カラー】lynch. ツアーTシャツ BLUE
16682 【ゲキクロ限定カラー】lynch. ツアーTシャツ GRAY
46450 Zephyren(ゼファレン)BIG TANKTOP BLACK / 如意宝珠
56555 Subciety A.V.E.S.T TEE -ROCKIN IN THE COFFIN-BGN
56570 ICECREAM IC13H255 Beanie RED
56572 NineMicrophones 9MC Crew S/S Blue
56573 SO SO HAPPY Be My Monster Puff Girls T-Shirt
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT
52439 STAPLE Supernova Bubble Jacket
52447 STAPLE Neo Sport Nylon Crew
55042 Zephyren(ゼファレン)S/S TEE - VISIONARY - WHITE
52942 Survive Said The Prophet MIA TOUR TEE
52946 Survive Said The Prophet CONCRETE COACH JKT WHITE
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
53239 【予約商品】Zephyren(ゼファレン)SWITCHING SHIRT S/S WHITE / RED
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
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
919 The Devil Wears Prada Virus Allover Print T-Shirt
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
2787 ギフトラッピングサービス
4349 ENTER SHIKARI Destabilize Tour Black
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
7258 Artemis Classic ダークドラゴンペンダント[ACP0249]
7269 Artemis Classic トレサリースリーピースレザーブレス[ACB0064]
7432 WOE IS ME Griffin Black
7519 Artemis Classic ルシフェルウイングリングPAVE[ACSR0006PAVE]
7526 Artemis Classic トレサリーブラックスピネルネックレス[ACCN0008]
7532 Artemis Classic スタイリッシュクロスウォレットチェーン[ACWC0010]
9313 MEMPHIS MAY FIRE Identity Navy Blue
9314 MEMPHIS MAY FIRE Challenger Black Tank Top
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
9415 WE CAME AS ROMANS Sideways Black Tank Top
9424 WHITECHAPEL Riot Black T-Shirt
9428 THE WORD ALIVE Bullets Black T-Shirt
9430 TEXAS IN JULY Draw The Line Red/Orange Tie Dye
9433 OH SLEEPER Endseekers T-Shirt
9643 ICECREAM RACING DOG S/S T-SHIRT PURPLE
9644 SLIP&Co. BAMBINX TEE BLACK
9891 KILL STAR CLOTHING GRUMPY SWEATSHIRT
10228 ASKING ALEXANDRIA RIDE FOR DEATH T-Shirt
10236 METALLICA JUSTICE FOR ALL T-Shirt
10242 JOB FOR A COWBOY JOB RORSCHACH T-Shirt
10261 RANCID MONSTER PRINT T-Shirt
10272 IRON MAIDEN KILLERS Large Print T-Shirt
11162 MEMPHIS MAY FIRE Crest Black Hooded
11210 THE FACELESS Autotheism Hoodie Black