SELECT SQL_CALC_FOUND_ROWS
laboratoriosd.*
FROM laboratoriosd
WHERE ((SELECT COUNT(*) FROM laboratoriosd_analisis WHERE FIND_IN_SET('1',enfermedades) AND FIND_IN_SET(id,laboratoriosd.analisis))>0 OR (SELECT COUNT(*) FROM laboratoriosd_analisis WHERE FIND_IN_SET('14',enfermedades) AND FIND_IN_SET(id,laboratoriosd.analisis))>0 OR (SELECT COUNT(*) FROM laboratoriosd_analisis WHERE FIND_IN_SET('19',enfermedades) AND FIND_IN_SET(id,laboratoriosd.analisis))>0 OR (SELECT COUNT(*) FROM laboratoriosd_analisis WHERE FIND_IN_SET('36',enfermedades) AND FIND_IN_SET(id,laboratoriosd.analisis))>0 OR (SELECT COUNT(*) FROM laboratoriosd_analisis WHERE FIND_IN_SET('37',enfermedades) AND FIND_IN_SET(id,laboratoriosd.analisis))>0 OR (SELECT COUNT(*) FROM laboratoriosd_analisis WHERE FIND_IN_SET('38',enfermedades) AND FIND_IN_SET(id,laboratoriosd.analisis))>0) AND (laboratoriosd.provincia LIKE '%Buenos Aires%') AND laboratoriosd.nombre IS NOT NULL AND laboratoriosd.habilitar = 1
GROUP BY laboratoriosd.id
ORDER BY laboratoriosd.suscripto DESC,nombre ASC
LIMIT 0,20




NUMERO DE FILAS:20