SELECT A0, A1, A2, A3, ''排名'', A4, ''排名1'', A5, ''排名2'' FROM {0} WHERE bbh = {1} LIMIT 1 UNION SELECT * from ( SELECT A0, A1, A2, A3, A3R, A4, A4R, A5, A5R FROM ( SELECT * FROM {0} WHERE bbh = {1} AND A0 = {2} AND A6 not like ''%....%'' ) a00 LEFT JOIN ( SELECT id, @rank3 := @rank3 + 1 AS base_rank3,
@last_rank3 :=
CASE
WHEN @last_score3 = u.A3 THEN
@last_rank3
WHEN @last_score3 := u.A3 THEN
@rank3
WHEN @last_score3 = ''0'' THEN
@rank3
END AS A3R
FROM
( SELECT @rank3 := 0, @last_score3 := NULL, @last_rank3 := 0 ) r , {0} u WHERE bbh = {1} AND A0 = {2} AND A6 not like ''%....%'' ORDER BY A3 + 0 DESC ) a0 ON a00.id = a0.id LEFT JOIN ( SELECT id, @rank4 := @rank4 + 1 AS base_rank4,
@last_rank4 :=
CASE
WHEN @last_score4 = u.A4 THEN
@last_rank4
WHEN @last_score4 := u.A4 THEN
@rank4
WHEN @last_score4 = ''0'' THEN
@rank4
END AS A4R
FROM
( SELECT @rank4 := 0, @last_score4 := NULL, @last_rank4 := 0 ) r , {0} u WHERE bbh = {1} AND A0 = {2} AND A6 not like ''%....%'' ORDER BY A4 + 0 DESC ) a1 ON a0.id = a1.id LEFT JOIN ( SELECT id, @rank5 := @rank5 + 1 AS base_rank5,
@last_rank5 :=
CASE
WHEN @last_score5 = u.A5 THEN
@last_rank5
WHEN @last_score5 := u.A5 THEN
@rank5
WHEN @last_score5 = ''0'' THEN
@rank5
END AS A5R
FROM
( SELECT @rank5 := 0, @last_score5 := NULL, @last_rank5 := 0 ) r , {0} u WHERE bbh = {1} AND A0 = {2} AND A6 not like ''%....%'' ORDER BY A5 + 0 DESC ) a2 ON a1.id = a2.id ORDER BY A2 LIMIT 0,13 )a
String format = MessageFormat.format(sql, "Z_20190610102908864", "'郑州测试第二版'", "'郑州新闻广播FM98.8'");