SELECT users.brugerid, users.username, users.navn, IFNULL((SELECT accesslog.login_time from accesslog where accesslog.xpoint_username=users.username order by accesslog.login_time desc limit 1), 'NOT AVAILABLE') AS logintime, IFNULL((SELECT accesslog.login_status from accesslog where accesslog.xpoint_username=users.username order by accesslog.login_time desc limit 1), 'NOT AVAILABLE') AS loginstatus, IFNULL((SELECT accesslog.xpoint_version from accesslog where accesslog.xpoint_username=users.username order by accesslog.login_time desc limit 1), 'NOT AVAILABLE') AS loginversion, userproducts.productid, userproducts.expiredate, userproducts.productusage, userproducts.ordertime, userproducts.cancelled, products.product_type, product_language.displayname, product_language.region FROM users INNER JOIN userproducts ON userproducts.brugerid = users.brugerid INNER JOIN products ON products.productid = userproducts.productid INNER JOIN product_language ON product_language.productid = products.productid WHERE userproducts.productusage = 'guest' AND users.reseller = 'NeoZone' AND users.password IS NOT NULL AND product_language.lang = 'EN' GROUP BY users.brugerid ORDER BY users.brugerid ASC