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 <= '2023-03-23 05:42:47' AND a.fecha_fin >= '2023-03-23 05:42:47'

¿Tienes dudas?
Contáctanos