function getCategoryModelsByCategoryByMarc($idCategory, $idMarc) { $sql = "SELECT MDO_Id, MDO_Nombre\r\n FROM camSeminuevos sen\r\n INNER JOIN camCategorias cat\r\n ON sen.SEN_CAT_Id = cat.CAT_Id\r\n INNER JOIN camMarcas mrc\r\n ON sen.SEN_MAR_Id = mrc.MAR_Id\r\n INNER JOIN camModelos mdo\r\n ON sen.SEN_MDO_Id = mdo.MDO_Id\r\n WHERE CAT_Id = :idCategory\r\n AND MAR_Id = :idMarc\r\n GROUP BY SEN_MDO_Id\r\n ORDER BY CAT_Id, MAR_Id, MDO_Id\r\n "; getCategoryModelsByCategoryByMarcJSON($sql, $idCategory, $idMarc); }
function getCategoryModelsByCategoryByMarc($idCategory, $idMarc) { $sql = "SELECT MDO_Id, MDO_Nombre\r\n FROM (\r\n SELECT *\r\n FROM v_camSeminuevos\r\n WHERE SEN_Status = 1\r\n ) sen\r\n\t\t\t\tWHERE SEN_AGN_Id = 7\r\n AND CAT_Id = :idCategory\r\n AND MAR_Id = :idMarc\r\n GROUP BY SEN_MDO_Id\r\n ORDER BY CAT_Id, MAR_Id, MDO_Id"; getCategoryModelsByCategoryByMarcJSON($sql, $idCategory, $idMarc); }
function getCategoryModelsByCategoryByMarc($idCategory, $idMarc) { $sql = "SELECT MDO_Id, MDO_Nombre\r\n FROM v_camSeminuevos sen\r\n WHERE CAT_Id = :idCategory\r\n AND MAR_Id = :idMarc\r\n GROUP BY SEN_MDO_Id\r\n ORDER BY CAT_Id, MAR_Id, MDO_Id"; getCategoryModelsByCategoryByMarcJSON($sql, $idCategory, $idMarc); }