How to alter incorrect Join type generated by Views?
Complete operator error.  For the benefit of anyone else who encounters this error check your fieldname.  In my case I had misspelt the fieldname ['field_data_field_listing_type'] so it was generating a new incompleted entry in the table_queue array.