User:Lysander/Cathartes-edited ChildWiki pages: Difference between revisions

From BoyWiki
Lysander (talk | contribs)
Created page with "<pre> mysql> select DISTINCT page_is_redirect,page_len,page_namespace,page_title from page JOIN revision ON page.page_id=revision.rev_page WHERE rev_user=4 ORDER BY page_names..."
 
m Etenne moved page User:Leucosticte/Cathartes-edited ChildWiki pages to User:Lysander/Cathartes-edited ChildWiki pages: Automatically moved page while renaming the user "Leucosticte" to "Lysander"
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
<pre>
<pre>
mysql> select DISTINCT page_is_redirect,page_len,page_namespace,page_title from page JOIN revision ON page.page_id=revision.rev_page WHERE rev_user=4 ORDER BY page_namespace,page_title;
mysql> SELECT DISTINCT page_is_redirect,page_len,page_namespace,page_title FROM page JOIN revision ON page.page_id=revision.rev_page WHERE rev_user=4 ORDER BY page_namespace,page_title;
+------------------+----------+----------------+----------------------------------------------------+
+------------------+----------+----------------+----------------------------------------------------+
| page_is_redirect | page_len | page_namespace | page_title                                        |
| page_is_redirect | page_len | page_namespace | page_title                                        |

Latest revision as of 19:53, 7 March 2015

mysql> SELECT DISTINCT page_is_redirect,page_len,page_namespace,page_title FROM page JOIN revision ON page.page_id=revision.rev_page WHERE rev_user=4 ORDER BY page_namespace,page_title;
+------------------+----------+----------------+----------------------------------------------------+
| page_is_redirect | page_len | page_namespace | page_title                                         |
+------------------+----------+----------------+----------------------------------------------------+
|                0 |      602 |              0 | A_Clockwork_Orange                                 |
|                0 |      648 |              0 | Abuse                                              |
|                0 |      524 |              0 | Adolescence                                        |
|                1 |       25 |              0 | Adolescent                                         |
|                0 |      449 |              0 | Adult                                              |
|                1 |       31 |              0 | Adult-supremacist_tyranny                          |
|                0 |      267 |              0 | Adult_supremacism                                  |
|                1 |       31 |              0 | Adult_supremacist                                  |
|                1 |       31 |              0 | Adult_supremacy                                    |
|                1 |       19 |              0 | Adulthood                                          |
|                1 |       28 |              0 | Age-of-consent                                     |
|                0 |     9123 |              0 | Age_of_Consent                                     |
|                0 |    10575 |              0 | Age_of_consent                                     |
|                0 |     5405 |              0 | Age_of_consent_by_jurisdiction                     |
|                0 |      181 |              0 | Age_of_majority                                    |
|                0 |     9147 |              0 | Americans_for_a_Society_Free_from_Age_Restrictions |
|                1 |       37 |              0 | Antagonistic-aggressive                            |
|                0 |      356 |              0 | Antagonistic_aggression                            |
|                1 |       37 |              0 | Antagonistic_aggressors                            |
|                1 |       40 |              0 | Anti-pedophile_fanatics                            |
|                0 |     1108 |              0 | Anti-pedosexual_fanaticism                         |
|                1 |       40 |              0 | Anti-pedosexual_fanatics                           |
|                0 |      499 |              0 | Attitude                                           |
|                1 |       22 |              0 | Attitude_delusion                                  |
|                1 |       30 |              0 | Authoritarian                                      |
|                0 |      690 |              0 | Authoritarianism                                   |
|                1 |       30 |              0 | Authoritarians                                     |
|                0 |     6926 |              0 | B4U-ACT                                            |
|                0 |     2232 |              0 | Child                                              |
|                1 |       22 |              0 | Child_liberation_strategy                          |
|                1 |       19 |              0 | Childhood                                          |
|                0 |      631 |              0 | Children's_liberation_movement                     |
|                1 |      185 |              0 | Circumcision                                       |
|                0 |      785 |              0 | Collectivism                                       |
|                1 |       26 |              0 | Collectivist                                       |
|                1 |       26 |              0 | Collectivists                                      |
|                1 |       31 |              0 | Conscientious                                      |
|                0 |      765 |              0 | Conscientiousness                                  |
|                0 |     4201 |              0 | Cook_with_Amber                                    |
|                0 |     1753 |              0 | Depression                                         |
|                0 |     1616 |              0 | Differential_development                           |
|                0 |      754 |              0 | Disruptive_aggression                              |
|                0 |     3139 |              0 | Dominance                                          |
|                1 |       23 |              0 | Dominance_assertion                                |
|                1 |       23 |              0 | Dominant-aggressive                                |
|                1 |       23 |              0 | Dominant_aggression                                |
|                0 |     2843 |              0 | DreamHost                                          |
|                0 |      710 |              0 | Eugenics                                           |
|                0 |     2172 |              0 | European_Union                                     |
|                0 |      601 |              0 | Execution                                          |
|                0 |     2125 |              0 | Foreskin_amputation                                |
|                0 |      421 |              0 | Free_will                                          |
|                0 |      403 |              0 | Freedom                                            |
|                0 |      379 |              0 | Freedom_from_false_portrayal                       |
|                0 |      675 |              0 | Freedom_of_speech                                  |
|                1 |       21 |              0 | Freedoms                                           |
|                1 |       34 |              0 | Gun_rights                                         |
|                1 |       27 |              0 | Home_schooling                                     |
|                0 |      833 |              0 | Homeschooling                                      |
|                0 |      705 |              0 | Homework                                           |
|                1 |       22 |              0 | Homework_slavery                                   |
|                0 |     2799 |              0 | Homosexuality                                      |
|                0 |      536 |              0 | Humility                                           |
|                0 |      453 |              0 | Ideological_tyranny                                |
|                1 |       24 |              0 | Innate_psychology                                  |
|                0 |     2542 |              0 | Internet                                           |
|                0 |      432 |              0 | Intrinsic_value                                    |
|                0 |      419 |              0 | Jailbait                                           |
|                0 |      355 |              0 | JailbaitGallery.com                                |
|                0 |     1712 |              0 | Lenore_Skenazy                                     |
|                0 |      365 |              0 | Libido                                             |
|                1 |       19 |              0 | Meme                                               |
|                0 |      420 |              0 | Memes                                              |
|                1 |       19 |              0 | Memetic                                            |
|                0 |     1329 |              0 | Minor-attracted_person                             |
|                1 |       36 |              0 | Minor-attracted_persons                            |
|                0 |     1209 |              0 | Minor_attracted_person                             |
|                0 |     2030 |              0 | NYRA                                               |
|                1 |       18 |              0 | National_Youth_Rights_Association                  |
|                1 |       44 |              0 | Necessary_innate_psychological_traits              |
|                0 |      532 |              0 | Necessary_psychological_traits                     |
|                0 |      884 |              0 | Non-sexual_pedophile                               |
|                1 |       34 |              0 | Non-sexual_pedophiles                              |
|                1 |       34 |              0 | Non-sexual_pedophilia                              |
|                1 |       25 |              0 | Objective                                          |
|                0 |      643 |              0 | Objectivity                                        |
|                0 |      856 |              0 | Orthosexual                                        |
|                1 |       25 |              0 | Orthosexuals                                       |
|                1 |       22 |              0 | Paperwork_slavery                                  |
|                0 |      298 |              0 | Peace_and_love                                     |
|                0 |     3215 |              0 | Pedophilia                                         |
|                1 |     5321 |              0 | Pedosexual                                         |
|                0 |     4185 |              0 | Pedosexuality                                      |
|                1 |       27 |              0 | Pedosexuals                                        |
|                0 |      680 |              0 | Personalization_libel                              |
|                1 |       24 |              0 | Perverse                                           |
|                0 |     1368 |              0 | Perversion                                         |
|                1 |       24 |              0 | Perversions                                        |
|                0 |     1206 |              0 | Productivity                                       |
|                1 |       35 |              0 | Psychological_aggression                           |
|                0 |      230 |              0 | Psychology                                         |
|                0 |     1168 |              0 | Puberty                                            |
|                0 |      732 |              0 | Racism                                             |
|                0 |     1132 |              0 | School                                             |
|                1 |       20 |              0 | Schools                                            |
|                0 |      278 |              0 | Selfish_aggression                                 |
|                0 |      791 |              0 | Sexual_maturity                                    |
|                0 |     7360 |              0 | Spanking                                           |
|                0 |     8365 |              0 | Statutory_rape                                     |
|                0 |      523 |              0 | Strategy                                           |
|                1 |       26 |              0 | Stubborn                                           |
|                0 |      436 |              0 | Stubbornness                                       |
|                0 |     2633 |              0 | Suicide                                            |
|                0 |      794 |              0 | Symbiotic_aggression                               |
|                0 |      233 |              0 | TLC_International                                  |
|                1 |       31 |              0 | TLC_international                                  |
|                0 |     2645 |              0 | Terminological_difficulties                        |
|                0 |      863 |              0 | The_Hitler_Youth                                   |
|                0 |      691 |              0 | Violence                                           |
|                1 |       22 |              0 | Violent                                            |
|                0 |      270 |              0 | Youth_liberation                                   |
|                1 |       22 |              0 | Youth_liberation_strategy                          |
|                0 |     3560 |              1 | Age_of_Consent                                     |
|                0 |     1311 |              1 | Age_of_consent                                     |
|                0 |     1886 |              1 | Attitude                                           |
|                0 |     2768 |              1 | B4U-ACT                                            |
|                0 |     1886 |              1 | Capital_punishment                                 |
|                0 |      799 |              1 | Counter-activism_against_pedosexuals               |
|                0 |     5564 |              1 | Dominance                                          |
|                0 |     2210 |              1 | Foreskin_amputation                                |
|                0 |     1350 |              1 | Freedom                                            |
|                0 |      941 |              1 | Main_Page                                          |
|                0 |     3478 |              1 | NYRA                                               |
|                0 |     1649 |              1 | Necessary_psychological_traits                     |
|                0 |     3087 |              1 | Objectivity                                        |
|                0 |      402 |              1 | Orthosexual                                        |
|                0 |     1522 |              1 | Pedophilia                                         |
|                0 |      674 |              1 | Productivity                                       |
|                0 |     1461 |              1 | Racism                                             |
|                0 |      300 |              1 | School                                             |
|                0 |      833 |              1 | Sexual_maturity                                    |
|                0 |       27 |              2 | Cathartes                                          |
|                0 |    47004 |              3 | Cathartes                                          |
|                0 |    63337 |              3 | Leucosticte                                        |
|                0 |     4690 |              4 | Treehouse                                          |
|                0 |       24 |              6 | 28376534tLR.jpg                                    |
|                0 |       24 |              6 | 35427077PmA.jpg                                    |
|                0 |       18 |              6 | Board_Games_Only_Child_Siblings_Play.png           |
|                0 |       99 |              6 | Exceptional_pelvic_development_in_a_minor.jpg      |
|                0 |      261 |              6 | Feminist_ageism.jpg                                |
|                0 |      247 |              6 | Gang_dominance_assertion.jpg                       |
|                0 |       23 |             14 | Biology                                            |
|                0 |       23 |             14 | Consequences_of_adult-supremacist_tyranny          |
|                0 |       23 |             14 | Humor                                              |
|                0 |       23 |             14 | Organizations                                      |
|                0 |       23 |             14 | Psychology                                         |
|                0 |    15691 |           2000 | The_Descent_of_Chester                             |
|                0 |    22636 |           2004 | Drake_and_Cathartes_exchange                       |
|                0 |    10146 |           2005 | Drake_and_Cathartes_exchange                       |
+------------------+----------+----------------+----------------------------------------------------+
159 rows in set (0.05 sec)