gistfile1.sql

SELECT node.nid AS nid, field_data_field_published_date.field_published_date_value AS field_data_field_published_date_field_published_date_value, 'node' AS field_data_field_article_headline_a_node_entity_type, 'node' AS field_data_field_article_hero_image_node_entity_type, 'node' AS field_data_field_article_author_reference_node_entity_type, 'node' AS field_data_field_published_date_node_entity_type, 'node' AS field_data_body_node_entity_type, 'node' AS field_data_field_article_tags_node_entity_type, 'g:detail_related_articles' AS view_name
FROM 
{node} node
INNER JOIN {taxonomy_index} taxonomy_index_value_0 ON node.nid = taxonomy_index_value_0.nid AND taxonomy_index_value_0.tid = '1'
LEFT JOIN {field_data_field_published_date} field_data_field_published_date ON node.nid = field_data_field_published_date.entity_id AND (field_data_field_published_date.entity_type = 'node' AND field_data_field_published_date.deleted = '0')
WHERE ((( (taxonomy_index_value_0.tid = '1') )AND (node.nid != '1' OR node.nid IS NULL) )AND(( (node.status = '1') AND (node.type IN  ('article')) )))
ORDER BY field_data_field_published_date_field_published_date_value DESC
LIMIT 3 OFFSET 0