$PreParams=$Kernel->getRecords($GLOBAL->Products,array(
"as"=>array(
"{$GLOBAL->Products}.Id"=>"Id",
"{$GLOBAL->Products}.Parent"=>"Parent",
"{$GLOBAL->ProductsParameters}.Id"=>"IdParam",
"{$GLOBAL->ProductsValues}.Id"=>"IdValue",
"{$GLOBAL->ProductsValues}.IsBrand"=>"IsBrand"
),
"what"=>"break", //<-пропуск параметра
"inner"=>array(
"table"=>array(
$GLOBAL->RelationsProductsValues,
$GLOBAL->ProductsValues,
$GLOBAL->ProductsParameters
),
"on"=>array(
"{$GLOBAL->RelationsProductsValues}.IdProduct={$GLOBAL->Products}.Id",
"{$GLOBAL->RelationsProductsValues}.IdValue={$GLOBAL->ProductsValues}.Id",
"{$GLOBAL->ProductsValues}.Param={$GLOBAL->ProductsParameters}.Id"
)
),
"where"=>"{$GLOBAL->Products}.Parent={$CategoryInfo->Id} AND {$GLOBAL->Products}.Status='Y'",
"order"=>"{$GLOBAL->Products}.Price"
));
SELECT someDB.`Products`.Id AS Id,someDB.`Products`.Parent AS Parent,someDB.`ProductsParameters`.Id AS IdParam,someDB.`ProductsValues`.Id AS IdValue,someDB.`ProductsValues`.IsBrand AS IsBrand FROM someDB.`Products` INNER JOIN someDB.`RelationsProductsValues` ON someDB.`RelationsProductsValues`.IdProduct=someDB.`Products`.Id INNER JOIN someDB.`ProductsValues` ON someDB.`RelationsProductsValues`.IdValue=someDB.`ProductsValues`.Id INNER JOIN someDB.`ProductsParameters` ON someDB.`ProductsValues`.Param=someDB.`ProductsParameters`.Id WHERE someDB.`Products`.Parent=1 AND someDB.`Products`.Status='Y' ORDER BY someDB.`Products`.Price;