SELECT SQL_CALC_FOUND_ROWS 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-04-20 02:29:55')
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 360, 120
31597 ANIMALIA AN17S-CS06 BOLD WEST-Brassard-Huprok BLACK
31600 ANIMALIA AN17S-CS06 BOLD WEST-Brassard-Huprok WHITE
31604 ANIMALIA AN17S-CS01 PORT TOWN 8/10Sleeve BLKxBORDER
31607 ANIMALIA AN17S-CS01 PORT TOWN 8/10Sleeve NAVYxBORDER
31609 ANIMALIA AC46 LONG HORN-ALL BRASS
31610 ANIMALIA AN17S-AC03 WARRIOR BANGLE BRASS
31611 ANIMALIA AN17S-AC03 WARRIOR BANGLE SILVER
31622 ANIMALIA AN17S-AC08 Huprok SOX #001 SAX
31623 ANIMALIA ANIMAL-AC45 DEER HORN-BRASS
31624 ANIMALIA AN17S-AC08 Huprok SOX #001 WHITE
31626 ANIMALIA ANIMAL-AC12 ZINC CROSS BRASS HEADxSILVER CHAIN
31627 ANIMALIA AN17S-AC13 ALUMINUM BOTTLE-300ml BLACK
31628 ANIMALIA AN17S-AC13 ALUMINUM BOTTLE-300ml WHITE
31637 ANIMALIA AN17S-CS02 BOLD WEST-Brassard BLACK
31638 ANIMALIA AN17S-CS02 BOLD WEST-Brassard WHITE
31641 ANIMALIA AN17S-TE01 AMA CLUB BLACK
31642 ANIMALIA AN17S-TE01 AMA CLUB WHITE
31647 ANIMALIA AN17S-TE05 RUSTICLOTHES DEPT. olive
31653 ANIMALIA AN17S-TE06 MASHBILL BLACK
31654 ANIMALIA AN17S-TE06 MASHBILL WHITE
31655 ANIMALIA AN17S-TE07 LOBSTER NAVY
33686 ANIMALIA PHONE CASE LIBERTINE WHITE
33687 ANIMALIA ANIMALIA PHONE CASE LIBERTINE BLACK
33688 ANIMALIA IPHONE6/6S CASE LIBERTINE BLACK
33689 ANIMALIA IPHONE6/6S CASE LIBERTINE WHITE
33710 ANIMALIA AN17U-AC01One Nation-Pierce-SILVER925
33724 ANIMALIA AN17U-CP01 MOBIUS SNAKE CAP BEIGE SNAKE
33725 ANIMALIA AN17U-CP01 MOBIUS SNAKE CAP BLACK SNAKE
33748 ANIMALIA AN17U-AC12 Mobile Battery 4000mAh 17SU BLACK ANCHOR
33749 ANIMALIA AN17U-AC12 Mobile Battery 4000mAh 17SU WHITE TIGER
33751 ANIMALIA AN17U-AC16 HELMET BAG OLIVE
33752 ANIMALIA AN17U-AC16 HELMET BAG BLACK
33754 ANIMALIA AN17U-AC17 DUFFLE BAG OLIVE
33757 ANIMALIA AN17U-AC17 DUFFLE BAG BLACK
33767 ANIMALIA AN17U-CP08 Leeway-Watch BLACK
33770 ANIMALIA AN17U-AC19 COTTON BELT 17SU TURQUOISE
33772 ANIMALIA AN17U-SH05 SWAGGER-Slashed 17SU WASH INDIGO
33774 ANIMALIA AN17U-AC19 COTTON BELT 17SU BLUE
33777 ANIMALIA AN17U-AC19 COTTON BELT 17SU RED
33778 ANIMALIA AN17U-AC19 COTTON BELT 17SU PINK
33780 ANIMALIA AN17U-SW01 ANCHOR Sweat S/S GRAY
33781 ANIMALIA AN17U-SW01 ANCHOR Sweat S/S NAVY
33792 ANIMALIA AN17U-SW02 ANCHOR Sweat-Slashed BLACK
33796 ANIMALIA AN17U-TE01 LOGO-Lame (champion BODY BIG SILHOUETTE) BLACK
33798 ANIMALIA AN17U-TE01 LOGO-Lame (champion BODY BIG SILHOUETTE) WHITE
33799 ANIMALIA AN17U-TE01 LOGO-Lame (champion BODY BIG SILHOUETTE) GRAY
33824 ANIMALIA AN17U-TE05 BLACKFOOT LONG (LONG CORVED SILHOUETTE) BLACK
33826 ANIMALIA AN17U-TE05 BLACKFOOT LONG (LONG CORVED SILHOUETTE) WHITE
33828 ANIMALIA ANIMAL-AC38 PIERCE-Cross SILVER925&BRASS
33829 ANIMALIA AN17U-TE06 Packing Tape-LOGO (BIG WIDTH SILHOUETTE) WHITE
33831 ANIMALIA AN17U-TE06 Packing Tape-LOGO (BIG WIDTH SILHOUETTE) BLACK
33833 ANIMALIA ANIMAL-AC37 PIERCE-Circle SILVER925xBRASS
33836 ANIMALIA AN17U-TE07 WATER FONT-LIR WHITE
33838 ANIMALIA AN17U-PT02 ANGLER SHORTS 17SU (Dickies body) BLACK
33840 ANIMALIA AN17U-PT02 ANGLER SHORTS 17SU (Dickies body) KHAKI
33842 ANIMALIA AN17U-TE08 FIGHT IT OUT WHITE
33843 ANIMALIA AN17U-TE08 FIGHT IT OUT BLACK
33846 ANIMALIA AN17U-CS08 OLD WEST-Plaid WHITE
33850 ANIMALIA AN17U-CS08 OLD WEST-Plaid BLACK
33851 ANIMALIA AN17U-PT03 TRACK SHORTS 17SU BLACK
33859 ANIMALIA AN17U-PT03 TRACK SHORTS 17SU GRAY
33863 ANIMALIA AN17U-PT04 TRACK PANTS 17SU CHARCOAL
33864 ANIMALIA AN17U-PT04 TRACK PANTS 17SU GRAY
33867 ANIMALIA AN17U-PT05 SWIM SHORTS 17SU TIGER CAMO
33871 ANIMALIA AN17U-PT05 SWIM SHORTS 17SU SNOW CAMO
33875 ANIMALIA AN17U-TE13 CRAFTSMAN OLIVE
33877 ANIMALIA AN17U-TE13 CRAFTSMAN BLACK
33879 ANIMALIA ANIMAL-AC30 LIFE TAG-BRASS&SILVER925
33888 ANIMALIA AN17U-SH01 LIBERTINE Shirts 17SU BLACK
34105 ANIMALIA AN17SP-TE01 L/S TEE LOGO WHITExBLACK
34106 ANIMALIA AN17SP-TE01 L/S TEE LOGO BLACKxWHITE
34107 ANIMALIA AN17SP-TE01 L/S TEE LOGO REDxWHITE
34108 ANIMALIA AN17SP-TE02 L/S TEE ONE NATION WHITExBLACK
34109 ANIMALIA AN17SP-TE02 L/S TEE ONE NATION BLACKxWHITE
36879 ANIMALIA IQOSR Case (humboldt×ANIMALIA) (ORTEGA)
36880 ANIMALIA IQOSR Case (humboldt×ANIMALIA) (BLACK)
36881 ANIMALIA IQOSR Case (humboldt×ANIMALIA) (CAMO)
37172 ANIMALIA Coach Jacket : One Nation
37174 ANIMALIA AN17A-SH02 Arrogant Shirts #002 OLD WEST
37177 ANIMALIA AN17A-SW02 SKUNK YOU BLACK
37179 ANIMALIA AN17A-SW02 SKUNK YOU GRAY
37185 ANIMALIA AN17A-SW07 WANNABE BLACK
37194 ANIMALIA AN17A-TE01S/S OLD WEST 1849 BLACK
37195 ANIMALIA AN17A-TE01S/S OLD WEST 1849 WHITE
37196 ANIMALIA AN17A-TE07 S/S SKUNK YOU WHITE
37197 ANIMALIA AN17A-TE07 S/S SKUNK YOU BLACK
37219 ANIMALIA AN17A-TE05 WILD SIDE WHITE
37220 ANIMALIA AN17A-PT02 TRACK PANTS : ONE NATION BLACK
37221 ANIMALIA AN17A-PT02 TRACK PANTS : ONE NATION GRAY
37471 ANIMALIA AN17A-TE07L/S SKUNK YOU BLACK
37472 ANIMALIA AN17A-TE07L/S SKUNK YOU WHITE
37488 ANIMALIA AN17A-SH01 Arrogant Shirts #001 WANNABE BLK
37489 ANIMALIA AN17A-SH01 Arrogant Shirts #001 WANNABE WHT
37490 ANIMALIA AN17A-AC01 SNOOD #002 BLK
37491 ANIMALIA AN17A-AC01 SNOOD #002 GRAY
37492 ANIMALIA AN17A-SW04 ONE NATION BLK
37498 ANIMALIA AN17A-SW04 ONE NATION GRAY
37499 ANIMALIA AN17A-TE03 ROAR BLK
37500 ANIMALIA AN17A-TE03 ROAR WHT
37554 ANIMALIA OLD WEST L/S BLACK
37572 ANIMALIA AN17A-JK02 LEVEL7 JACKET BLK
37574 ANIMALIA AN17A-JK04 WATER RESISTANT JACKET BEIGE
37575 ANIMALIA AN17A-JK04 WATER RESISTANT JACKET BLACK
37760 ANIMALIA AN17A-CP03 BOONIE BERET#001 BLK
37761 ANIMALIA AN17A-CP03 BOONIE BERET#001 GRAY
37762 ANIMALIA AN17A-CP07 BEANIE #008 BLK
37763 ANIMALIA AN17A-CP07 BEANIE #008 NAVY
37764 ANIMALIA AN17A-CP07 BEANIE #008 GRAY
37765 ANIMALIA AN17A-AC15 PARACORD Bracelet BLK
37766 ANIMALIA AN17A-AC15 PARACORD Bracelet OLIVE
37767 ANIMALIA AN17A-CP02 BEANIE #009 BLK
37768 ANIMALIA AN17A-CP02 BEANIE #009 OLIVE
37769 ANIMALIA AN17A-CP02 BEANIE #009 GRAY
37770 ANIMALIA LIAAN17A-AC03 COTTON BELT 17AW BLK
37771 ANIMALIA LIAAN17A-AC03 COTTON BELT 17AW NAVY
37772 ANIMALIA LIAAN17A-AC03 COTTON BELT 17AW OLIVE
37843 ANIMALIA BOONIE BOMBER BLACK
37844 ANIMALIA JEANS BRONCO #006 Skinny Black
38569 ANIMALIA AN17A-SW01 RR LOGO BLACK
38570 ANIMALIA AN17A-SW01 RR LOGO GRAY