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-07-06 02:39:16' AND a.fecha_fin >= '2022-07-06 02:39:16'

¿Tienes dudas?
Contáctanos