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_sessions.web_order ASC, pp06_sessions.start ASC, pp06_speakers.order_number ASC