Unknown column 'zafra' in 'order clause'<br>SELECT i.PKimprenta, i.imprenta, l.localidad  FROM imprentas i INNER JOIN localidades l ON i.FKlocalidad = l.PKlocalidad WHERE 1  and (i.imprenta like '%3407%' or l.localidad like '%3407%') 
		group by  i.PKimprenta
		order by  zafra limit 0,16