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 =592
)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-28 11:12:49')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
13897 DROP DEAD CLOTHING NEKO HAT
16215 Subciety REVERSIBLE HAT-Conductor- BLK/GRYCAMO
17275 ZEPHYREN (ゼファレン) BUCKET HAT -VISIONARY- - WHITE
17276 ZEPHYREN (ゼファレン) BUCKET HAT -VISIONARY- BLACK
17277 ZEPHYREN (ゼファレン) BUCKET HAT -VISIONARY- NAVY
17278 ZEPHYREN (ゼファレン) BUCKET HAT -VISIONARY- BURGUNDY
17279 ZEPHYREN (ゼファレン) BUCKET HAT -VISIONARY- CAMO I
17633 DEADHEARTZ EMBROIDERY BACKET HAT SAND CAMO
18251 RUDIE'S HEAD GEAR CONFUSE BUCKET HAT PURPLE
18252 RUDIE'S HEAD GEAR CONFUSE BUCKET HAT BLUE
18593 Subciety BUCKET HAT-GLORIOUS- - LEAF CAMO
18807 NineMicrophones BUCKET HAT -9MC ASSOCIATION- - WHT
21328 THRASHER BUCKET HAT THBHT-002
21337 THRASHER METRO HAT 15TH-H52 CAMO
21339 THRASHER METRO HAT 15TH-H52 BLK
21603 ROLLING CRADLE CATTLE MUTILATION HAT / Black-Blue
22040 RUDIE'S DRAWING BUCKET HAT NAVY
22041 RUDIE'S DRAWING BUCKET HAT WHITE
22164 FAMOUS STARS AND STRAPS NAMESAKE REVERSIBE BUCKET
22336 DEADHEARTZ D BACKET HAT WHT
22370 PUNK DRUNKERS 竹とん帽ハット BLUE
22745 Zephyren (ゼファレン) BUCKET HAT -SKULL HEAD- WHITE
22747 Zephyren (ゼファレン) BUCKET HAT -SKULL HEAD- BURGUNDY
23011 Subciety ALOHA BUCKET HAT BLACK
23012 Subciety ALOHA BUCKET HAT NAVY
23205 Subciety PILE HAT-SYMBOL- BLACK
23206 Subciety PILE HAT-SYMBOL- NAVY
23367 GoneR GoneR × ROOKiEZ is PUNK'D Bucket Hat - White
23368 GoneR GoneR × ROOKiEZ is PUNK'D Bucket Hat - Black
23374 DEADHEARTZ LOGO BACKET HAT / CAMO
23572 NineMicrophones BUCKET HAT-9MC Crew- - WHITE
23573 NineMicrophones BUCKET HAT-9MC Crew- - BLACK
23574 NineMicrophones BUCKET HAT-9MC Crew- DENIM
23578 NineMicrophones STRAW HAT - BLACK
23601 THRASHER 16TH-H03 BLK/WIN
23634 ICECREAM RUNNING DOG BUCKET HAT BLK
23635 ICECREAM RUNNING DOG BUCKET HAT WHT
23698 KILL BRAND FE CLASSIC BUCKET
23701 KILL BRAND 40s Bucket Hat
23849 BACK LIFT BUCKET HAT バケットハット総柄 BLUE
23853 BACK LIFT BUCKET HAT BLACK
24048 ANIMALIA AN16U-CP03 BUCKET HAT-Calligraphy NAVY
24049 ANIMALIA AN16U-CP03 BUCKET HAT-Calligraphy L.BLUE
24055 ANIMALIA AN16U-CP06 BOONIE Paper Hat #002 BLACK
24056 ANIMALIA AN16U-CP06 BOONIE Paper Hat #002 NATURAL
24175 RUDIE'S VICE BUCKET HAT WHITE
24176 RUDIE'S VICE BUCKET HAT CAMO
24335 KILL STAR CLOTHING (キルスター・クロージング) VELVET WITCH BRIM HAT
24345 ICECREAM FROZEN IC BUCKET HAT
24400 Hypocrite(ヒポクリット) The Hie Logo Backet Hat WHT
24401 Hypocrite(ヒポクリット) The Hie Logo Backet Hat BLK
24923 Zephyren (ゼファレン) BUCKET HAT -VISIONARY- CAMO II
24927 Zephyren (ゼファレン) BUCKET HAT -SPADE- BLACK
24929 Zephyren (ゼファレン) BUCKET HAT -SPADE- NAVY
24930 Zephyren (ゼファレン) BUCKET HAT -SPADE- CAMO I
24931 Zephyren (ゼファレン) BUCKET HAT -SPADE- CAMO II
24934 Zephyren (ゼファレン) WIDE BRIM PANAMA HAT MIX
25277 DOCAN! メロメロ Bucket Hat Black
25278 DOCAN! メロメロ Bucket Hat White
25279 DOCAN! メロメロ Bucket Hat Denim
25889 Subciety WOOL BUCKET HAT-SYMBOL- BLACK
25890 Subciety WOOL BUCKET HAT-SYMBOL- GRAY
25891 Subciety WOOL BUCKET HAT-SYMBOL- KHAKI
25892 Subciety CORDUROY BUCKET HAT-NOVEL- WHITE
25893 Subciety CORDUROY BUCKET HAT-NOVEL- BLACK
25894 Subciety CORDUROY BUCKET HAT-NOVEL- SAX
25900 Subciety BOWLAR HAT BLACK
25901 Subciety BOWLAR HAT GRAY
25902 Subciety BOWLAR HAT BURGUNDY
25903 Subciety FLAT FELT HAT BLACK
25904 Subciety FLAT FELT HAT BEIGE
26108 NineMicrophones (ナインマイクロフォンズ) BUCKET HAT-9MC Crew- CAMOUFLAGE
26117 NineMicrophones FELT HAT-Comrade- BLK
26118 NineMicrophones FELT HAT-Comrade- BRW
26284 Zephyren (ゼファレン) BANDANA CLOTH BUCKET HAT -VISIONARY- STAR DOT BLACK
26285 Zephyren (ゼファレン) BANDANA CLOTH BUCKET HAT -VISIONARY- STAR DOT WHITE
26333 ROLLING CRADLE RC RESORT HAT / White
26334 ROLLING CRADLE RC RESORT HAT / Black
26343 ROLLING CRADLE PROUD 2 RC BELL HAT / Indigo-Yellow
26344 ROLLING CRADLE PROUD 2 RC BELL HAT / Red-Pink
26396 LILWHITE. (リルホワイト) CROSS BUCKET WHT
26397 LILWHITE. (リルホワイト) WHITE BUCKET BLK
26398 LILWHITE. (リルホワイト) WHITE BUCKET WHT
26475 DEADHEARTZ "Intarsect" Backet Hat / WHITE
27272 Zephyren (ゼファレン) CHOSEN MATERIAL BUCKET HAT -VISIONARY- BLACK PAISLEY
27274 Zephyren (ゼファレン) CHOSEN MATERIAL BUCKET HAT -VISIONARY- BLACK NATIVE
27290 Zephyren (ゼファレン) WIDE BRIM FELT HAT BLACK
27393 THRASHER 16TH-H10 BUCKETHAT BLK
27571 ICECREAM ISDC BUCKET HAT 16SUMMER
27826 SABBAT13 WIDE BRIM BUCKET HAT
27984 RIP DESIGN WORXX Tie-Dyeバケットハット
28688 RUDIE'S HEAD GEAR DRAWING BUCKETHAT WHITE
28689 RUDIE'S HEAD GEAR DRAWING BUCKETHAT BLACK
28799 PUNK DRUNKERS ヘビHAT BLACK
28800 PUNK DRUNKERS ヘビHAT LT.BLUE
28893 ROLLING CRADLE BELL HAT / Green
28894 ROLLING CRADLE BELL HAT / Black
29469 NineMicrophones (ナインマイクロフォンズ) BANDANNA BRIM HAT BLACK
29470 NineMicrophones (ナインマイクロフォンズ) BANDANNA BRIM HAT CAMEL
29719 RIP DESIGN WORXX 666バケットハット
30094 MUSIC SAVED MY LIFE (MSML) LONG BRIM HAT CHARCOAL GRAY
30095 MUSIC SAVED MY LIFE (MSML) LONG BRIM HAT BLACK
30128 BAND-MAID バケットハット(黒)
30129 BAND-MAID バケットハット(紺)
30130 BAND-MAID バケットハット(白)
30131 BAND-MAID バケットハット(デニム)
32743 Subciety (サブサエティ) BRAID HAT BLACK
32744 Subciety (サブサエティ) BRAID HAT NATURAL
33380 Zephyren (ゼファレン) PANAMA HAT BLACK
33382 Zephyren (ゼファレン) WIDEBRIM PANAMA HAT WHITE
33383 Zephyren (ゼファレン) WIDEBRIM PANAMA HAT BLACK
34006 RIP DESIGN WORXX ripdwロゴベレー帽
34414 VIRGO HAPPINESS HAT WHITE
34415 VIRGO HAPPINESS HAT BLACK
34746 Subciety (サブサエティ) TROOPER HAT BLACK
34747 Subciety (サブサエティ) TROOPER HAT ORANGE
34748 Subciety (サブサエティ) TROOPER HAT OLIVE-DRAB
34761 Subciety (サブサエティ) PAISELY RIBBON HAT BLACK
35060 SILLENT FROM ME CRYPTIC -Beret- BLK/BLK
35061 SILLENT FROM ME CRYPTIC -Beret- BLK/WHT