github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/4.ref.golden (about) 1 // Code generated by TestPretty. DO NOT EDIT. 2 // GENERATED FILE DO NOT EDIT 3 1: 4 - 5 SELECT 6 phone0_.id 7 AS id1_6_0_, 8 person1_.id 9 AS id1_4_1_, 10 phone0_.phone_number 11 AS phone_nu2_6_0_, 12 phone0_.person_id 13 AS person_i4_6_0_, 14 phone0_.phone_type 15 AS phone_ty3_6_0_, 16 addresses2_.person_id 17 AS person_i1_5_0__, 18 addresses2_.addresses 19 AS addresse2_5_0__, 20 addresses2_.addresses_key 21 AS addresse3_0__, 22 person1_.address 23 AS address2_4_1_, 24 person1_.createdon 25 AS createdo3_4_1_, 26 person1_.name 27 AS name4_4_1_, 28 person1_.nickname 29 AS nickname5_4_1_, 30 person1_.version 31 AS version6_4_1_, 32 addresses2_.person_id 33 AS person_i1_5_0__, 34 addresses2_.addresses 35 AS addresse2_5_0__, 36 addresses2_.addresses_key 37 AS addresse3_0__ 38 FROM 39 phone 40 AS phone0_ 41 INNER JOIN person 42 AS person1_ ON 43 phone0_.person_id 44 = person1_.id 45 INNER JOIN person_addresses 46 AS addresses2_ ON 47 person1_.id 48 = addresses2_.person_id 49 WHERE 50 EXISTS( 51 SELECT 52 calls3_.id 53 FROM 54 phone_call 55 AS calls3_ 56 WHERE 57 phone0_.id 58 = calls3_.phone_id 59 ) 60 61 20: 62 -------------------- 63 SELECT 64 phone0_.id 65 AS id1_6_0_, 66 person1_.id 67 AS id1_4_1_, 68 phone0_.phone_number 69 AS phone_nu2_6_0_, 70 phone0_.person_id 71 AS person_i4_6_0_, 72 phone0_.phone_type 73 AS phone_ty3_6_0_, 74 addresses2_.person_id 75 AS person_i1_5_0__, 76 addresses2_.addresses 77 AS addresse2_5_0__, 78 addresses2_.addresses_key 79 AS addresse3_0__, 80 person1_.address 81 AS address2_4_1_, 82 person1_.createdon 83 AS createdo3_4_1_, 84 person1_.name 85 AS name4_4_1_, 86 person1_.nickname 87 AS nickname5_4_1_, 88 person1_.version 89 AS version6_4_1_, 90 addresses2_.person_id 91 AS person_i1_5_0__, 92 addresses2_.addresses 93 AS addresse2_5_0__, 94 addresses2_.addresses_key 95 AS addresse3_0__ 96 FROM 97 phone AS phone0_ 98 INNER JOIN person 99 AS person1_ ON 100 phone0_.person_id 101 = person1_.id 102 INNER JOIN person_addresses 103 AS addresses2_ ON 104 person1_.id 105 = addresses2_.person_id 106 WHERE 107 EXISTS( 108 SELECT 109 calls3_.id 110 FROM 111 phone_call 112 AS calls3_ 113 WHERE 114 phone0_.id 115 = calls3_.phone_id 116 ) 117 118 27: 119 --------------------------- 120 SELECT 121 phone0_.id AS id1_6_0_, 122 person1_.id 123 AS id1_4_1_, 124 phone0_.phone_number 125 AS phone_nu2_6_0_, 126 phone0_.person_id 127 AS person_i4_6_0_, 128 phone0_.phone_type 129 AS phone_ty3_6_0_, 130 addresses2_.person_id 131 AS person_i1_5_0__, 132 addresses2_.addresses 133 AS addresse2_5_0__, 134 addresses2_.addresses_key 135 AS addresse3_0__, 136 person1_.address 137 AS address2_4_1_, 138 person1_.createdon 139 AS createdo3_4_1_, 140 person1_.name 141 AS name4_4_1_, 142 person1_.nickname 143 AS nickname5_4_1_, 144 person1_.version 145 AS version6_4_1_, 146 addresses2_.person_id 147 AS person_i1_5_0__, 148 addresses2_.addresses 149 AS addresse2_5_0__, 150 addresses2_.addresses_key 151 AS addresse3_0__ 152 FROM 153 phone AS phone0_ 154 INNER JOIN person 155 AS person1_ ON 156 phone0_.person_id 157 = person1_.id 158 INNER JOIN person_addresses 159 AS addresses2_ ON 160 person1_.id 161 = addresses2_.person_id 162 WHERE 163 EXISTS( 164 SELECT 165 calls3_.id 166 FROM 167 phone_call 168 AS calls3_ 169 WHERE 170 phone0_.id 171 = calls3_.phone_id 172 ) 173 174 28: 175 ---------------------------- 176 SELECT 177 phone0_.id AS id1_6_0_, 178 person1_.id AS id1_4_1_, 179 phone0_.phone_number 180 AS phone_nu2_6_0_, 181 phone0_.person_id 182 AS person_i4_6_0_, 183 phone0_.phone_type 184 AS phone_ty3_6_0_, 185 addresses2_.person_id 186 AS person_i1_5_0__, 187 addresses2_.addresses 188 AS addresse2_5_0__, 189 addresses2_.addresses_key 190 AS addresse3_0__, 191 person1_.address 192 AS address2_4_1_, 193 person1_.createdon 194 AS createdo3_4_1_, 195 person1_.name 196 AS name4_4_1_, 197 person1_.nickname 198 AS nickname5_4_1_, 199 person1_.version 200 AS version6_4_1_, 201 addresses2_.person_id 202 AS person_i1_5_0__, 203 addresses2_.addresses 204 AS addresse2_5_0__, 205 addresses2_.addresses_key 206 AS addresse3_0__ 207 FROM 208 phone AS phone0_ 209 INNER JOIN person 210 AS person1_ ON 211 phone0_.person_id 212 = person1_.id 213 INNER JOIN person_addresses 214 AS addresses2_ ON 215 person1_.id 216 = addresses2_.person_id 217 WHERE 218 EXISTS( 219 SELECT 220 calls3_.id 221 FROM 222 phone_call 223 AS calls3_ 224 WHERE 225 phone0_.id 226 = calls3_.phone_id 227 ) 228 229 32: 230 -------------------------------- 231 SELECT 232 phone0_.id AS id1_6_0_, 233 person1_.id AS id1_4_1_, 234 phone0_.phone_number 235 AS phone_nu2_6_0_, 236 phone0_.person_id 237 AS person_i4_6_0_, 238 phone0_.phone_type 239 AS phone_ty3_6_0_, 240 addresses2_.person_id 241 AS person_i1_5_0__, 242 addresses2_.addresses 243 AS addresse2_5_0__, 244 addresses2_.addresses_key 245 AS addresse3_0__, 246 person1_.address 247 AS address2_4_1_, 248 person1_.createdon 249 AS createdo3_4_1_, 250 person1_.name AS name4_4_1_, 251 person1_.nickname 252 AS nickname5_4_1_, 253 person1_.version 254 AS version6_4_1_, 255 addresses2_.person_id 256 AS person_i1_5_0__, 257 addresses2_.addresses 258 AS addresse2_5_0__, 259 addresses2_.addresses_key 260 AS addresse3_0__ 261 FROM 262 phone AS phone0_ 263 INNER JOIN person 264 AS person1_ ON 265 phone0_.person_id 266 = person1_.id 267 INNER JOIN person_addresses 268 AS addresses2_ ON 269 person1_.id 270 = addresses2_.person_id 271 WHERE 272 EXISTS( 273 SELECT 274 calls3_.id 275 FROM 276 phone_call 277 AS calls3_ 278 WHERE 279 phone0_.id 280 = calls3_.phone_id 281 ) 282 283 33: 284 --------------------------------- 285 SELECT 286 phone0_.id AS id1_6_0_, 287 person1_.id AS id1_4_1_, 288 phone0_.phone_number 289 AS phone_nu2_6_0_, 290 phone0_.person_id 291 AS person_i4_6_0_, 292 phone0_.phone_type 293 AS phone_ty3_6_0_, 294 addresses2_.person_id 295 AS person_i1_5_0__, 296 addresses2_.addresses 297 AS addresse2_5_0__, 298 addresses2_.addresses_key 299 AS addresse3_0__, 300 person1_.address 301 AS address2_4_1_, 302 person1_.createdon 303 AS createdo3_4_1_, 304 person1_.name AS name4_4_1_, 305 person1_.nickname 306 AS nickname5_4_1_, 307 person1_.version 308 AS version6_4_1_, 309 addresses2_.person_id 310 AS person_i1_5_0__, 311 addresses2_.addresses 312 AS addresse2_5_0__, 313 addresses2_.addresses_key 314 AS addresse3_0__ 315 FROM 316 phone AS phone0_ 317 INNER JOIN person 318 AS person1_ ON 319 phone0_.person_id 320 = person1_.id 321 INNER JOIN person_addresses 322 AS addresses2_ ON 323 person1_.id 324 = addresses2_.person_id 325 WHERE 326 EXISTS( 327 SELECT 328 calls3_.id 329 FROM 330 phone_call AS calls3_ 331 WHERE 332 phone0_.id 333 = calls3_.phone_id 334 ) 335 336 36: 337 ------------------------------------ 338 SELECT 339 phone0_.id AS id1_6_0_, 340 person1_.id AS id1_4_1_, 341 phone0_.phone_number 342 AS phone_nu2_6_0_, 343 phone0_.person_id 344 AS person_i4_6_0_, 345 phone0_.phone_type 346 AS phone_ty3_6_0_, 347 addresses2_.person_id 348 AS person_i1_5_0__, 349 addresses2_.addresses 350 AS addresse2_5_0__, 351 addresses2_.addresses_key 352 AS addresse3_0__, 353 person1_.address 354 AS address2_4_1_, 355 person1_.createdon 356 AS createdo3_4_1_, 357 person1_.name AS name4_4_1_, 358 person1_.nickname 359 AS nickname5_4_1_, 360 person1_.version 361 AS version6_4_1_, 362 addresses2_.person_id 363 AS person_i1_5_0__, 364 addresses2_.addresses 365 AS addresse2_5_0__, 366 addresses2_.addresses_key 367 AS addresse3_0__ 368 FROM 369 phone AS phone0_ 370 INNER JOIN person AS person1_ ON 371 phone0_.person_id 372 = person1_.id 373 INNER JOIN person_addresses 374 AS addresses2_ ON 375 person1_.id 376 = addresses2_.person_id 377 WHERE 378 EXISTS( 379 SELECT 380 calls3_.id 381 FROM 382 phone_call AS calls3_ 383 WHERE 384 phone0_.id 385 = calls3_.phone_id 386 ) 387 388 38: 389 -------------------------------------- 390 SELECT 391 phone0_.id AS id1_6_0_, 392 person1_.id AS id1_4_1_, 393 phone0_.phone_number 394 AS phone_nu2_6_0_, 395 phone0_.person_id 396 AS person_i4_6_0_, 397 phone0_.phone_type 398 AS phone_ty3_6_0_, 399 addresses2_.person_id 400 AS person_i1_5_0__, 401 addresses2_.addresses 402 AS addresse2_5_0__, 403 addresses2_.addresses_key 404 AS addresse3_0__, 405 person1_.address AS address2_4_1_, 406 person1_.createdon 407 AS createdo3_4_1_, 408 person1_.name AS name4_4_1_, 409 person1_.nickname 410 AS nickname5_4_1_, 411 person1_.version AS version6_4_1_, 412 addresses2_.person_id 413 AS person_i1_5_0__, 414 addresses2_.addresses 415 AS addresse2_5_0__, 416 addresses2_.addresses_key 417 AS addresse3_0__ 418 FROM 419 phone AS phone0_ 420 INNER JOIN person AS person1_ ON 421 phone0_.person_id 422 = person1_.id 423 INNER JOIN person_addresses 424 AS addresses2_ ON 425 person1_.id 426 = addresses2_.person_id 427 WHERE 428 EXISTS( 429 SELECT 430 calls3_.id 431 FROM 432 phone_call AS calls3_ 433 WHERE 434 phone0_.id 435 = calls3_.phone_id 436 ) 437 438 40: 439 ---------------------------------------- 440 SELECT 441 phone0_.id AS id1_6_0_, 442 person1_.id AS id1_4_1_, 443 phone0_.phone_number 444 AS phone_nu2_6_0_, 445 phone0_.person_id AS person_i4_6_0_, 446 phone0_.phone_type 447 AS phone_ty3_6_0_, 448 addresses2_.person_id 449 AS person_i1_5_0__, 450 addresses2_.addresses 451 AS addresse2_5_0__, 452 addresses2_.addresses_key 453 AS addresse3_0__, 454 person1_.address AS address2_4_1_, 455 person1_.createdon 456 AS createdo3_4_1_, 457 person1_.name AS name4_4_1_, 458 person1_.nickname AS nickname5_4_1_, 459 person1_.version AS version6_4_1_, 460 addresses2_.person_id 461 AS person_i1_5_0__, 462 addresses2_.addresses 463 AS addresse2_5_0__, 464 addresses2_.addresses_key 465 AS addresse3_0__ 466 FROM 467 phone AS phone0_ 468 INNER JOIN person AS person1_ ON 469 phone0_.person_id 470 = person1_.id 471 INNER JOIN person_addresses 472 AS addresses2_ ON 473 person1_.id 474 = addresses2_.person_id 475 WHERE 476 EXISTS( 477 SELECT 478 calls3_.id 479 FROM 480 phone_call AS calls3_ 481 WHERE 482 phone0_.id 483 = calls3_.phone_id 484 ) 485 486 41: 487 ----------------------------------------- 488 SELECT 489 phone0_.id AS id1_6_0_, 490 person1_.id AS id1_4_1_, 491 phone0_.phone_number 492 AS phone_nu2_6_0_, 493 phone0_.person_id AS person_i4_6_0_, 494 phone0_.phone_type AS phone_ty3_6_0_, 495 addresses2_.person_id 496 AS person_i1_5_0__, 497 addresses2_.addresses 498 AS addresse2_5_0__, 499 addresses2_.addresses_key 500 AS addresse3_0__, 501 person1_.address AS address2_4_1_, 502 person1_.createdon AS createdo3_4_1_, 503 person1_.name AS name4_4_1_, 504 person1_.nickname AS nickname5_4_1_, 505 person1_.version AS version6_4_1_, 506 addresses2_.person_id 507 AS person_i1_5_0__, 508 addresses2_.addresses 509 AS addresse2_5_0__, 510 addresses2_.addresses_key 511 AS addresse3_0__ 512 FROM 513 phone AS phone0_ 514 INNER JOIN person AS person1_ ON 515 phone0_.person_id 516 = person1_.id 517 INNER JOIN person_addresses 518 AS addresses2_ ON 519 person1_.id 520 = addresses2_.person_id 521 WHERE 522 EXISTS( 523 SELECT 524 calls3_.id 525 FROM 526 phone_call AS calls3_ 527 WHERE 528 phone0_.id = calls3_.phone_id 529 ) 530 531 43: 532 ------------------------------------------- 533 SELECT 534 phone0_.id AS id1_6_0_, 535 person1_.id AS id1_4_1_, 536 phone0_.phone_number AS phone_nu2_6_0_, 537 phone0_.person_id AS person_i4_6_0_, 538 phone0_.phone_type AS phone_ty3_6_0_, 539 addresses2_.person_id 540 AS person_i1_5_0__, 541 addresses2_.addresses 542 AS addresse2_5_0__, 543 addresses2_.addresses_key 544 AS addresse3_0__, 545 person1_.address AS address2_4_1_, 546 person1_.createdon AS createdo3_4_1_, 547 person1_.name AS name4_4_1_, 548 person1_.nickname AS nickname5_4_1_, 549 person1_.version AS version6_4_1_, 550 addresses2_.person_id 551 AS person_i1_5_0__, 552 addresses2_.addresses 553 AS addresse2_5_0__, 554 addresses2_.addresses_key 555 AS addresse3_0__ 556 FROM 557 phone AS phone0_ 558 INNER JOIN person AS person1_ ON 559 phone0_.person_id = person1_.id 560 INNER JOIN person_addresses 561 AS addresses2_ ON 562 person1_.id 563 = addresses2_.person_id 564 WHERE 565 EXISTS( 566 SELECT 567 calls3_.id 568 FROM 569 phone_call AS calls3_ 570 WHERE 571 phone0_.id = calls3_.phone_id 572 ) 573 574 45: 575 --------------------------------------------- 576 SELECT 577 phone0_.id AS id1_6_0_, 578 person1_.id AS id1_4_1_, 579 phone0_.phone_number AS phone_nu2_6_0_, 580 phone0_.person_id AS person_i4_6_0_, 581 phone0_.phone_type AS phone_ty3_6_0_, 582 addresses2_.person_id AS person_i1_5_0__, 583 addresses2_.addresses AS addresse2_5_0__, 584 addresses2_.addresses_key 585 AS addresse3_0__, 586 person1_.address AS address2_4_1_, 587 person1_.createdon AS createdo3_4_1_, 588 person1_.name AS name4_4_1_, 589 person1_.nickname AS nickname5_4_1_, 590 person1_.version AS version6_4_1_, 591 addresses2_.person_id AS person_i1_5_0__, 592 addresses2_.addresses AS addresse2_5_0__, 593 addresses2_.addresses_key 594 AS addresse3_0__ 595 FROM 596 phone AS phone0_ 597 INNER JOIN person AS person1_ ON 598 phone0_.person_id = person1_.id 599 INNER JOIN person_addresses 600 AS addresses2_ ON 601 person1_.id 602 = addresses2_.person_id 603 WHERE 604 EXISTS( 605 SELECT 606 calls3_.id 607 FROM 608 phone_call AS calls3_ 609 WHERE 610 phone0_.id = calls3_.phone_id 611 ) 612 613 46: 614 ---------------------------------------------- 615 SELECT 616 phone0_.id AS id1_6_0_, 617 person1_.id AS id1_4_1_, 618 phone0_.phone_number AS phone_nu2_6_0_, 619 phone0_.person_id AS person_i4_6_0_, 620 phone0_.phone_type AS phone_ty3_6_0_, 621 addresses2_.person_id AS person_i1_5_0__, 622 addresses2_.addresses AS addresse2_5_0__, 623 addresses2_.addresses_key 624 AS addresse3_0__, 625 person1_.address AS address2_4_1_, 626 person1_.createdon AS createdo3_4_1_, 627 person1_.name AS name4_4_1_, 628 person1_.nickname AS nickname5_4_1_, 629 person1_.version AS version6_4_1_, 630 addresses2_.person_id AS person_i1_5_0__, 631 addresses2_.addresses AS addresse2_5_0__, 632 addresses2_.addresses_key AS addresse3_0__ 633 FROM 634 phone AS phone0_ 635 INNER JOIN person AS person1_ ON 636 phone0_.person_id = person1_.id 637 INNER JOIN person_addresses 638 AS addresses2_ ON 639 person1_.id 640 = addresses2_.person_id 641 WHERE 642 EXISTS( 643 SELECT 644 calls3_.id 645 FROM 646 phone_call AS calls3_ 647 WHERE 648 phone0_.id = calls3_.phone_id 649 ) 650 651 47: 652 ----------------------------------------------- 653 SELECT 654 phone0_.id AS id1_6_0_, 655 person1_.id AS id1_4_1_, 656 phone0_.phone_number AS phone_nu2_6_0_, 657 phone0_.person_id AS person_i4_6_0_, 658 phone0_.phone_type AS phone_ty3_6_0_, 659 addresses2_.person_id AS person_i1_5_0__, 660 addresses2_.addresses AS addresse2_5_0__, 661 addresses2_.addresses_key AS addresse3_0__, 662 person1_.address AS address2_4_1_, 663 person1_.createdon AS createdo3_4_1_, 664 person1_.name AS name4_4_1_, 665 person1_.nickname AS nickname5_4_1_, 666 person1_.version AS version6_4_1_, 667 addresses2_.person_id AS person_i1_5_0__, 668 addresses2_.addresses AS addresse2_5_0__, 669 addresses2_.addresses_key AS addresse3_0__ 670 FROM 671 phone AS phone0_ 672 INNER JOIN person AS person1_ ON 673 phone0_.person_id = person1_.id 674 INNER JOIN person_addresses 675 AS addresses2_ ON 676 person1_.id = addresses2_.person_id 677 WHERE 678 EXISTS( 679 SELECT 680 calls3_.id 681 FROM 682 phone_call AS calls3_ 683 WHERE 684 phone0_.id = calls3_.phone_id 685 ) 686 687 49: 688 ------------------------------------------------- 689 SELECT 690 phone0_.id AS id1_6_0_, 691 person1_.id AS id1_4_1_, 692 phone0_.phone_number AS phone_nu2_6_0_, 693 phone0_.person_id AS person_i4_6_0_, 694 phone0_.phone_type AS phone_ty3_6_0_, 695 addresses2_.person_id AS person_i1_5_0__, 696 addresses2_.addresses AS addresse2_5_0__, 697 addresses2_.addresses_key AS addresse3_0__, 698 person1_.address AS address2_4_1_, 699 person1_.createdon AS createdo3_4_1_, 700 person1_.name AS name4_4_1_, 701 person1_.nickname AS nickname5_4_1_, 702 person1_.version AS version6_4_1_, 703 addresses2_.person_id AS person_i1_5_0__, 704 addresses2_.addresses AS addresse2_5_0__, 705 addresses2_.addresses_key AS addresse3_0__ 706 FROM 707 phone AS phone0_ 708 INNER JOIN person AS person1_ ON 709 phone0_.person_id = person1_.id 710 INNER JOIN person_addresses AS addresses2_ ON 711 person1_.id = addresses2_.person_id 712 WHERE 713 EXISTS( 714 SELECT 715 calls3_.id 716 FROM 717 phone_call AS calls3_ 718 WHERE 719 phone0_.id = calls3_.phone_id 720 ) 721 722 68: 723 -------------------------------------------------------------------- 724 SELECT 725 phone0_.id AS id1_6_0_, 726 person1_.id AS id1_4_1_, 727 phone0_.phone_number AS phone_nu2_6_0_, 728 phone0_.person_id AS person_i4_6_0_, 729 phone0_.phone_type AS phone_ty3_6_0_, 730 addresses2_.person_id AS person_i1_5_0__, 731 addresses2_.addresses AS addresse2_5_0__, 732 addresses2_.addresses_key AS addresse3_0__, 733 person1_.address AS address2_4_1_, 734 person1_.createdon AS createdo3_4_1_, 735 person1_.name AS name4_4_1_, 736 person1_.nickname AS nickname5_4_1_, 737 person1_.version AS version6_4_1_, 738 addresses2_.person_id AS person_i1_5_0__, 739 addresses2_.addresses AS addresse2_5_0__, 740 addresses2_.addresses_key AS addresse3_0__ 741 FROM 742 phone AS phone0_ 743 INNER JOIN person AS person1_ ON phone0_.person_id = person1_.id 744 INNER JOIN person_addresses AS addresses2_ ON 745 person1_.id = addresses2_.person_id 746 WHERE 747 EXISTS( 748 SELECT 749 calls3_.id 750 FROM 751 phone_call AS calls3_ 752 WHERE 753 phone0_.id = calls3_.phone_id 754 ) 755 756 85: 757 ------------------------------------------------------------------------------------- 758 SELECT 759 phone0_.id AS id1_6_0_, 760 person1_.id AS id1_4_1_, 761 phone0_.phone_number AS phone_nu2_6_0_, 762 phone0_.person_id AS person_i4_6_0_, 763 phone0_.phone_type AS phone_ty3_6_0_, 764 addresses2_.person_id AS person_i1_5_0__, 765 addresses2_.addresses AS addresse2_5_0__, 766 addresses2_.addresses_key AS addresse3_0__, 767 person1_.address AS address2_4_1_, 768 person1_.createdon AS createdo3_4_1_, 769 person1_.name AS name4_4_1_, 770 person1_.nickname AS nickname5_4_1_, 771 person1_.version AS version6_4_1_, 772 addresses2_.person_id AS person_i1_5_0__, 773 addresses2_.addresses AS addresse2_5_0__, 774 addresses2_.addresses_key AS addresse3_0__ 775 FROM 776 phone AS phone0_ 777 INNER JOIN person AS person1_ ON phone0_.person_id = person1_.id 778 INNER JOIN person_addresses AS addresses2_ ON person1_.id = addresses2_.person_id 779 WHERE 780 EXISTS( 781 SELECT 782 calls3_.id 783 FROM 784 phone_call AS calls3_ 785 WHERE 786 phone0_.id = calls3_.phone_id 787 ) 788 789 88: 790 ---------------------------------------------------------------------------------------- 791 SELECT 792 phone0_.id AS id1_6_0_, 793 person1_.id AS id1_4_1_, 794 phone0_.phone_number AS phone_nu2_6_0_, 795 phone0_.person_id AS person_i4_6_0_, 796 phone0_.phone_type AS phone_ty3_6_0_, 797 addresses2_.person_id AS person_i1_5_0__, 798 addresses2_.addresses AS addresse2_5_0__, 799 addresses2_.addresses_key AS addresse3_0__, 800 person1_.address AS address2_4_1_, 801 person1_.createdon AS createdo3_4_1_, 802 person1_.name AS name4_4_1_, 803 person1_.nickname AS nickname5_4_1_, 804 person1_.version AS version6_4_1_, 805 addresses2_.person_id AS person_i1_5_0__, 806 addresses2_.addresses AS addresse2_5_0__, 807 addresses2_.addresses_key AS addresse3_0__ 808 FROM 809 phone AS phone0_ 810 INNER JOIN person AS person1_ ON phone0_.person_id = person1_.id 811 INNER JOIN person_addresses AS addresses2_ ON person1_.id = addresses2_.person_id 812 WHERE 813 EXISTS( 814 SELECT calls3_.id FROM phone_call AS calls3_ WHERE phone0_.id = calls3_.phone_id 815 ) 816 817 92: 818 -------------------------------------------------------------------------------------------- 819 SELECT 820 phone0_.id AS id1_6_0_, 821 person1_.id AS id1_4_1_, 822 phone0_.phone_number AS phone_nu2_6_0_, 823 phone0_.person_id AS person_i4_6_0_, 824 phone0_.phone_type AS phone_ty3_6_0_, 825 addresses2_.person_id AS person_i1_5_0__, 826 addresses2_.addresses AS addresse2_5_0__, 827 addresses2_.addresses_key AS addresse3_0__, 828 person1_.address AS address2_4_1_, 829 person1_.createdon AS createdo3_4_1_, 830 person1_.name AS name4_4_1_, 831 person1_.nickname AS nickname5_4_1_, 832 person1_.version AS version6_4_1_, 833 addresses2_.person_id AS person_i1_5_0__, 834 addresses2_.addresses AS addresse2_5_0__, 835 addresses2_.addresses_key AS addresse3_0__ 836 FROM 837 phone AS phone0_ 838 INNER JOIN person AS person1_ ON phone0_.person_id = person1_.id 839 INNER JOIN person_addresses AS addresses2_ ON person1_.id = addresses2_.person_id 840 WHERE 841 EXISTS(SELECT calls3_.id FROM phone_call AS calls3_ WHERE phone0_.id = calls3_.phone_id) 842 843 167: 844 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- 845 SELECT 846 phone0_.id AS id1_6_0_, 847 person1_.id AS id1_4_1_, 848 phone0_.phone_number AS phone_nu2_6_0_, 849 phone0_.person_id AS person_i4_6_0_, 850 phone0_.phone_type AS phone_ty3_6_0_, 851 addresses2_.person_id AS person_i1_5_0__, 852 addresses2_.addresses AS addresse2_5_0__, 853 addresses2_.addresses_key AS addresse3_0__, 854 person1_.address AS address2_4_1_, 855 person1_.createdon AS createdo3_4_1_, 856 person1_.name AS name4_4_1_, 857 person1_.nickname AS nickname5_4_1_, 858 person1_.version AS version6_4_1_, 859 addresses2_.person_id AS person_i1_5_0__, 860 addresses2_.addresses AS addresse2_5_0__, 861 addresses2_.addresses_key AS addresse3_0__ 862 FROM 863 phone AS phone0_ INNER JOIN person AS person1_ ON phone0_.person_id = person1_.id INNER JOIN person_addresses AS addresses2_ ON person1_.id = addresses2_.person_id 864 WHERE 865 EXISTS(SELECT calls3_.id FROM phone_call AS calls3_ WHERE phone0_.id = calls3_.phone_id) 866 867 596: 868 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 869 SELECT 870 phone0_.id AS id1_6_0_, person1_.id AS id1_4_1_, phone0_.phone_number AS phone_nu2_6_0_, phone0_.person_id AS person_i4_6_0_, phone0_.phone_type AS phone_ty3_6_0_, addresses2_.person_id AS person_i1_5_0__, addresses2_.addresses AS addresse2_5_0__, addresses2_.addresses_key AS addresse3_0__, person1_.address AS address2_4_1_, person1_.createdon AS createdo3_4_1_, person1_.name AS name4_4_1_, person1_.nickname AS nickname5_4_1_, person1_.version AS version6_4_1_, addresses2_.person_id AS person_i1_5_0__, addresses2_.addresses AS addresse2_5_0__, addresses2_.addresses_key AS addresse3_0__ 871 FROM 872 phone AS phone0_ INNER JOIN person AS person1_ ON phone0_.person_id = person1_.id INNER JOIN person_addresses AS addresses2_ ON person1_.id = addresses2_.person_id 873 WHERE 874 EXISTS(SELECT calls3_.id FROM phone_call AS calls3_ WHERE phone0_.id = calls3_.phone_id) 875 876 863: 877 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 878 SELECT phone0_.id AS id1_6_0_, person1_.id AS id1_4_1_, phone0_.phone_number AS phone_nu2_6_0_, phone0_.person_id AS person_i4_6_0_, phone0_.phone_type AS phone_ty3_6_0_, addresses2_.person_id AS person_i1_5_0__, addresses2_.addresses AS addresse2_5_0__, addresses2_.addresses_key AS addresse3_0__, person1_.address AS address2_4_1_, person1_.createdon AS createdo3_4_1_, person1_.name AS name4_4_1_, person1_.nickname AS nickname5_4_1_, person1_.version AS version6_4_1_, addresses2_.person_id AS person_i1_5_0__, addresses2_.addresses AS addresse2_5_0__, addresses2_.addresses_key AS addresse3_0__ FROM phone AS phone0_ INNER JOIN person AS person1_ ON phone0_.person_id = person1_.id INNER JOIN person_addresses AS addresses2_ ON person1_.id = addresses2_.person_id WHERE EXISTS(SELECT calls3_.id FROM phone_call AS calls3_ WHERE phone0_.id = calls3_.phone_id) 879 880