17 lines
534 B
MySQL
17 lines
534 B
MySQL
|
-- 检查文案ID为1的详细信息
|
||
|
|
SELECT
|
||
|
|
a.id AS article_id,
|
||
|
|
a.title,
|
||
|
|
a.status,
|
||
|
|
a.review_comment, -- 这里会显示失败原因
|
||
|
|
a.created_user_id,
|
||
|
|
a.publish_user_id,
|
||
|
|
u.phone,
|
||
|
|
u.is_bound_xhs,
|
||
|
|
au.xhs_cookie IS NOT NULL AS has_cookie,
|
||
|
|
LENGTH(au.xhs_cookie) AS cookie_length
|
||
|
|
FROM ai_articles a
|
||
|
|
LEFT JOIN ai_users u ON u.id = COALESCE(a.publish_user_id, a.created_user_id)
|
||
|
|
LEFT JOIN ai_authors au ON au.phone = u.phone AND au.enterprise_id = u.enterprise_id AND au.channel = 1
|
||
|
|
WHERE a.id = 1;
|