select    l.*
from      project_listings l
left join ( select  project_id
            from    project_bids
            where   user_id = ?
          ) bids
on        l.id = bids.project_id
where     bids.project_id is null
and       l.on_step = 'completed'
and       l.work_type = '1'