function getBrandsLogos() { $sql = "SELECT *\r\n FROM (\r\n SELECT *\r\n FROM camBrandsLogos\r\n ) brd\r\n LEFT JOIN (\r\n SELECT *\r\n FROM camAgencias\r\n ) agn\r\n ON agn.AGN_AGP_Id = brd.BRD_AGP_Id\r\n LEFT JOIN (\r\n SELECT *\r\n FROM camAgenciasPrincipales\r\n ) agp\r\n ON agn.AGN_AGP_Id = agp.AGP_Id\r\n GROUP BY BRD_Id\r\n "; getBrandsLogosJSON($sql); }
function getBrandsLogos() { $sql = "SELECT *\n FROM (\n SELECT *\n FROM camBrandsLogos\n WHERE BRD_Status = 1\n ) brd\n LEFT JOIN (\n SELECT *\n FROM camAgencias\n ) agn\n ON agn.AGN_AGP_Id = brd.BRD_AGP_Id\n LEFT JOIN (\n SELECT *\n FROM camAgenciasPrincipales\n ) agp\n ON agn.AGN_AGP_Id = agp.AGP_Id\n GROUP BY BRD_Id\n ORDER BY BRD_Index\n "; getBrandsLogosJSON($sql); }