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 11:35:48')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 125)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
69445 BRING ME THE HORIZON UNISEX T-SHIRT: GREEN NEX GEN
69443 BRING ME THE HORIZON UNISEX T-SHIRT: NEX GEN COVER
69444 BRING ME THE HORIZON UNISEX T-SHIRT: DISTRESSED NEX GEN
69446 BRING ME THE HORIZON UNISEX T-SHIRT: IMPRINT NEX GEN
67935 BRING ME THE HORIZON UNISEX T-SHIRT: SPRAY HEX
69354 BRING ME THE HORIZON UNISEX T-SHIRT: FLAMING HEX BLACK
68831 BRING ME THE HORIZON UNISEX T-SHIRT: BARBED WIRE (BACK PRINT)
45947 BRING ME THE HORIZON UMBRELLA (BURN OUT) GRAY
67940 BRING ME THE HORIZON UNISEX T-SHIRT: WARRIOR
70554 BRING ME THE HORIZON UNISEX T-SHIRT: WHY...?
69441 BRING ME THE HORIZON UNISEX T-SHIRT: LOST (BACK PRINT)
69442 BRING ME THE HORIZON UNISEX T-SHIRT: ALL HAIL (BACK PRINT)
43345 BRING ME THE HORIZON Sempiternal TEE
69346 BRING ME THE HORIZON UNISEX LONG SLEEVE T-SHIRT: SEMPITERNAL BLACK
61825 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: SEMPITERNAL
70552 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: NEX GEN COVER
70553 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: BUG
69358 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: PHSH COVER (SLEEVE PRINT)
70555 BRING ME THE HORIZON UNISEX ZIPPED HOODIE: BLUE CROW WINGS (BACK PRINT)
26134 BRING ME THE HORIZON Sickle Zip Hoodie
67936 BRING ME THE HORIZON UNISEX T-SHIRT: SYMBOLS (BACK PRINT)
69357 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: LOST
67934 BRING ME THE HORIZON UNISEX T-SHIRT: ZOMBIE HANDS
45950 BRING ME THE HORIZON WONDERFUL LIFE BLACK
50312 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) charcoal
35589 BRING ME THE HORIZON The H T-Shirts
35598 BRING ME THE HORIZON Alone & Depressed
67937 BRING ME THE HORIZON UNISEX T-SHIRT: ZOMBIE EYE (BACK PRINT)
45951 BRING ME THE HORIZON PLASMA TEE BLACK
67933 BRING ME THE HORIZON UNISEX T-SHIRT: ZOMBIE ARMY
43343 BRING ME THE HORIZON UMBRELLA TEE
59373 BRING ME THE HORIZON UNISEX T-SHIRT: LABYRINTH (BACK PRINT)
57233 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: LOVE (BACK PRINT)
36532 BRING ME THE HORIZON -Sempiternal- Black T-Shirt
7860 BRING ME THE HORIZON Womens Suicide Season GRN
35581 BRING ME THE HORIZON SHADOW MOSES
45657 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: AMO SYMBOLS
57234 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: HEX PHSH COVER
57235 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: THE END (ARM PRINTS)
59270 BRING ME THE HORIZON UNISEX TEE: LOVE IS ALL WE HAVE (BACK PRINT)
57236 BRING ME THE HORIZON UNISEX TEE: HEX PHSH COVER (BACK PRINT)
57239 BRING ME THE HORIZON UNISEX TEE: WIPE THE SYSTEM (BACK PRINT)
45659 BRING ME THE HORIZON AMO SYMBOLS TEE
57294 BRING ME THE HORIZON UNISEX TEE: PARASITE (BACK PRINT)
57270 BRING ME THE HORIZON UNISEX TEE: FLOWERS (BACK PRINT)
57801 BRING ME THE HORIZON Label Rip Yellow Amo T-shirt
57238 BRING ME THE HORIZON UNISEX TEE: THE END (BACK PRINT)
45949 BRING ME THE HORIZON HEXAGRAM AMO SMALL YELLOW
57237 BRING ME THE HORIZON UNISEX TEE: LOVE (BACK PRINT)
35590 BRING ME THE HORIZON COLOURS T-SHIRTS
35558 BRING ME THE HORIZON BANNER HOODIE
57269 BRING ME THE HORIZON UNISEX LONG SLEEVED TEE: PARANOID (BACK PRINT)
43359 BRING ME THE HORIZON UMBRELLA VARSITY JACKET
43351 BRING ME THE HORIZON ALIEN TEE
50311 BRING ME THE HORIZON CROOKED YOUNG (APPLIQUE MOTIFS)
50313 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) NAVY/RED
35566 BRING ME THE HORIZON CANYON T-Shirts
35578 BRING ME THE HORIZON GOAT T-SHIRTS
28720 BRING ME THE HORIZON THIS IS Beanie
36530 BRING ME THE HORIZON PAINTED T-Shirt