function getAgenciesNewsByAgencie($agm_nombre, $agm_id)
{
$sql = "SELECT *\r\n FROM camAgenciasNuevos agm\r\n INNER JOIN camAGMTelefonos agmtel\r\n ON agm.AGM_Id = agmtel.TEL_AGM_Id\r\n INNER JOIN camAGMHorarios agmhrs\r\n ON agm.AGM_Id = agmhrs.HRS_AGM_Id\r\n INNER JOIN camAGMSociales agmsoc\r\n ON agm.AGM_Id = agmsoc.SOC_AGM_Id\r\n WHERE AGM_Id = :agm_id\r\n AND AGM_Url = :agm_nombre\r\n ORDER BY AGM_Id\r\n ";
getAgenciesNewsByAgencieJSON($sql, $agm_nombre, $agm_id);
}
function getAgenciesNewsByAgencie($agn_nombre, $agn_id)
{
$sql = "SELECT *\r\n FROM (\r\n SELECT *\r\n FROM camAgencias\r\n WHERE AGN_Tipo = 1\r\n ) agn\r\n INNER JOIN camTelefonos tel\r\n ON agn.AGN_Id = tel.TEL_AGN_Id\r\n INNER JOIN camHorarios hrs\r\n ON agn.AGN_Id = hrs.HRS_AGN_Id\r\n INNER JOIN camSociales soc\r\n ON agn.AGN_Id = soc.SOC_AGN_Id\r\n INNER JOIN camAgenciasPrincipales agp\r\n ON agn.AGN_AGP_Id = agp.AGP_Id\r\n WHERE AGN_Id = :agn_id\r\n AND AGN_Url = :agn_nombre\r\n ORDER BY AGN_Id";
getAgenciesNewsByAgencieJSON($sql, $agn_nombre, $agn_id);
}
function getAgenciesNewsByAgencie($agm_nombre, $agm_id)
{
$sql = "SELECT *\r\n FROM camAgenciasNuevos agm\r\n WHERE AGM_Id = :agm_id\r\n AND AGM_Url = :agm_nombre\r\n ORDER BY AGM_Id\r\n ";
getAgenciesNewsByAgencieJSON($sql, $agm_nombre, $agm_id);
}
