SELECT
concat("",P_A.LOC_NOME," ",
case P_A.PRN_STATO
when 'Attesa' then ' IN ATTESA'
when 'Avvenuta' then ' PARTITO'
when 'Sosta' then ' IN SOSTA'
end
),
concat("",DATE_FORMAT(P_A.PRN_ORA ,"%H:%i"),""," ",'Stallo ',
FROM P_A
where P_A.PRN_STALLO != 0
and P_A.PRN_ORA > subtime(now(),"00:15")
and P_A.PRN_ORA < addtime(now(),"00:30")
ORDER BY P_A.PRN_ORA ASC

Table Plugin