SELECT pp06_speakers.*, pp06_sessions.* FROM pp06_speakers LEFT JOIN pp06_sessions ON pp06_speakers.session_code = pp06_sessions.session_code WHERE pp06_speakers.statement_delivered = 1 AND pp06_speakers.declined = 0 AND pp06_speakers.session_code <> 'SB' ORDER BY  pp06_speakers.country_entity ASC<p>