PolarDBÓиösqlÄÜ°ïæ²éÏÂÂ𠣿

PolarDBÓиösqlÄÜ°ïæ²éÏÂÂð Õâ¸ösqlÓÃStatement Outline¹Ì¶¨ÁËÖ´Ðмƻ® Õý³£Ó¦¸Ã×ßÖ¸¶¨µÄË÷ÒýɨÃè2k¶àÐÐÊý¾Ý ¸Õ²Å´¥·¢ÁËÁ½´Î²éѯɨÃèÁË20¶àwÊý¾Ý 40¶àÃë²Å²éѯ³öÀ´

SELECT
sdt.produce_id,
sdt.customer_id,
sel.company_name AS company_name_m,
sel.prefix_domain_name,
sdt.products_id,
sdt.products_url_name,
SUBSTR(sdt.category_id, 1, 3) AS category_id_lv1,
sdt.produce_cas_no AS cas_no,
sdt.produce_name,
sdt.produce_url_name,
sdt.goods_picture_s,
sdt.goods_picture_m AS goods_picture,
sdt.goods_picture_b,
sdt.complete_flag,
sdt.hot_flag,
sdt.main_flag,
sdt.grade_name,
sdt.content,
sdt.package_name,
sdt.n_price_type,
sdt.n_price_trade_term_type,
sdt.n_price_trade_term_text,
sdt.n_price,
sdt.n_price_unit,
sdt.n_price_currency,
sdt.n_price_currency_symbol,
CASE
WHEN CEILING(IFNULL(sdt.n_min_price, 0)) = 0 THEN '0'
WHEN sdt.n_price_end_date < CURRENT_DATE() THEN '0'
ELSE '1'
END AS n_pending_flag,
sdt.activity_id,
sdt.activity_type,
sdt.a_price_trade_term_type,
sdt.a_price_trade_term_text,
sdt.a_price,
sdt.a_price_unit,
sdt.a_price_currency,
sdt.a_price_currency_symbol
FROM
t_e_all_produce_v1 sdt
INNER JOIN t_e_all_seller_v1 sel ON sdt.customer_id = sel.customer_id
WHERE
sdt.delflag = '0'
AND sel.delflag = '0'
AND sdt.customer_id = 'us20220607140012825'
AND sdt.products_id = 'pd2005121001'
AND sdt.produce_id != 'pr22121432843'
AND sdt.complete_flag = '1'
ORDER BY
sdt.produce_update_date DESC
limit 6