$sql =
Shopware()->
Db()->
limit($sql,
$limit,
$offset);
$shopFallbackId =
($shop->
getFallback() instanceof \Shopware\Models\Shop\Shop
) ?
$shop->
getFallback()->
getId() : null;
$articles =
Shopware()->
Db()->
fetchAll($sql,
[ $shop->
get('parentID'
),
$shop->
getId(),
$shopFallbackId,
'1900-01-01',
]);
$articles =
$this->
RewriteTable()->
mapArticleTranslationObjectData($articles);
$articles =
$this->
get('events'
)->
filter( 'Shopware_Controllers_Backend_Seo_seoArticle_filterArticles',
$articles,
[ 'shop' =>
$shop->
getId(),
] );
foreach ($articles as $article) { $data->
assign('sArticle',
$article);