SELECT `tl_gk_vouchers`.*, `tl_gk_vouchers`.`stop` AS `validdate`, `tl_gk_companies`.`logo` AS `complogo`, `tl_gk_companies`.`alias` AS `compalias`, `tl_gk_companies`.`title` AS `compname` FROM `tl_gk_vouchers` LEFT JOIN `tl_gk_companies` ON `tl_gk_vouchers`.`company` = `tl_gk_companies`.`id` LEFT JOIN `tl_gk_catmatch` ON `tl_gk_vouchers`.`id`= `tl_gk_catmatch`.`from_id` LEFT JOIN `tl_gk_categories` ON `tl_gk_categories`.`id`= `tl_gk_catmatch`.`catid` WHERE `tl_gk_vouchers`.`active`='1' AND date(from_unixtime(`tl_gk_vouchers`.`start`)) <= '2011-02-09' AND adddate(from_unixtime(`tl_gk_vouchers`.`stop`),3) >= '2011-02-09' AND `from_table`='tl_gk_vouchers' AND `tl_gk_categories`.`alias`= 'computer-buero' ORDER BY `counter`,`modified` DESC LIMIT 0,10