Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ((SELECT fnum,DATE_FORMAT(sip_Date,'%a %b %e, %H:%i:%s') AS d FROM request_line WHERE sip_callid = '4E611C85-E7A11DF-95C2A3C8-FB0ED04D') UNION ALL (SELECT fnum,DATE_FORMAT(sip_Date,'%a %b %e, %H:%i:%s') AS d FROM status_line AS s INNER JOIN statuscodes AS ss ON s.statuscode = ss.statuscode WHERE sip_callid = '4E611C85-E7A11DF-95C2A3C8-FB0ED04D') ORDER BY d,fnum ASC LIMIT 1) UNION ALL ((SELECT fnum,DATE_FORMAT(sip_Date,'%a %b %e, %H:%i:%s') AS d FROM request_line WHERE sip_callid = '4E611C85-E7A11DF-95C2A3C8-FB0ED04D') UNION ALL (SELECT fnum,DATE_FORMAT(sip_Date,'%a %b %e, %H:%i:%s') AS d FROM status_line AS s INNER JOIN statuscodes AS ss ON s.statuscode = ss.statuscode WHERE sip_callid = '4E611C85-E7A11DF-95C2A3C8-FB0ED04D') ORDER BY d,fnum DESC LIMIT 1);
- I get:
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNION ALL (SELECT fnum,DATE_FORMAT(sip_Date,'%a %b %e, %H:%i:%s') AS d FROM stat' at line 1
Add Comment
Please, Sign In to add comment