drupal_sql

                                          SELECT node.nid,
								node.title as title,
								portfolio_node.field_student_nid AS ind_nid,
								student_node.field_firstname_value AS firstname,
								student_node.field_lastname_value AS lastname,
								student_node.field_image_2_fid AS ind_fid,
								student_files.filepath AS ind_filepath,
								portfolio_node.field_image_0_fid AS image_fid,
								portfolio_files.filepath AS image_filepath,
								video_files.filepath AS video_thumb_filepath,
								portfolio_node.field_image_0_title AS image_title,
								portfolio_node.field_image_0_alt AS image_alt,
								portfolio_node.field_medium_value AS image_medium,
								portfolio_node.field_completed_value AS image_date,
								portfolio_node.field_video_link_value AS video_link,
								node_revisions.body AS image_description
								$term_select
					 FROM {node} node
					 JOIN {node_revisions} node_revisions ON node_revisions.vid = node.vid
					 JOIN {content_type_portfolio} portfolio_node ON node.vid = portfolio_node.vid
					 JOIN {content_type_individual} student_node ON student_node.nid = portfolio_node.field_student_nid
					 $term_join
					 $image_join_type {files} portfolio_files ON portfolio_files.fid = portfolio_node.field_image_0_fid
					LEFT JOIN {files} video_files ON video_files.fid = portfolio_node.field_image_thumbnail_fid
					LEFT JOIN {files} student_files ON student_files.fid = student_node.field_image_2_fid
				  WHERE (node.status = '1')
						AND (node.type IN ('portfolio'))
					AND (portfolio_node.field_image_0_fid > 0 OR portfolio_node.field_image_thumbnail_fid > 0)
						$ind_filter
			 GROUP BY node.nid
			$term_filter 
			 ORDER BY $randomize student_node.field_lastname_value, student_node.field_firstname_value
					$limit_txt";