SELECT      *
FROM        project_listings
LEFT JOIN   project_bids
ON          project_listings.id=project_bids.project_id
WHERE       on_step='completed'
AND         work_type='1'
AND         project_bids.project_id IS NULL