string(2426) "WITH picked AS (
SELECT product_class_id, MAX(schedule_num) AS mx
FROM dtb_products_schedule
WHERE schedule_id = 5
AND ? BETWEEN start_date AND finish_date
AND sale_target IN (?)
GROUP BY product_class_id
),
sched_price AS (
SELECT s.product_class_id, s.price
FROM dtb_products_schedule s
JOIN picked p
ON p.product_class_id = s.product_class_id
AND p.mx = s.schedule_num
)SELECT T3.* FROM ( SELECT
DP.*,
dtb_products_class.classcategory_id1,
SUM(dtb_products_class.fav_count) AS fav_count,
MAX(stock) as max_stock,
MIN(stock) as min_stock,
MAX(CASE
WHEN IFNULL(stock, 0) > 0 THEN 1
ELSE 0
END) AS has_stock,
MAX(price01) as max_price01,
MIN(price01) as min_price01,
MAX(price02) as max_price02,
MIN(price02) as min_price02,
MAX(COALESCE(sp.price, dtb_products_class.price02)) AS max_fix_price,
MIN(COALESCE(sp.price, dtb_products_class.price02)) AS min_fix_price,
MAX(item_width) as item_width,
MAX(item_height) as item_height,
MAX(item_depth) as item_depth FROM
( SELECT
dtb_products.product_id,
dtb_products.master_id,
dtb_products.name,
dtb_products.sex_id,
dtb_products.sort_rank,
dtb_products.maker_id,
dtb_products.main_list_image,
dtb_products.status,
dtb_products.weight,
dtb_products.create_date
FROM dtb_products WHERE del_flg = 0 AND dtb_products.product_id IN (?,?,?,?,?,?,?,?) AND dtb_products.status IN (?)) as DP
INNER JOIN dtb_products_class ON dtb_products_class.product_id = DP.product_id
LEFT JOIN sched_price sp ON sp.product_class_id = dtb_products_class.product_class_id
WHERE
dtb_products_class.del_flg = 0 AND product_class_status = 1 GROUP BY dtb_products_class.product_id ORDER BY FIELD(DP.product_id,825348,824938,825077,824673,825081,824677,824931,824935) LIMIT 48) as T3"
array(11) {
[0]=>
string(16) "2025-09-20 17:12"
[1]=>
string(1) "1"
[2]=>
string(6) "825348"
[3]=>
string(6) "824938"
[4]=>
string(6) "825077"
[5]=>
string(6) "824673"
[6]=>
string(6) "825081"
[7]=>
string(6) "824677"
[8]=>
string(6) "824931"
[9]=>
string(6) "824935"
[10]=>
string(1) "1"
}
【公式】アンティーク家具ラフジュ工房（ラフジュコウボウ）商品詳細ページ/ アンティーク雑貨 レトロ雑貨 大正期 ピンク縁 氷コップ(和ガラス、吹きガラス)(R-040122)
string(2363) "WITH picked AS (
SELECT product_class_id, MAX(schedule_num) AS mx
FROM dtb_products_schedule
WHERE schedule_id = 5
AND ? BETWEEN start_date AND finish_date
AND sale_target IN (?)
GROUP BY product_class_id
),
sched_price AS (
SELECT s.product_class_id, s.price
FROM dtb_products_schedule s
JOIN picked p
ON p.product_class_id = s.product_class_id
AND p.mx = s.schedule_num
)SELECT T3.* FROM ( SELECT
DP.*,
dtb_products_class.classcategory_id1,
SUM(dtb_products_class.fav_count) AS fav_count,
MAX(stock) as max_stock,
MIN(stock) as min_stock,
MAX(CASE
WHEN IFNULL(stock, 0) > 0 THEN 1
ELSE 0
END) AS has_stock,
MAX(price01) as max_price01,
MIN(price01) as min_price01,
MAX(price02) as max_price02,
MIN(price02) as min_price02,
MAX(COALESCE(sp.price, dtb_products_class.price02)) AS max_fix_price,
MIN(COALESCE(sp.price, dtb_products_class.price02)) AS min_fix_price,
MAX(item_width) as item_width,
MAX(item_height) as item_height,
MAX(item_depth) as item_depth FROM
( SELECT
dtb_products.product_id,
dtb_products.master_id,
dtb_products.name,
dtb_products.sex_id,
dtb_products.sort_rank,
dtb_products.maker_id,
dtb_products.main_list_image,
dtb_products.status,
dtb_products.weight,
dtb_products.create_date
FROM dtb_products WHERE del_flg = 0 AND dtb_products.product_id IN (?) AND dtb_products.status IN (?)) as DP
INNER JOIN dtb_products_class ON dtb_products_class.product_id = DP.product_id
LEFT JOIN sched_price sp ON sp.product_class_id = dtb_products_class.product_class_id
WHERE
dtb_products_class.del_flg = 0 AND product_class_status = 1 GROUP BY dtb_products_class.product_id ORDER BY FIELD(DP.product_id,817854) LIMIT 48) as T3"
array(4) {
[0]=>
string(16) "2025-09-20 17:12"
[1]=>
string(1) "1"
[2]=>
string(6) "817854"
[3]=>
string(1) "1"
}
