Cacher is the code snippet organizer for pro developers

SELECT  webform_submitted_data.sid,
        MAX(IF(`webform_submitted_data`.`cid` = 1, data, NULL)) firstname,
        MAX(IF(`webform_submitted_data`.`cid` = 2, data, NULL)) lastname,
		MAX(IF(`webform_submitted_data`.`cid` = 3, data, NULL)) email,
		MAX(IF(`webform_submitted_data`.`cid` = 4, data, NULL)) zip,
		MAX(IF(`webform_submitted_data`.`cid` = 5, data, NULL)) rfid	
FROM webform_submitted_data
WHERE webform_submitted_data.nid = 1
GROUP BY webform_submitted_data.sid;