Just paste
Create new paste
Pastes Archive
2022-08-05 17:34:50
copy
raw
download
EXPLAIN SELECT `users`.`login`, `realname`.`realname`, `Passive`, `Down`, `Password`,`AlwaysOnline`, `Tariff`, `TariffChange`, `Credit`, `Cash`, `ip`, `mac`, `cityname`, `streetname`, `buildnum`, `entrance`, `floor`, `apt`, `geo`,concat(`streetname`, ' ', `buildnum`, IF(`apt`, concat('/',`apt`), '')) AS `fulladress`, `phones`.`phone`,`mobile`,`contract`,`emails`.`email` FROM `users` LEFT JOIN `nethosts` USING (`ip`) LEFT JOIN `realname` ON (`users`.`login`=`realname`.`login`) LEFT JOIN `address` ON (`users`.`login`=`address`.`login`) LEFT JOIN `apt` ON (`address`.`aptid`=`apt`.`id`) LEFT JOIN `build` ON (`apt`.`buildid`=`build`.`id`) LEFT JOIN `street` ON (`build`.`streetid`=`street`.`id`) LEFT JOIN `city` ON (`street`.`cityid`=`city`.`id`) LEFT JOIN `phones` ON (`users`.`login`=`phones`.`login`) LEFT JOIN `contracts` ON (`users`.`login`=`contracts`.`login`) LEFT JOIN `emails` ON (`users`.`login`=`emails`.`login`);
↑
2022-08-05 17:34:50
Create new paste
Pastes Archive