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-03-29 08:42:05')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 85)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 480, 120
21981 ROLLING CRADLE MP-LOPS SWALLOW TAIL SHIRT / Olive
21982 ROLLING CRADLE MP-LOPS SWALLOW TAIL SHIRT / Blue
22006 ROLLING CRADLE Sotrm trooper Sweat WHT
22007 ROLLING CRADLE Sotrm trooper Sweat BLK
22008 ROLLING CRADLE Troopers Hoodie WHT
22009 ROLLING CRADLE Troopers Hoodie BLK
22010 ROLLING CRADLE Storm trooper T-shirt WHT
22011 ROLLING CRADLE Storm trooper T-shirt BLK
22012 ROLLING CRADLE Trooper T-shirt WHT
22013 ROLLING CRADLE Trooper T-shirt BLK
22014 ROLLING CRADLE Darth Vader Sweat / Black
22015 ROLLING CRADLE Darth Vader T-shirt / Black
22034 ROLLING CRADLE RC SOCKS 3PACK / A-set
22035 ROLLING CRADLE RC SOCKS 3PACK / B-set
22036 ROLLING CRADLE RC SOCKS 3PACK / C-set
22151 ROLLING CRADLE THUNDER GATE 2nd type / Indigo(W)
22191 ROLLING CRADLE CYCLOPS SHOUT MAG&DRIPPER SET / WHT
22192 ROLLING CRADLE CYCLOPS SHOUT MAG&DRIPPER SET / BLK
22316 ROLLING CRADLE THUNDER GATE DENIM 3rd type IndigoW
22774 ROLLING CRADLE SHOCKING SMILE COACH JKT / White
22775 ROLLING CRADLE SHOCKING SMILE COACH JKT / Red
22776 ROLLING CRADLE SHOCKING SMILE COACH JKT / Green
22777 ROLLING CRADLE SHOCKING SMILE COACH JKT / Blue
22778 ROLLING CRADLE SHOCKING SMILE COACH JKT / Black
22779 ROLLING CRADLE CYCLOPS SHOUT SWEAT / Gray
22780 ROLLING CRADLE CYCLOPS SHOUT SWEAT / Burgundy
22781 ROLLING CRADLE CYCLOPS SHOUT SWEAT / Blue
22782 ROLLING CRADLE AIN’T 2 PROUD SWEAT / Oatmeal
22783 ROLLING CRADLE AIN’T 2 PROUD SWEAT / Red
22784 ROLLING CRADLE AIN’T 2 PROUD SWEAT / Black
22847 ROLLING CRADLE REVERSIBLE GARDEN HOODIE / White
22848 ROLLING CRADLE REVERSIBLE GARDEN HOODIE / Navy
22849 ROLLING CRADLE UNREASONABLE MONSTER SWEAT / White
22850 ROLLING CRADLE UNREASONABLE MONSTER SWEAT / Black
22951 ROLLING CRADLE BOX FOAM LOGO HOODIE / Black
22952 ROLLING CRADLE BOX FOAM LOGO HOODIE / Blue
22953 ROLLING CRADLE BOX BOX FOAM LOGO HOODIE / Red
22954 ROLLING CRADLE BOX FOAM LOGO HOODIE / White
22955 ROLLING CRADLE RAKURAI BIG SHIRT / White-Navy
22956 ROLLING CRADLE RAKURAI BIG SHIRT / Navy-Red
23397 ROLLING CRADLE 16BIT CROSS-KEY KNIT / Black
23398 ROLLING CRADLE 8BIT PROTECTION SHIRT / White
23399 ROLLING CRADLE 16BIT YXBA CARDIGAN / Black
23400 ROLLING CRADLE 16BIT CROSS-KEY KNIT / Black
23401 ROLLING CRADLE CYCLOPS SHOUT SWEAT / Black
23614 ROLLING CRADLE SHOCKING SMILE OX SHIRT / White-Red
23615 ROLLING CRADLE SHOCKING SMILE OX SHIRT / White-Black
23616 ROLLING CRADLE RC THUNDER OX SHIRT / White-Red
23617 ROLLING CRADLE RC THUNDER OX SHIRT / White-Black
23618 ROLLING CRADLE THUNDER GATE WIDE DENIM / Indigo
23737 ROLLING CRADLE FREAK OUT LONG Tee / White
23738 ROLLING CRADLE FREAK OUT LONG Tee / Gray
23739 ROLLING CRADLE FREAK OUT LONG Tee / Red
23740 ROLLING CRADLE FREAK OUT LONG Tee / Black
23886 ROLLING CRADLE FLUFFY HALF HOODIE / Gray
23887 ROLLING CRADLE FLUFFY HALF HOODIE / Red
23889 ROLLING CRADLE FLUFFY HALF HOODIE / Navy
23890 ROLLING CRADLE ZOO SHORTS / Leopard
23892 ROLLING CRADLE ZOO SHORTS / Dalmatian
23895 ROLLING CRADLE SHOUT & SHOCKING SMILE VENLY CASE / Orange
23896 ROLLING CRADLE SHOUT & SHOCKING SMILE VENLY CASE / Black
24201 ROLLING CRADLE MP-LOPS RAGLAN / Red
24202 ROLLING CRADLE MP-LOPS RAGLAN / Navy
24203 ROLLING CRADLE MP-LOPS RAGLAN / Black
24204 ROLLING CRADLE ROLLCRDL BIG Tee / White
24205 ROLLING CRADLE ROLLCRDL BIG Tee / Red
24206 ROLLING CRADLE ROLLCRDL BIG Tee / Charcoal
24207 ROLLING CRADLE SHOUT & SHOCKING SMILE LARGE BUCKET BAG / Orange
24208 ROLLING CRADLE SHOUT & SHOCKING SMILE LARGE BUCKET BAG / Black
24209 ROLLING CRADLE SHOUT & SHOCKING SMILE LARGE BUCKET BAG / Blue
24210 ROLLING CRADLE SHOUT & SHOCKING SMILE LARGE BUCKET BAG / Black-Yellow
24211 ROLLING CRADLE SHOUT & SHOCKING SMILE TOY POUCH / Orange
24212 ROLLING CRADLE SHOUT & SHOCKING SMILE TOY POUCH / Black
24224 ROLLING CRADLE CYCLOPS SHOUT KEYHOLDER BLK
24225 ROLLING CRADLE CYCLOPS SHOUT KEYHOLDER BLUE
24226 ROLLING CRADLE CYCLOPS SHOUT KEYHOLDER GRN
24227 ROLLING CRADLE CYCLOPS SHOUT KEYHOLDER RED
24269 ROLLING CRADLE FUCKshima’s OVERALL / Indigo
24270 ROLLING CRADLE FUCKshima’s OVERALL / Hickory
24590 ROLLING CRADLE VAGABOND CYCLOPS Tee / White
24591 ROLLING CRADLE VAGABOND CYCLOPS Tee / Gray
24592 ROLLING CRADLE VAGABOND CYCLOPS Tee / Black
24593 ROLLING CRADLE SD ROLICLE Tee / White
24594 ROLLING CRADLE SD ROLICLE Tee / Red
24595 ROLLING CRADLE SD ROLICLE Tee / Pruple
24596 ROLLING CRADLE SD ROLICLE Tee / Blue
24597 ROLLING CRADLE SD ROLICLE Tee / Black
24598 ROLLING CRADLE BIG POCKET MINI CAMO SHORTS / Gray
24599 ROLLING CRADLE BIG POCKET MINI CAMO SHORTS / Beige
24600 ROLLING CRADLE RC LOGO NEW ERA CAP -CLASSIC- / Navy
24601 ROLLING CRADLE RC LOGO NEW ERA CAP -CLASSIC- / Blue-Red
24885 ROLLING CRADLE RCxTHRASHER -Go! Go! Go!- / White
24886 ROLLING CRADLE RCxTHRASHER -Go! Go! Go!- / Black
24887 ROLLING CRADLE RCxTHRASHER -PUSH ON FACE!- / White
24888 ROLLING CRADLE RCxTHRASHER -PUSH ON FACE!- / Black
24889 ROLLING CRADLE GOOD MORNING NASTY / White
24890 ROLLING CRADLE GOOD MORNING NASTY / Green
24891 ROLLING CRADLE GOOD MORNING NASTY / Black
24894 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Clear-White
24896 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Clear-Black
24897 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Black
25044 ROLLING CRADLE CYCLOPS SHOUT-RC BIT WORLD- / White
25045 ROLLING CRADLE CYCLOPS SHOUT-RC BIT WORLD- / Black
25046 ROLLING CRADLE CYCLOPS SHOUT-BURGER- / Black
25047 ROLLING CRADLE CYCLOPS SHOUT-BURGER- / White
25048 ROLLING CRADLE WAIKIKI SHORTS / Blue
25049 ROLLING CRADLE WAIKIKI SHORTS / Tropical
25050 ROLLING CRADLE 6090 GLASSES SERIES -FOOL- / Blue
25051 ROLLING CRADLE 6090 GLASSES SERIES -FOOL- / Green
25052 ROLLING CRADLE 6090 GLASSES SERIES -FOOL- / Pink
25053 ROLLING CRADLE 6090 GLASSES SERIES -FOOL- / Yellow
25497 ROLLING CRADLE OVER GROW SHIRT / Green
25498 ROLLING CRADLE OVER GROW SHIRT / Black
25499 ROLLING CRADLE OVER GROW SHORTS / Green
25500 ROLLING CRADLE OVER GROW SHORTS / Blue
25501 ROLLING CRADLE OVER GROW SHORTS / Black
25502 ROLLING CRADLE RC OFFICIAL T / Red-Blue
25503 ROLLING CRADLE RC OFFICIAL T / Blue-Red
25504 ROLLING CRADLE WAIKIKI BASE BALL-SHIRT / Blue
25505 ROLLING CRADLE WAIKIKI BASE BALL-SHIRT / Tropical