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 =330
)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:22:40')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 60
11119 REBEL8 STANDARD ISSUE CANVAS WALLET
13440 PUNK DRUNKERS MADBALLS コインケース BLUE
13441 PUNK DRUNKERS MADBALLS コインケース PINK
13731 REBEL8 LEATHER WALLET
13732 REBEL8 STANDARD ISSUE LEATHER WALLET
13792 KORN LOGO Wallet
13902 BULLET FOR MY VALENTINE SKULL AND STRIDES Wallet
14609 SLIPKNOT SCRATCHED GROUP CHAIN WALLET
14664 SO SO HAPPY Doomdrop Coin Purse
14666 SO SO HAPPY Taco Coin Purse
14670 SO SO HAPPY Wink Coin Purse
17335 ZEPHYREN (ゼファレン) PAISLEY LETHER WALLET -LONG- BROWN
17971 KILLSWITCH ENGAGE DRAGON ZOMBIE WALLET
19754 ZEPHYREN (ゼファレン) PAISLEY LETHER WALLET -LONG - BLACK
19756 ZEPHYREN (ゼファレン) PAISLEY LETHER WALLET -LONG - NAVY
19969 IRON FIST CLOTHING MY LITTLE PONY MERRY GO ROUND
20156 REBEL8 GIANT FLASH VELCRO WALLET
20292 REBEL8 DOMINEIGHT WALLET
21104 Stay Sick Clothing Diamond Anchor Black Wallet
21381 THRASHER THRSG-100 W.ANIMAL
21382 THRASHER HRSG-101 W.ANIMAL
21383 THRASHER HRSG-101 BLUE
21698 FAMOUS STARS AND STRAPS RAISED ON RAP WALLET
22489 DROP DEAD CLOTHING (ドロップデッド・クロージング) Traveller Wallet for iPhone6Plus
23756 9mm Parabellum Bullet コインケース BLK
24066 ANIMALIA ANIMAL-AC07 CATTLE DRIVE WALLET BLACK
24067 ANIMALIA ANIMAL-AC07 CATTLE DRIVE WALLET NATURAL
24069 ANIMALIA ANIMAL-AC08 CATTLE DRIVE BUSINESS CARD CASE BLACK
24070 ANIMALIA ANIMAL-AC08 CATTLE DRIVE BUSINESS CARD CASE NATURAL
24087 ANIMALIA ANIMAL-AC19 CATTLE DRIVE WALLET-bend BLACK
24088 ANIMALIA ANIMAL-AC19 CATTLE DRIVE WALLET-bend NATURAL /BLACKxNATURAL
24908 ANIMALIA 49in Wallet-bend
26528 PUNK DRUNKERS 侵略財布 カラフル
26529 PUNK DRUNKERS 侵略財布 BROWN
26530 PUNK DRUNKERS 侵略コインケース カラフル
26531 PUNK DRUNKERS 侵略コインケース BROWN
27402 Zephyren (ゼファレン) PAISLEY LETHER WALLET BLACK
27719 ANIMALIA AN16A-AC03 Chisholm Trail Card Case #001 BLACK
28044 SPITFIRE Classic Bighead Tri-Fold Wallet - Red
28071 PUNK DRUNKERS 【PDSxTREST】ICパスケース まるロゴ
28072 PUNK DRUNKERS 【PDSxTREST】ICパスケース スーパー飛脚ランド
28708 SLAYER BLACK EAGLE Wallet
28980 PUNK DRUNKERS カセット財布 RED
28982 PUNK DRUNKERS カセット財布 GREEN
29540 Artemis Classic ショートウォレットヌバッククロコスタイル[ACSW0001]
29541 Artemis Classic ショートウォレットリザードスタイル[ACSW0002]
29542 Artemis Classic ACW0006 ロングウォレットリザードスタイル
29954 amazarashi coin case
30025 SQUARE (スクエア) CARD CASE "TYPE A"
30026 SQUARE (スクエア) CARD CASE "TYPE B"
30041 KILL STAR CLOTHING Salem Large Wallet [B]
30069 DISTURBIA CLOTHING Oracle Purse
30070 DISTURBIA CLOTHING Serpent Purse
31753 KILL STAR CLOTHING (キルスター・クロージング) Casey Coffin Wallet [B]
31791 フクザワ 静穏パスケース
32399 KILL STAR CLOTHING Tarot Wallet [B]
32422 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Yellow-Blue
32423 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Blue-Pink
32424 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Purple-Green
32425 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Black-White