Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

finale47394372

Language: Editor: Layout:
absolute service time: 0,5 sec 
edit mode |  history  | discussion
   id firstname lastname phone companyid
1 2 Anne Beaujeu 0654738293 NULL
2 1 Jean Dupont 0623562783 124
3 3 Alice Terramine 0673839203 NULL
4 4 Hugo Blanchet 06784859403 218
   id name zoneid
1 124 Alchatech 2
2 218 SigmaX2 4
   userid paidat
1 3 01.01.2017 00:00:00
2 2 01.01.2017 00:00:00
3 1 30.06.2017 00:00:00
4 1 18.06.2017 00:00:00
5 2 07.06.2017 00:00:00
6 4 07.06.2017 00:00:00
7 2 01.01.2017 00:00:00
8 2 01.01.2017 00:00:00
   user_id
1 2
2 1
3 1
4 1
5 1
   paidat userid
1 30.06.2017 00:00:00 1
2 18.06.2017 00:00:00 1
3 07.06.2017 00:00:00 4
4 01.01.2017 00:00:00 3
5 01.01.2017 00:00:00 2
6 07.06.2017 00:00:00 2
   userid countorders countreferral
1 2 4 1
2 1 2 4
   firstname lastname phone countorders countreferral name zoneid
1 Hugo Blanchet 06784859403 1 NULL SigmaX2 4
2 Jean Dupont 0623562783 2 4 Alchatech 2
3 Anne Beaujeu 0654738293 4 1 NULL NULL