Porto Ferreira Online

SELECT DISTINCT dw.id,cl.id as idcl,
        cl.img,
        cl.titulo,
        cl.slug,
        cl.endereco,
        cl.numero,
        cl.bairro,
        cl.cidade,
        cl.estado,
        cl.telefone,
        cl.whatsapp, 
        dw.path,
				dw.arquivo,
                                dw.destaque
        FROM classificado as cl 
        INNER JOIN classificado_cat as ct
        ON FIND_IN_SET(ct.id,cl.categoria)
				INNER JOIN downloads as dw
				ON dw.tag = cl.id
        WHERE 
        ct.slug = 'servicos' AND cl.status = '1'  AND CURDATE() between dw.dataini and dw.datafim GROUP BY dw.id
        ORDER BY dw.destaque DESC,cl.titulo ASC LIMIT 20
Loja do Bras
Loja do Bras