Select all Journal Entries written by user 1

gistfile1.sql

SELECT *
FROM node node
LEFT JOIN users users_node 
ON node.uid = users_node.uid
LEFT JOIN field_data_body field_data_body 
ON node.nid = field_data_body.entity_id 
AND (field_data_body.entity_type = 'node' 
     AND field_data_body.deleted = '0')
LEFT JOIN field_data_field_image field_data_field_image 
ON node.nid = field_data_field_image.entity_id 
AND (field_data_field_image.entity_type = 'node' 
     AND field_data_field_image.deleted = '0')
LEFT JOIN field_data_field_course_reference field_data_field_course_reference 
ON node.nid = field_data_field_course_reference.entity_id 
AND (field_data_field_course_reference.entity_type = 'node' 
     AND field_data_field_course_reference.deleted = '0')
WHERE (node.type 
IN 'journal_entry' 
AND users_node.uid = '1')