SELECT *, varer.id AS uniqueId, varer.lagergruppe AS lagergruppe, varer.lagerantal AS lagerantal, varer_flex.vareid AS vareid, varer_flex.dogtag AS dogtag, varer_flex.beskrivelse AS beskrivelse, varer_flex.tilbudspris AS tilbudspris, varer_flex.pris AS pris, varer_flex.varenavn AS varenavn FROM varer, varer_vg, varer_flex WHERE varer.id = varer_vg.vareid AND varer_vg.vgid = '' AND varer_vg.sprog = '1' AND varer_flex.dogtag <> '' AND varer_flex.vareid = varer.id AND varer_flex.aktiv = '1' AND varer_flex.sprogid = '1' and business='0' ORDER BY varer_flex.varenavn DESC