SELECT a.* FROM mdslidd a INNER JOIN mdslid b ON b.cve_mdslid=a.cve_mdslid WHERE a.cve_statuscat=1 AND a.cve_sysuser=1 AND b.cve_statuscat=1 AND b.cve_mdslid='1' AND a.fecha_pub <= '2022-08-12 03:19:04' AND a.fecha_fin >= '2022-08-12 03:19:04'

¿Tienes dudas?
Contáctanos