foreach ($checkForEsdOnly as $esdCheck) { if ($esdCheck['esdarticle'
]) { $esdOnly = true;
} else { $esdOnly = false;
} } if (!
empty($esdOnly)) { return [];
} $sBasketAmount =
$this->basketModule->
sGetAmount();
if (empty($sBasketAmount['totalAmount'
])) { $sBasketAmount = 0;
} else { $sBasketAmount =
$sBasketAmount['totalAmount'
];
} $sql = '
SELECT
p.ordernumber AS premium_ordernumber,
startprice,
subshopID,
a.id AS articleID,
a.main_detail_id
FROM
s_addon_premiums p,
s_articles a,
s_articles_details d2
WHERE p.ordernumber=d2.ordernumber
AND d2.articleID=a.id
AND (p.subshopID = ? OR p.subshopID = 0)
ORDER BY p.startprice ASC
';