|
Query:
select mn.name, mn.autoorders, mn.autoorders_nt, mn.club_status,
tm.name as team_name, c.id as country, nc.name as nteam_name, nc.id as ncountry,
DATE_FORMAT(mn.date_start, '%d/%m/%Y') as date_start,
DATE_FORMAT(mn.date_reg, '%d/%m/%Y') as date_reg,
DATE_FORMAT(mn.date_start_nt, '%d/%m/%Y') as date_start_nt, mn.team, mn.id as mn_id,
mn.all_autoorders, mn.all_autoorders_nt, mn.nteam, mn.mail, mn.rating, mn.finance,
DATE_FORMAT(mn.lastvisit, '%d/%m/%Y %H:%i') as lastvisit_txt,
mn.susp_till_season, mn.susp_till_round, mn.nsusp_till_season, mn.nsusp_till_round,
mn.nochange_till_season, mn.nochange_till_round, mn.bk_finance, mn.bk_forbidden,
mn.training_blocked_till_season, mn.training_blocked_till_round, mn.orders_blocked_games,
mn.mail_verified
from (managers mn left join countries nc on mn.nteam % 10000 = nc.id,
managers mn1 left join teams tm on mn1.team = tm.id
left join countries c on tm.country = c.id)
left join authorize a on mn.name = a.name
where mn.id = '5779' and mn.id = mn1.id
error: Can't open file: './fb/authorize.frm' (errno: 24) |
