I have actually already setup 3 temp tables to simplify the query alot. "on field_data_field_xx.revision_id=node.vid" is what drupal uses like a primary key between the different tables. Each field has the revision_id and it linked back to the node.vid (content version id) If you...