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-09 08:38:45' AND a.fecha_fin >= '2022-08-09 08:38:45'

¿Tienes dudas?
Contáctanos