SELECT c.id AS c__id, c.name AS c__name, c.spottext AS c__spottext, c.code AS c__code, c.brandid AS c__brandid, c.orderstartdate AS c__orderstartdate, c.orderclosedate AS c__orderclosedate, c.orderdeliverydate AS c__orderdeliverydate, c.discountrate AS c__discountrate, c.termsconditions AS c__termsconditions, c.csstemplateid AS c__csstemplateid, c.campaignstatus AS c__campaignstatus, c.registrationdate AS c__registrationdate, c.status AS c__status, c2.id AS c2__id, c2.brandname AS c2__brandname, c2.brandlabel AS c2__brandlabel, c2.status AS c2__status, c3.id AS c3__id, c3.campaignid AS c3__campaignid, c3.productid AS c3__productid, c3.sort AS c3__sort, c3.status AS c3__status, p.id AS p__id, p.name AS p__name, p.code AS p__code, p.description AS p__description, p.termsconditions AS p__termsconditions, p.brandid AS p__brandid, p.price AS p__price, p.arrivalprice AS p__arrivalprice, p.marketprice AS p__marketprice, p.taxrate AS p__taxrate, p.maxorderpiece AS p__maxorderpiece, p.productstatus AS p__productstatus, p.groupid AS p__groupid, p.registrationdate AS p__registrationdate, p.status AS p__status, p2.id AS p2__id, p2.productid AS p2__productid, p2.categoryid AS p2__categoryid, p2.status AS p2__status, c4.id AS c4__id, c4.campaignid AS c4__campaignid, c4.sortvalue AS c4__sortvalue, c4.status AS c4__status, c5.id AS c5__id, c5.categoryname AS c5__categoryname, c5.categorylabel AS c5__categorylabel, c5.status AS c5__status, c6.id AS c6__id, c6.campaignid AS c6__campaignid, c6.categoryid AS c6__categoryid, c6.sort AS c6__sort, c6.status AS c6__status, c7.id AS c7__id, c7.categoryname AS c7__categoryname, c7.categorylabel AS c7__categorylabel, c7.status AS c7__status, c8.id AS c8__id, c8.campaignid AS c8__campaignid, c8.imagename AS c8__imagename, c8.imagepath AS c8__imagepath, c8.imagetype AS c8__imagetype, c8.status AS c8__status, c9.id AS c9__id, c9.templatename AS c9__templatename, c9.status AS c9__status FROM Campaign c LEFT JOIN CampaignBrandLookup c2 ON c.brandid = c2.id LEFT JOIN CampaignProduct c3 ON c.id = c3.campaignid LEFT JOIN Product p ON c3.productid = p.id LEFT JOIN ProductCategory p2 ON p.id = p2.productid INNER JOIN CampaignSort c4 ON c.id = c4.campaignid LEFT JOIN CampaignProductCategoryLookup c5 ON p2.categoryid = c5.id LEFT JOIN CampaignCategory c6 ON c.id = c6.campaignid LEFT JOIN CampaignCategoryLookup c7 ON c6.categoryid = c7.id LEFT JOIN CampaignImage c8 ON c.id = c8.campaignid LEFT JOIN CampaignCssTemplateLookup c9 ON c.csstemplateid = c9.id WHERE c.id IN ('49', '46', '54') AND (c.campaignstatus = ? AND c4.sortvalue > ?) ORDER BY c4.sortvalue desc