SELECT 
					c.id, c.parent_id, c.alias, c.headline, c.absoluteurl 
				FROM 
					cms6_content c 
					, cms6_content c3 
				WHERE 
					c.deleted = 0 
					AND c.visible = 1 
					AND c.contenttype = 1 
					AND c.language_id = 1 
					AND (
						 c.alias = "lilo" 
						 OR
						 c.id = 0
						 )
					AND c2.parent_id = c3.id AND c3.alias = "clowns" 
				ORDER BY 
					c.priority, c.headline, c.id 
				LIMIT 
					1 
				, error: Unknown column 'c2.parent_id' in 'where clause'