Skip to content

Instantly share code, notes, and snippets.

@greg606
Created December 3, 2010 15:57
Show Gist options
  • Save greg606/727130 to your computer and use it in GitHub Desktop.
Save greg606/727130 to your computer and use it in GitHub Desktop.
SELECT node.nid AS nid, field_data_field_adres.entity_id AS field_data_field_adres_entity_id, field_data_field_adres.etid AS field_data_field_adres_etid, field_data_field_adres.delta AS field_data_field_adres_delta, field_data_field_adres.language AS field_data_field_adres_language, field_data_field_adres.field_adres_value AS field_data_field_adres_field_adres_value, field_data_field_adres.field_adres_format AS field_data_field_adres_field_adres_format, node.vid AS node_vid, node.type AS node_type, field_data_field_telefon.entity_id AS field_data_field_telefon_entity_id, field_data_field_telefon.etid AS field_data_field_telefon_etid, field_data_field_telefon.delta AS field_data_field_telefon_delta, field_data_field_telefon.language AS field_data_field_telefon_language, field_data_field_telefon.field_telefon_value AS field_data_field_telefon_field_telefon_value, field_data_field_telefon.field_telefon_format AS field_data_field_telefon_field_telefon_format, node.created AS node_created, 'usterki:page_2' AS view_name
FROM
{node} node
LEFT JOIN {field_data_field_adres} field_data_field_adres ON node.nid = field_data_field_adres.entity_id AND (field_data_field_adres.etid = :views_join_condition_0 AND field_data_field_adres.deleted = :views_join_condition_1)
LEFT JOIN {field_data_field_telefon} field_data_field_telefon ON node.nid = field_data_field_telefon.entity_id AND (field_data_field_telefon.etid = :views_join_condition_2 AND field_data_field_telefon.deleted = :views_join_condition_3)
WHERE (( (node.type IN ('zgloszenie_usterki')) ))
LIMIT 10 OFFSET 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment