SELECT node.nid AS nid, feeds_log.log_time AS feeds_log_log_time, field_data_field_hotness.field_hotness_radioactivity_energy AS field_data_field_hotness_field_hotness_radioactivity_energy, 'node' AS field_data_field_location_node_entity_type, 'node' AS field_data_field_video_node_entity_type, 'node' AS field_data_field_add_caption__node_entity_type
FROM 
{node} node
LEFT JOIN {users} users_node ON node.uid = users_node.uid
LEFT JOIN (SELECT td.*, tn.nid AS nid
FROM 
{taxonomy_term_data} td
LEFT JOIN {taxonomy_vocabulary} tv ON td.vid = tv.vid
LEFT JOIN {taxonomy_index} tn ON tn.tid = td.tid
WHERE  (tv.machine_name IN  ('world_test')) ) taxonomy_term_data_node ON node.nid = taxonomy_term_data_node.nid
INNER JOIN {node} node_taxonomy_term_data ON (SELECT nodeINNER.nid AS nidINNER
FROM 
{node} nodeINNER
LEFT JOIN {users} users_nodeINNER ON nodeINNER.uid = users_nodeINNER.uid
LEFT JOIN (SELECT td.*, tn.nid AS nid
FROM 
{taxonomy_term_data} td
LEFT JOIN {taxonomy_vocabulary} tv ON td.vid = tv.vid
LEFT JOIN {taxonomy_index} tn ON tn.tid = td.tid
WHERE  (tv.machine_name IN  ('world_test')) ) taxonomy_term_data_nodeINNER ON nodeINNER.nid = taxonomy_term_data_nodeINNER.nid
LEFT JOIN {field_data_field_hotness} field_data_field_hotnessINNER ON nodeINNER.nid = field_data_field_hotnessINNER.entity_id AND (field_data_field_hotnessINNER.entity_type = 'node' AND field_data_field_hotnessINNER.deleted = '0')
WHERE (( (INNER.tid = taxonomy_term_data.tid ) )AND(( (nodeINNER.status = '1') )))
ORDER BY field_data_field_hotness_field_hotness_radioactivity_energyINNER. ASC
LIMIT 1 OFFSET 0) = node_taxonomy_term_data.nid
LEFT JOIN {feeds_log} feeds_log ON node.nid = feeds_log.feed_nid
LEFT JOIN {field_data_field_hotness} field_data_field_hotness ON node.nid = field_data_field_hotness.entity_id AND (field_data_field_hotness.entity_type = 'node' AND field_data_field_hotness.deleted = '0')
WHERE (( (node.status = '1') ))
ORDER BY field_data_field_hotness_field_hotness_radioactivity_energy ASC
LIMIT 8 OFFSET 0