SELECT *, DATE_FORMAT(erp_obr_data_publicacao,'%d/%m/%Y') as data_publicacao
FROM `erp_obra`
INNER JOIN `erp_obra_assunto` ON erp_obra.erp_obr_ass_codigo=erp_obra_assunto.erp_obr_ass_codigo
WHERE erp_obr_ativo = 1 AND erp_obr_publicar_site = 1 AND erp_obr_publicacao = 1
AND (erp_obr_validade IS NULL OR erp_obr_validade >= NOW() )
AND erp_obra.erp_obr_data_publicacao <= NOW()
ORDER BY erp_obra.erp_obr_codigo ASC
Can't create/write to file '/tmp/#sql_69c3_0.MYI' (Errcode: 28)--88
Can't create/write to file '/tmp/#sql_69c3_0.MYI' (Errcode: 28)--88