function getAgenciesPreOwnedByMap($agnid)
{
$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 = :agnid\r\n ";
getAgenciesPreOwnedByMapsJSON($sql, $agnid);
}
function getAgenciesPreOwnedByMap($agnid)
{
$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 = :agnid";
getAgenciesPreOwnedByMapsJSON($sql, $agnid);
}
function getAgenciesPreOwnedByMap($agnid)
{
$sql = "SELECT *\r\n FROM camAgencias agn\r\n WHERE AGN_Id = :agnid\r\n ";
getAgenciesPreOwnedByMapsJSON($sql, $agnid);
}
