Anonymous

SELECT
	{node_revisions}.nid
	,{node_revisions}.title
	,LEFT({node_revisions}.body,100) teaser
	,{files}.filepath
	,{files}.filename
FROM
	{node_revisions} LEFT OUTER JOIN {image_attach}
		ON {node_revisions}.nid = {image_attach}.nid LEFT OUTER JOIN {files}
			ON {files}.nid = {image_attach}.iid INNER JOIN {news_places}
				ON {node_revisions}.nid = {news_places}.nid
WHERE
	{news_places}.region = 'HomeLeftNews'
AND
	(
		(
			(SELECT COUNT(nid) FROM {files} WHERE nid = {image_attach}.iid) > 1
			AND
			{files}.filename = 'thumbnail'
		)
		OR
		(
			{files}.filename IS NULL
			OR
			(SELECT COUNT(nid) FROM {files} WHERE nid = {image_attach}.iid) BETWEEN 0 AND 2
		)
	)
AND
	{news_places}.tid = '0'
ORDER BY
	{news_places}.sort ASC