function getAgenciesNewsPrincipales() { $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 (\r\n SELECT *\r\n FROM camAgenciasPrincipales\r\n ) agp\r\n INNER JOIN (\r\n SELECT *\r\n FROM camBrandsLogos\r\n ) brd\r\n ORDER BY AGN_AGP_Id"; getAgenciasLogosJSON($sql); }
function getAgenciesTrucksPrincipales() { $sql = "SELECT *\n FROM (\n SELECT *\n FROM camAgencias\n WHERE AGN_Tipo = 1\n AND AGN_IsAgencieTrucks = 1\n ) agn\n INNER JOIN (\n SELECT *\n FROM camAgenciasPrincipales\n ) agp\n INNER JOIN (\n SELECT *\n FROM camBrandsLogos\n ) brd\n ORDER BY AGN_AGP_Id"; getAgenciasLogosJSON($sql); }