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:56:38')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 517)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 240, 120
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
24074 ANIMALIA ANIMAL-AC10 ZINC BANGLE-bull rope BRASS
24075 ANIMALIA ANIMAL-AC10 ZINC BANGLE-bull rope SILVER
24076 ANIMALIA ANIMAL-AC10 ZINC BANGLE-bull rope BLACK
24077 ANIMALIA ANIMAL-AC11 GOOD LUCK HOOF BRASS
24078 ANIMALIA ANIMAL-AC11 GOOD LUCK HOOF SILVER
24079 ANIMALIA ANIMAL-AC11 GOOD LUCK HOOF BLACK
24080 ANIMALIA ANIMAL-AC12 ZINC CROSS BRASS
24081 ANIMALIA ANIMAL-AC12 ZINC CROSS SILVER
24082 ANIMALIA ANIMAL-AC12 ZINC CROSS BLACK
24087 ANIMALIA ANIMAL-AC19 CATTLE DRIVE WALLET-bend BLACK
24088 ANIMALIA ANIMAL-AC19 CATTLE DRIVE WALLET-bend NATURAL /BLACKxNATURAL
24094 ANIMALIA ANIMAL-AC26 CONCHO #001 SILVER.BUFFALO
24095 ANIMALIA ANIMAL-AC26 CONCHO #001 SILVER.HATCHET
24098 ANIMALIA ANIMAL-AC28 CA1849 Coin Ring-BRASS BRASS
24100 ANIMALIA ANIMAL-AC30 LIFE TAG-BRASS&SILVER925 BRASSxSILVER925
24102 ANIMALIA ANIMAL-AC32 ZINC RIGGING #002 BRASS
24104 ANIMALIA ANIMAL-AC34 REEF KNOT RING-BRASS BRASS
24109 ANIMALIA AN16S-AC09 WOOD SKIN Pencil Case NATURAL
24111 ANIMALIA AN16U-AC01 DAY PACK #001 BLACK
24115 ANIMALIA AN16U-AC04 TYVEK Tote WHITE
24116 ANIMALIA AN16U-AC05 TYVEK Pouch WHITE
24122 ANIMALIA AN16U-AC13 CONCHO RING #001 BLACK
24123 ANIMALIA AN16U-AC13 CONCHO RING #001 NATURAL
24124 ANIMALIA AN16U-AC14 CONCHO BANGLE #001 BLACK
24125 ANIMALIA AN16U-AC14 CONCHO BANGLE #001 NATURAL
24898 ANIMALIA GOLD WEST BLK
24899 ANIMALIA GOLD WEST WHT
24900 ANIMALIA DOWN TO TEXAS BLUE
24901 ANIMALIA DOWN TO TEXAS NAVY
24902 ANIMALIA GOOD LUCK HOOF BLK
24903 ANIMALIA GOOD LUCK HOOF SILVER
24904 ANIMALIA ZINC CROSS BRASS
24905 ANIMALIA ZINC CROSS SILVER
24906 ANIMALIA ZINC CROSS BLACK
24907 ANIMALIA 49in Back-Pack
24908 ANIMALIA 49in Wallet-bend
24909 ANIMALIA WOOD SKIN Pencil Case
24910 ANIMALIA WOOD SKIN Bag
24911 ANIMALIA ADVENTURE HAT#003 BLACK
24912 ANIMALIA ADVENTURE HAT#003 OLIVE
24916 ANIMALIA 49in Coin Case
24921 ANIMALIA AA Cap NAVY
24922 ANIMALIA AA Cap BLACK
24925 ANIMALIA SHUNKAMANITO TANKA Cap BLKxWHTxRED
24926 ANIMALIA SHUNKAMANITO TANKA Cap Black
27409 ANIMALIA (アニマリア) ラバーバンド
27595 ANIMALIA AN16A-JK01 Rustic Coat-Paraffin BLACK
27596 ANIMALIA AN16A-JK01 Rustic Coat-Paraffin BROWN
27597 ANIMALIA AN16A-JK02 Player Jacket #001 BLACK
27600 ANIMALIA AN16A-JK03 Harrington jacket #002 NAVYxRED
27607 ANIMALIA AN16A-KN02 Sweater #002 NAVYL
27609 ANIMALIA AN16A-SW01 Rustic Sweat Shirts#001 BLACK
27611 ANIMALIA AN16A-SW01 Rustic Sweat Shirts#001 GRAY
27612 ANIMALIA AN16A-SW02 HOODIE-AA FLAG BLACK
27613 ANIMALIA AN16A-SW02 HOODIE-AA FLAG GRAY
27614 ANIMALIA AN16A-SW03 HOODIE-ORIENTAL LOGO BLACK
27615 ANIMALIA AN16A-SW03 HOODIE-ORIENTAL LOGO GRAY
27618 ANIMALIA AN16A-SW05 Rustic Town WHITE
27619 ANIMALIA AN16A-SW05 Rustic Town GRAY
27620 ANIMALIA AN16A-SW06 BIG HOOD #001 BLACK
27638 ANIMALIA AN16A-TE02 AA FLAG BLACK
27639 ANIMALIA AN16A-TE02 AA FLAG WHITE
27640 ANIMALIA AN16A-TE03 ORIENTAL LOGO BLACK
27641 ANIMALIA AN16A-TE03 ORIENTAL LOGO WHITE
27642 ANIMALIA AN16A-TE04 Chuck Wagon Club WHITE
27646 ANIMALIA AN16A-TE06 49RUSTIX WHITE
27648 ANIMALIA AN16A-TE07 LOGO Hemp Crest BLACK
27649 ANIMALIA AN16A-TE07 LOGO Hemp Crest WHITE
27655 ANIMALIA AN16A-CP01 BEANIE#007 BLACK
27656 ANIMALIA AN16A-CP01 BEANIE#007 RED
27664 ANIMALIA AN16A-CP05 BEANIE#008 BLACK
27666 ANIMALIA AN16A-CP05 BEANIE#008 RED
27669 ANIMALIA AN16A-CP07 Low cap #001 WHITExRED
27676 ANIMALIA ANIMAL-AC10 ZINC BANGLE-bull rope SILVER
27677 ANIMALIA ANIMAL-AC10 ZINC BANGLE-bull rope BLACK
27693 ANIMALIA ANIMAL-AC26 CONCHO #001 SILVER.BUFFALO
27696 ANIMALIA ANIMAL-AC26 CONCHO #001 BRASS.HATCHET
27711 ANIMALIA ANIMAL-AC42 ANIMALIA feat.Jun Murayama-WOODEN LONG HORN BROWN
27712 ANIMALIA ANIMAL-AC43 ANIMALIA feat.Jun Murayama-WOODEN BEAR PAW BROWN
27719 ANIMALIA AN16A-AC03 Chisholm Trail Card Case #001 BLACK
27733 ANIMALIA AN16A-AC11 Cigarette Case #001 SILVER
27734 ANIMALIA AN16A-AC12 Cigarette Pouch BLACK
27735 ANIMALIA AN16A-AC12 Cigarette Pouch RED
27740 ANIMALIA AN16A-AC15 DUCK CLUTCH #001 NATURAL
27741 ANIMALIA AN16A-AC16 DUCK TOTE #001 NATURAL
27766 ANIMALIA AN15SP-CP01 BLEACH BLKDENIM WHT
27767 ANIMALIA AN15SP-CP01 BLEACH BLKDENIM BLK
27768 ANIMALIA AN15SP-CP01 BLEACH LIGHTDENIM WHT
27769 ANIMALIA AN15SP-CP01 BLK HICKORY BLK
27770 ANIMALIA AN15SP-CP01 BLUE HICKORY BLK
27771 ANIMALIA AN15SP-CP01 GRAYCAMOxBLACK BLK
27772 ANIMALIA AN15SP-CP01 WHTxNVxRED BLK
27773 ANIMALIA AN15SP-CP01 GRAYxORANGE WHT
27774 ANIMALIA AN15SP-CP01 GRAYxBURGUNDY BLK
27775 ANIMALIA AN15SP-CP01 REDxBLACK BLK
27776 ANIMALIA AN15SP-CP01 LIGHT DENIM WHT
27777 ANIMALIA AN15SP-CP01 DENIM WHT
27778 ANIMALIA AN15SP-CP01 BLK PAISELY BLK
27779 ANIMALIA AN15SP-CP01 BLK PAISELY WHT
27780 ANIMALIA AN15SP-CP01 NV PAISELY WHT
27781 ANIMALIA AN15SP-CP01 BLK CEMENT WHT
27782 ANIMALIA AN15SP-CP01 BLK CEMENT BLK
27783 ANIMALIA AN15SP-CP01 WHT CEMENT BLK
27784 ANIMALIA AN15SP-CP01 NAVYxGRAY WHT
27786 ANIMALIA AN15SP-CP01 NAVY WHT
27787 ANIMALIA AN15SP-CP01 BLACK WHITE
27789 ANIMALIA AN15SP-CP01 BLACK BLK
27790 ANIMALIA AN15SP-CP01 WHITExBLACK BLK
27791 ANIMALIA AN15SP-CP01 WHITE BLK
27792 ANIMALIA AN15SP-CP01 WHITE WHT
29063 ANIMALIA AN16A-CP07 Low cap #001 WHITExNAVY
29064 ANIMALIA AN16A-CP07 Low cap #001 YELLOWxNAVY
29065 ANIMALIA AN16A-AC17 BLACK Snood #001 BLACK
29066 ANIMALIA AN16A-AC17 BLACK Snood #001 OLIVE
29067 ANIMALIA AN16A-CP03 CAP BLACK
31556 ANIMALIA AN17S-SW04 MASHBILL-Rustic Sweat Shirts BLACK
31558 ANIMALIA AN17S-SW04 MASHBILL-Rustic Sweat Shirts GRAY