Haus & Hof

SELECT `oxv_oxarticles_1_de`.`oxid`, `oxv_oxarticles_1_de`.`oxmapid`, `oxv_oxarticles_1_de`.`oxshopid`, `oxv_oxarticles_1_de`.`oxshopincl`, `oxv_oxarticles_1_de`.`oxshopexcl`, `oxv_oxarticles_1_de`.`oxparentid`, `oxv_oxarticles_1_de`.`oxactive`, `oxv_oxarticles_1_de`.`oxhidden`, `oxv_oxarticles_1_de`.`oxactivefrom`, `oxv_oxarticles_1_de`.`oxactiveto`, `oxv_oxarticles_1_de`.`oxartnum`, `oxv_oxarticles_1_de`.`oxean`, `oxv_oxarticles_1_de`.`oxdistean`, `oxv_oxarticles_1_de`.`oxmpn`, `oxv_oxarticles_1_de`.`oxdistributor`, `oxv_oxarticles_1_de`.`oxtitle`, `oxv_oxarticles_1_de`.`oxshortdesc`, `oxv_oxarticles_1_de`.`oxprice`, `oxv_oxarticles_1_de`.`oxblfixedprice`, `oxv_oxarticles_1_de`.`oxpricea`, `oxv_oxarticles_1_de`.`oxpriceb`, `oxv_oxarticles_1_de`.`oxpricec`, `oxv_oxarticles_1_de`.`oxbprice`, `oxv_oxarticles_1_de`.`oxtprice`, `oxv_oxarticles_1_de`.`oxunitname`, `oxv_oxarticles_1_de`.`oxunitquantity`, `oxv_oxarticles_1_de`.`oxexturl`, `oxv_oxarticles_1_de`.`oxurldesc`, `oxv_oxarticles_1_de`.`oxurlimg`, `oxv_oxarticles_1_de`.`oxvat`, `oxv_oxarticles_1_de`.`oxthumb`, `oxv_oxarticles_1_de`.`oxicon`, `oxv_oxarticles_1_de`.`oxpic1`, `oxv_oxarticles_1_de`.`oxpic2`, `oxv_oxarticles_1_de`.`oxpic3`, `oxv_oxarticles_1_de`.`oxpic4`, `oxv_oxarticles_1_de`.`oxpic5`, `oxv_oxarticles_1_de`.`oxpic6`, `oxv_oxarticles_1_de`.`oxpic7`, `oxv_oxarticles_1_de`.`oxpic8`, `oxv_oxarticles_1_de`.`oxpic9`, `oxv_oxarticles_1_de`.`oxpic10`, `oxv_oxarticles_1_de`.`oxpic11`, `oxv_oxarticles_1_de`.`oxpic12`, `oxv_oxarticles_1_de`.`oxzoom1`, `oxv_oxarticles_1_de`.`oxzoom2`, `oxv_oxarticles_1_de`.`oxzoom3`, `oxv_oxarticles_1_de`.`oxzoom4`, `oxv_oxarticles_1_de`.`oxweight`, `oxv_oxarticles_1_de`.`oxstock`, `oxv_oxarticles_1_de`.`oxstockflag`, `oxv_oxarticles_1_de`.`oxstocktext`, `oxv_oxarticles_1_de`.`oxnostocktext`, `oxv_oxarticles_1_de`.`oxdelivery`, `oxv_oxarticles_1_de`.`oxinsert`, `oxv_oxarticles_1_de`.`oxtimestamp`, `oxv_oxarticles_1_de`.`oxlength`, `oxv_oxarticles_1_de`.`oxwidth`, `oxv_oxarticles_1_de`.`oxheight`, `oxv_oxarticles_1_de`.`oxfile`, `oxv_oxarticles_1_de`.`oxsearchkeys`, `oxv_oxarticles_1_de`.`oxtemplate`, `oxv_oxarticles_1_de`.`oxquestionemail`, `oxv_oxarticles_1_de`.`oxissearch`, `oxv_oxarticles_1_de`.`oxisconfigurable`, `oxv_oxarticles_1_de`.`oxvarname`, `oxv_oxarticles_1_de`.`oxvarstock`, `oxv_oxarticles_1_de`.`oxvarcount`, `oxv_oxarticles_1_de`.`oxvarselect`, `oxv_oxarticles_1_de`.`oxvarminprice`, `oxv_oxarticles_1_de`.`oxvarmaxprice`, `oxv_oxarticles_1_de`.`oxbundleid`, `oxv_oxarticles_1_de`.`oxfolder`, `oxv_oxarticles_1_de`.`oxsubclass`, `oxv_oxarticles_1_de`.`oxsort`, `oxv_oxarticles_1_de`.`oxsoldamount`, `oxv_oxarticles_1_de`.`oxnonmaterial`, `oxv_oxarticles_1_de`.`oxfreeshipping`, `oxv_oxarticles_1_de`.`oxremindactive`, `oxv_oxarticles_1_de`.`oxremindamount`, `oxv_oxarticles_1_de`.`oxamitemid`, `oxv_oxarticles_1_de`.`oxamtaskid`, `oxv_oxarticles_1_de`.`oxvendorid`, `oxv_oxarticles_1_de`.`oxmanufacturerid`, `oxv_oxarticles_1_de`.`oxskipdiscounts`, `oxv_oxarticles_1_de`.`oxorderinfo`, `oxv_oxarticles_1_de`.`oxpixiexport`, `oxv_oxarticles_1_de`.`oxpixiexported`, `oxv_oxarticles_1_de`.`oxvpe`, `oxv_oxarticles_1_de`.`oxrating`, `oxv_oxarticles_1_de`.`oxratingcnt`, `oxv_oxarticles_1_de`.`oxasin`, `oxv_oxarticles_1_de`.`dgamazon`, `oxv_oxarticles_1_de`.`d3blhega`, `oxv_oxarticles_1_de`.`hegasperre`, `oxv_oxarticles_1_de`.`d3bluevision`, `oxv_oxarticles_1_de`.`oxpriced`, `oxv_oxarticles_1_de`.`d3onlineprice`, `oxv_oxarticles_1_de`.`oxmindeltime`, `oxv_oxarticles_1_de`.`oxmaxdeltime`, `oxv_oxarticles_1_de`.`oxdeltimeunit`, `oxv_oxarticles_1_de`.`marge`, `oxv_oxarticles_1_de`.`marm_shopgate_marketplace`, `oxv_oxarticles_1_de`.`hhgexport`, `oxv_oxarticles_1_de`.`hhgid`, `oxv_oxarticles_1_de`.`marm_shopgate_export`, `oxv_oxarticles_1_de`.`d3blzookauf`, `oxv_oxarticles_1_de`.`dropshipping`, `oxv_oxarticles_1_de`.`d3blkaysser`, `oxv_oxarticles_1_de`.`sw_amazonean`, `oxv_oxarticles_1_de`.`oldhega`, `oxv_oxarticles_1_de`.`auslaufartikel`, `oxv_oxarticles_1_de`.`hegaartnum`, `oxv_oxarticles_1_de`.`oxupdateprice`, `oxv_oxarticles_1_de`.`oxupdatepricea`, `oxv_oxarticles_1_de`.`oxupdatepriceb`, `oxv_oxarticles_1_de`.`oxupdatepricec`, `oxv_oxarticles_1_de`.`oxupdatepricetime`, `oxv_oxarticles_1_de`.`oxisdownloadable`, `oxv_oxarticles_1_de`.`oxshowcustomagreement`, `oxv_oxarticles_1_de`.`oxweightbrutto`, `oxv_oxarticles_1_de`.`ebay_bearbeit_start`, `oxv_oxarticles_1_de`.`ebay_id`, `oxv_oxarticles_1_de`.`ebay_time_stmp`, `oxv_oxarticles_1_de`.`ebay_gespert`, `oxv_oxarticles_1_de`.`ebay_actual`, `oxv_oxarticles_1_de`.`single_variants`, `oxv_oxarticles_1_de`.`oxparent_ebay_title`, `oxv_oxarticles_1_de`.`ebay_untertitel`, `oxv_oxarticles_1_de`.`ebay_failonupdate`, `oxv_oxarticles_1_de`.`ebay_faildate`, `oxv_oxarticles_1_de`.`ebay_failtext`, `oxv_oxarticles_1_de`.`auto_ebay`, `oxv_oxarticles_1_de`.`only_parent_img`, `oxv_oxarticles_1_de`.`ebaypictosel`, `oxv_oxarticles_1_de`.`varspecs`, `oxv_oxarticles_1_de`.`notvarspecs`, `oxv_oxarticles_1_de`.`amazon_gespert`, `oxv_oxarticles_1_de`.`d3oqm_package`, `oxv_oxarticles_1_de`.`d3oqm_minimum`, `oxv_oxarticles_1_de`.`d3oqm_maximum`, `oxv_oxarticles_1_de`.`ktype`, `oxv_oxarticles_1_de`.`sc_oxstock`, `oxv_oxarticles_1_de`.`sc_parentartnum`, `oxv_oxarticles_1_de`.`sc_oxdrop`, `oxv_oxarticles_1_de`.`sc_oxgp`, `oxv_oxarticles_1_de`.`sc_oxrabatt`, `oxv_oxarticles_1_de`.`d3_searchindexdate`, `oxv_oxarticles_1_de`.`d3push`, `oxv_oxarticles_1_de`.`sc_var`, `oxv_oxarticles_1_de`.`sc_varsort`, `oxv_oxarticles_1_de`.`sc_mwstnr`, `oxv_oxarticles_1_de`.`sc_ean`, `oxv_oxarticles_1_de`.`oxebayvarname`, `oxv_oxarticles_1_de`.`sc_rakkat`, `oxv_oxarticles_1_de`.`oevattbe_istbeservice`, `oxv_oxarticles_1_de`.`mo_dhl_visual_age_check16`, `oxv_oxarticles_1_de`.`mo_dhl_visual_age_check18`, `oxv_oxarticles_1_de`.`mo_dhl_bulky_good`, `oxv_oxarticles_1_de`.`mo_dhl_zolltarif`, oxv_oxarticles_1_de.oxtimestamp FROM oxv_oxcategories_1_de LEFT JOIN oxv_oxobject2category_1 as oc ON oxv_oxcategories_1_de.oxid = oc.oxcatnid LEFT JOIN oxv_oxarticles_1_de ON oxv_oxarticles_1_de.oxid = oc.oxobjectid WHERE ( oxv_oxarticles_1_de.oxactive = 1 and oxv_oxarticles_1_de.oxhidden = 0 and ( oxv_oxarticles_1_de.oxstockflag != 2 or ( oxv_oxarticles_1_de.oxstock + oxv_oxarticles_1_de.oxvarstock ) > 0 ) and IF( oxv_oxarticles_1_de.oxvarcount = 0, 1, ( select 1 from oxv_oxarticles_1_de as art where art.oxparentid=oxv_oxarticles_1_de.oxid and art.oxactive = 1 and ( art.oxstockflag != 2 or art.oxstock > 0 ) limit 1 ) ) and ( ( ( select oxobjectrights.oxobjectid from oxobjectrights where oxobjectrights.oxobjectid = oxv_oxarticles_1_de.oxid and oxobjectrights.oxaction = 1 limit 1 ) is null ) ) ) and oxv_oxarticles_1_de.oxparentid = '' AND oxv_oxcategories_1_de.OXLEFT >= '526' AND oxv_oxcategories_1_de.OXRIGHT <= '543' AND oxv_oxcategories_1_de.OXROOTID = 'ad8479f2542a33ba8.19039064' Group by oxv_oxarticles_1_de.oxid ORDER BY `oxv_oxarticles_1_de`.`OXARTNUM` asc , oc.oxpos, oc.oxobjectid