function getAgenciesPreOwnedByAgencie($agn_nombre, $agn_id)
{
$sql = "SELECT *\r\n FROM camAgencias agn\r\n INNER JOIN camAGNTelefonos agntel\r\n ON agn.AGN_Id = agntel.TEL_AGN_Id\r\n INNER JOIN camAGNHorarios agnhrs\r\n ON agn.AGN_Id = agnhrs.HRS_AGN_Id\r\n INNER JOIN camAGNSociales agnsoc\r\n ON agn.AGN_Id = agnsoc.SOC_AGN_Id\r\n WHERE AGN_Id = :agn_id\r\n AND AGN_Url = :agn_nombre\r\n ORDER BY AGN_Id\r\n ";
getAgenciesPreOwnedByAgencieJSON($sql, $agn_nombre, $agn_id);
}
function getAgenciesPreOwnedByAgencie($agn_nombre, $agn_id)
{
$sql = "SELECT *\r\n FROM (\r\n SELECT *\r\n FROM camAgencias\r\n WHERE AGN_Tipo = 0\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 WHERE AGN_Id = :agn_id\r\n AND AGN_Url = :agn_nombre\r\n ORDER BY AGN_Id";
getAgenciesPreOwnedByAgencieJSON($sql, $agn_nombre, $agn_id);
}
function getAgenciesPreOwnedByAgencie($agn_nombre, $agn_id)
{
$sql = "SELECT *\r\n FROM camAgencias agn\r\n WHERE AGN_Id = :agn_id\r\n AND AGN_Url = :agn_nombre\r\n ORDER BY AGN_Id\r\n ";
getAgenciesPreOwnedByAgencieJSON($sql, $agn_nombre, $agn_id);
}
