Unknown column 'barro' in 'order clause'
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 '%3111%' or l.localidad like '%3111%') group by i.PKimprenta order by barro limit 0,16