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