Created
January 29, 2012 06:13
-
-
Save thowitt/1697507 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Serv query for Derek's company associations: | |
| SELECT this_.id AS id1_3_, | |
| this_1_.created_timestamp AS created2_1_3_, | |
| this_1_.created_user_guid AS created3_1_3_, | |
| this_1_.guid AS guid1_3_, | |
| this_1_.lft AS lft1_3_, | |
| this_1_.modified_timestamp AS modified6_1_3_, | |
| this_1_.modified_user_guid AS modified7_1_3_, | |
| this_1_.name AS name1_3_, | |
| this_1_.node_type AS node9_1_3_, | |
| this_1_.rgt AS rgt1_3_, | |
| this_1_.status_code AS status11_1_3_, | |
| this_1_.version AS version1_3_, | |
| this_.city AS city15_3_, | |
| this_.country AS country15_3_, | |
| this_.line1 AS line3_15_3_, | |
| this_.line2 AS line4_15_3_, | |
| this_.postalcode AS postalcode15_3_, | |
| this_.province AS province15_3_, | |
| this_.localization_id AS localiza8_15_3_, | |
| users3_.node_id AS node1_1_, | |
| dbuser1_.id AS user2_, | |
| dbuser1_.id AS id10_0_, | |
| dbuser1_.attempts AS attempts10_0_, | |
| dbuser1_.created_timestamp AS created3_10_0_, | |
| dbuser1_.created_user_guid AS created4_10_0_, | |
| dbuser1_.email AS email10_0_, | |
| dbuser1_.enc_type AS enc6_10_0_, | |
| dbuser1_.first_name AS first7_10_0_, | |
| dbuser1_.guid AS guid10_0_, | |
| dbuser1_.last_name AS last9_10_0_, | |
| dbuser1_.localization_id AS localiz16_10_0_, | |
| dbuser1_.modified_timestamp AS modified10_10_0_, | |
| dbuser1_.modified_user_guid AS modified11_10_0_, | |
| dbuser1_.password AS password10_0_, | |
| dbuser1_.phone AS phone10_0_, | |
| dbuser1_.status_code AS status14_10_0_, | |
| dbuser1_.version AS version10_0_, | |
| dblocaliza5_.id AS id0_1_, | |
| dblocaliza5_.canonical_id AS canonical2_0_1_, | |
| dblocaliza5_.created_timestamp AS created3_0_1_, | |
| dblocaliza5_.created_user_guid AS created4_0_1_, | |
| dblocaliza5_.example AS example0_1_, | |
| dblocaliza5_.guid AS guid0_1_, | |
| dblocaliza5_.modified_timestamp AS modified7_0_1_, | |
| dblocaliza5_.modified_user_guid AS modified8_0_1_, | |
| dblocaliza5_.php_canonical_id AS php9_0_1_, | |
| dblocaliza5_.status_code AS status10_0_1_, | |
| dblocaliza5_.version AS version0_1_, | |
| dblocaliza6_.id AS id0_2_, | |
| dblocaliza6_.canonical_id AS canonical2_0_2_, | |
| dblocaliza6_.created_timestamp AS created3_0_2_, | |
| dblocaliza6_.created_user_guid AS created4_0_2_, | |
| dblocaliza6_.example AS example0_2_, | |
| dblocaliza6_.guid AS guid0_2_, | |
| dblocaliza6_.modified_timestamp AS modified7_0_2_, | |
| dblocaliza6_.modified_user_guid AS modified8_0_2_, | |
| dblocaliza6_.php_canonical_id AS php9_0_2_, | |
| dblocaliza6_.status_code AS status10_0_2_, | |
| dblocaliza6_.version AS version0_2_ | |
| FROM company this_ | |
| INNER JOIN node this_1_ | |
| ON this_.id = this_1_.id | |
| INNER JOIN user_node users3_ | |
| ON this_.id = users3_.node_id | |
| INNER JOIN user dbuser1_ | |
| ON users3_.user_id = dbuser1_.id | |
| LEFT OUTER JOIN localization dblocaliza5_ | |
| ON dbuser1_.localization_id = dblocaliza5_.id | |
| LEFT OUTER JOIN localization dblocaliza6_ | |
| ON this_.localization_id = dblocaliza6_.id | |
| WHERE ( this_1_.node_type = 2 | |
| AND this_1_.status_code = 0 ) | |
| AND dbuser1_.id IN ( 1579 ); | |
| Serv query for Derek's location memberships under CompanyBLUE | |
| SELECT dblocation0_.id AS id1_, | |
| dblocation0_1_.created_timestamp AS created2_1_, | |
| dblocation0_1_.created_user_guid AS created3_1_, | |
| dblocation0_1_.guid AS guid1_, | |
| dblocation0_1_.lft AS lft1_, | |
| dblocation0_1_.modified_timestamp AS modified6_1_, | |
| dblocation0_1_.modified_user_guid AS modified7_1_, | |
| dblocation0_1_.name AS name1_, | |
| dblocation0_1_.node_type AS node9_1_, | |
| dblocation0_1_.rgt AS rgt1_, | |
| dblocation0_1_.status_code AS status11_1_, | |
| dblocation0_1_.version AS version1_, | |
| dblocation0_.company_id AS company3_14_, | |
| dblocation0_.division_id AS division4_14_, | |
| dblocation0_.localization_id AS localiza5_14_, | |
| dblocation0_.location_type_id AS location6_14_, | |
| dblocation0_.url AS url14_ | |
| FROM location dblocation0_ | |
| INNER JOIN node dblocation0_1_ | |
| ON dblocation0_.id = dblocation0_1_.id | |
| WHERE dblocation0_1_.status_code = 0 | |
| AND ( (1579) IN (SELECT dbuser2_.id | |
| FROM user_node users1_, | |
| user dbuser2_ | |
| WHERE dblocation0_.id = users1_.node_id | |
| AND users1_.user_id = dbuser2_.id) ) | |
| AND dblocation0_1_.rgt < 118 | |
| AND dblocation0_1_.node_type = 2 | |
| AND dblocation0_1_.lft > 103; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment