MariaDB [itwiki_p]> select ct1.ct_rev_id from change_tag as ct1 join change_tag as ct2 on ct1.ct_rev_id = ct2.ct_log_id;
+-----------+
| ct_rev_id |
+-----------+
|  30108536 |
|  30143166 |
|  30145232 |
|  30145324 |
|  30146089 |
|  30159068 |
|  30163230 |
|  30169115 |
|  30174773 |
|  30197907 |
|  30197966 |
|  30199126 |
|  30222631 |
|  30224471 |
|  30224524 |
|  30225289 |
|  30225297 |
|  30225824 |
|  30250089 |
|  30259500 |
|  30301900 |
|  30332932 |
|  30333599 |
|  30338600 |
|  30354022 |
|  30398151 |
|  30398757 |
|  30400203 |
|  30407296 |
|  30417821 |
|  30454735 |
|  30454939 |
|  30458230 |
|  30459475 |
|  30459572 |
|  30461771 |
|  30486447 |
|  30495826 |
|  30506059 |
|  30564367 |
|  30572685 |
|  30597529 |
|  30610680 |
|  30618526 |
|  30619796 |
|  30651901 |
|  30665939 |
|  30679720 |
|  30706513 |
|  30725638 |
|  30729590 |
|  30729708 |
|  30730406 |
|  30732624 |
|  30734184 |
|  30750325 |
|  30768839 |
|  30774152 |
|  30775013 |
|  30775655 |
|  30775766 |
|  30790570 |
|  32248863 |
|  32248863 |
|  35650230 |
|  40912892 |
|  40912892 |
|  47411934 |
|  47411934 |
|  49704281 |
|  49990281 |
|  49990281 |
|  49993487 |
|  49993487 |
|  50001718 |
|  50009039 |
|  50009402 |
|  50026726 |
|  50034088 |
|  50034218 |
|  50034218 |
|  50035832 |
|  50061661 |
|  50062660 |
|  50074665 |
|  50074665 |
|  50075578 |
|  50075578 |
|  50075578 |
|  50075745 |
|  50075745 |
|  50077030 |
|  50079904 |
|  50081122 |
|  50081122 |
|  50081398 |
|  50081398 |
|  50083093 |
|  50085399 |
|  50086341 |
|  50086774 |
|  50086774 |
|  50088481 |
|  50088481 |
|  50088568 |
|  50088786 |
|  50088786 |
|  50088786 |
|  50096856 |
|  50102448 |
|  50102449 |
|  50115574 |
|  50115574 |
|  50121655 |
|  50121655 |
|  50125821 |
|  50134451 |
|  50134690 |
|  50134807 |
|  50140745 |
|  50143360 |
|  50143935 |
|  50149839 |
|  50151565 |
|  50151565 |
|  50151565 |
|  50157216 |
|  50159616 |
|  50163679 |
|  50163976 |
|  50165894 |
|  50167122 |
|  50167588 |
|  50168129 |
|  50176187 |
|  50177352 |
|  50182809 |
|  50192283 |
|  50192283 |
|  50192283 |
|  50200611 |
|  50204495 |
|  50204495 |
|  50204495 |
|  50211506 |
|  50211506 |
|  50214270 |
|  50217334 |
|  50218151 |
|  50218151 |
|  50221468 |
|  50228922 |
|  50228922 |
|  50228922 |
|  50245718 |
|  50250782 |
|  50250782 |
|  50252254 |
|  50252254 |
|  50253513 |
|  50253513 |
|  50258032 |
|  50258032 |
|  50258032 |
|  50258032 |
|  50260137 |
|  50260137 |
|  50260195 |
|  50270314 |
|  50270336 |
|  50270336 |
|  50271020 |
|  50276621 |
|  50276621 |
|  50277190 |
|  50277190 |
|  50279283 |
|  50285502 |
|  50296685 |
|  50298267 |
|  50299805 |
|  50304408 |
|  50304408 |
|  50304408 |
|  50306911 |
|  50307532 |
|  50307532 |
|  50308802 |
|  50308802 |
|  50309640 |
|  50317232 |
|  50318793 |
|  50318793 |
|  50319370 |
|  50319370 |
|  50319370 |
|  50322184 |
|  50322184 |
|  50322184 |
|  50328507 |
|  50343209 |
|  50348829 |
|  50348829 |
|  50367847 |
|  50370582 |
|  50380855 |
|  50385935 |
|  50385935 |
|  50387594 |
|  50390901 |
|  50390901 |
|  50391760 |
|  50403254 |
|  50403254 |
|  50403266 |
|  50403266 |
|  50405020 |
|  50405020 |
|  50407958 |
|  50407958 |
|  50433968 |
|  50433968 |
|  50434589 |
|  50434589 |
|  50434589 |
|  50445312 |
|  50450425 |
|  50469172 |
|  50469172 |
|  50471570 |
|  50471570 |
|  50472325 |
|  50475596 |
|  50475596 |
|  50475596 |
|  50475624 |
|  50475624 |
|  50486724 |
|  50486724 |
|  50500714 |
|  50511710 |
|  50511710 |
|  50517454 |
|  50520599 |
|  50520599 |
|  50521997 |
|  50521997 |
|  50527065 |
|  50542539 |
|  50543308 |
|  50546830 |
|  50547441 |
|  50547787 |
|  50554231 |
|  50554471 |
|  50554471 |
|  50554508 |
|  50554508 |
|  50559986 |
|  50561315 |
|  50561315 |
+-----------+
261 rows in set (3.99 sec)