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-04-28 17:20:59')
AND pc.classcategory_id1 IN( 12,44)
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 360, 120
21301 ROLLING CRADLE STONED SWEAT / Black
21302 ROLLING CRADLE STONED SWEAT / White
21418 ROLLING CRADLE CATTLE MUTILATION SHORTS /Black GRN
21419 ROLLING CRADLE CATTLE MUTILATION SHORTS /Black-BLU
21420 ROLLING CRADLE MP-LOPS COACH JKT / Black
21421 ROLLING CRADLE MP-LOPS COACH JKT / Navy
21422 ROLLING CRADLE MP-LOPS COACH JKT / Green
21520 ROLLING CRADLE RAKURAI NEL / Green
21521 ROLLING CRADLE RAKURAI NEL / Blue
21522 ROLLING CRADLE RC×Mark Gonzales ANGEL HOODIE / GRY
21523 ROLLING CRADLE RC×Mark Gonzales ANGEL HOODIE / BLK
21524 ROLLING CRADLE RC×Mark Gonzales SKATE HOODIE / WHT
21525 ROLLING CRADLE RC×Mark Gonzales SKATE HOODIE / GRY
21526 ROLLING CRADLE RC×Mark Gonzales SKATE HOODIE / BLK
21527 ROLLING CRADLE RC×Mark Gonzales CLOUD HOODIE / WHT
21528 ROLLING CRADLE RC×Mark Gonzales CLOUD HOODIE / GRY
21529 ROLLING CRADLE RC×Mark Gonzales CLOUD HOODIE / BLK
21729 ROLLING CRADLE OVERLOUD POCKET SHIRT / White
21730 ROLLING CRADLE OVERLOUD POCKET SHIRT / Turquoise
21731 ROLLING CRADLE OVERLOUD POCKET SHIRT / Black
21732 ROLLING CRADLE WAVELET SHIRT / White
21733 ROLLING CRADLE WAVELET SHIRT / Iceblue
21734 ROLLING CRADLE WAVELET SHIRT / Black
21866 ROLLING CRADLE CYCLOPS SHOUT KNIT / Blue
21867 ROLLING CRADLE CYCLOPS SHOUT KNIT / Navy
21868 ROLLING CRADLE THUNDER GATE DENIM 1st type /Indigo
21894 ROLLING CRADLE MP-LOPS N3B JKT / Camo
21895 ROLLING CRADLE RAKURAI LONG NEL / Blue
21896 ROLLING CRADLE RAKURAI LONG NEL / Red
21897 ROLLING CRADLE SUKA-JERSEY:TIGER / Red
21980 ROLLING CRADLE SHOUT STADIUM JUMPER / Black
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
22151 ROLLING CRADLE THUNDER GATE 2nd type / Indigo(W)
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
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
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
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
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
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