Биллинговая система Nodeny

SELECT u.id,u.name,u.ip FROM users u
INNER JOIN pays p ON p.mid=u.id
WHERE p.type=50 AND ((p.category=410 AND p.reason LIKE 'Включен ли доступ: да -> нет') OR
p.category=423) AND
p.time>=unix_timestamp('2013-03-01')  AND u.state='off'
GROUP BY u.id

SELECT u.id,u.name,u.ip,FROM_UNIXTIME(p.time) FROM users u
INNER JOIN pays p ON p.mid=u.id
WHERE p.type=50 AND ((p.category=410 AND p.reason LIKE 'Включен ли доступ: да -> нет') OR
p.category=423) AND
p.time>=unix_timestamp('2013-03-01')  AND u.state='off'
GROUP BY u.id

select FROM_UNIXTIME(time),reason,coment,type,category from pays where mid=(select id from users where name='ТВОЙЛОГИН') AND time>=unix_timestamp('2013-03-01');