| |
|
|
| |
SELECT bs.id_person1,
bs.id_person2,
p.persname as pn1,
u.login as lo1,
p.sex as sex1,
b1.name as bname1,
pb1.sex as sexb1,
bu.team as team1,
bu2.team as team2,
p1.persname as pn2,
u1.login as lo2,
p1.sex as sex2,
b2.name as bname2,
pb2.sex as sexb2
FROM battle_step bs left join person p
on p.id_person=bs.id_person1
left join users u
on u.id_person=p.id_person
left join bots b1 on b1.id_bot=bs.id_person1
left join person pb1
on pb1.id_person=b1.id_maskperson
left join person p1
on p1.id_person=bs.id_person2
left join users u1 on u1.id_person=p1.id_person left join bots b2
on b2.id_bot=bs.id_person2
left join person pb2
on pb2.id_person=b2.id_maskperson
left join battle_units bu
on bu.id_person=bs.id_person1 and bu.id_battle=bs.id_battle
left join battle_units bu2
on bu2.id_person=bs.id_person2 and bu2.id_battle=bs.id_battle
WHERE bs.id_battle=73517
|
в таких больших sql запросах плохо разбираюсь, подскажите что тут берется из таблицы users | |
| |
|
|
| |
|
|
| |
для: hanterz
(21.02.2007 в 07:22)
| | | Поля
u.login as lo1,
u1.login as lo2,
|
| |
| |
|
|
