git_dev@db3-vip.drupal.org::[5.1.44b-MariaDB-mariadb78-log] (DB: git_dev)> select prn.nid from project_release_nodes prn inner join node np on prn.pid = np.nid INNER JOIN node npr on prn.nid = npr.nid where np.status = 0 and npr.status = 1;
+---------+
| nid     |
+---------+
|   94221 |
|   94235 |
|   94237 |
|   94249 |
|   94250 |
|   94252 |
|   94267 |
|   94292 |
|   94624 |
|   94627 |
|   94645 |
|   94646 |
|   94683 |
|   94311 |
|   94316 |
|   94320 |
|   94346 |
|   94362 |
|   94397 |
|   94400 |
|   94412 |
|   94425 |
|   94438 |
|   94454 |
|   94470 |
|   94473 |
|   94481 |
|   94502 |
|   94505 |
|   94537 |
|   94541 |
|   94546 |
|   94549 |
|   94772 |
|   94788 |
|   94834 |
|   94861 |
|   94863 |
|   94864 |
|   94878 |
|   94967 |
|   95162 |
|   95164 |
|   95165 |
|  126673 |
|   95234 |
|   95236 |
|   95299 |
|   95301 |
|   95382 |
|   95384 |
|   95520 |
|   95521 |
|   95552 |
|   95553 |
|   95658 |
|   95665 |
|   95666 |
|   95674 |
|   95675 |
|   95779 |
|   95993 |
|   95994 |
|   95995 |
|   96577 |
|  105628 |
|  105637 |
|  105674 |
|  106893 |
|  106894 |
|  128464 |
|   96665 |
|  108546 |
|  108588 |
|  108589 |
|  108590 |
|  108904 |
|  108905 |
|  109544 |
|  109545 |
|  116104 |
|  117098 |
|  117100 |
|  119354 |
|  119355 |
|   96707 |
|   96708 |
|   96774 |
|   96852 |
|  100976 |
|  111237 |
|  119217 |
|  127380 |
|  114668 |
|  117488 |
|  118671 |
|  119575 |
|  190612 |
|  121423 |
|  122487 |
|  124709 |
|  187666 |
|  220799 |
|  307245 |
|  330338 |
|  188470 |
|  220800 |
|  330340 |
|  217004 |
|  218316 |
|  324541 |
|  303831 |
|  304577 |
|  304636 |
|  306196 |
|  306261 |
|  306266 |
|  316577 |
|  307076 |
|  318924 |
|  344751 |
|  344756 |
|  360918 |
|  360924 |
|  361910 |
|  369762 |
|  370678 |
|  374746 |
|  372819 |
|  375308 |
|  375309 |
|  387572 |
|  413564 |
|  417636 |
|  417638 |
|  771026 |
|  459892 |
|  466038 |
|  465328 |
|  469582 |
|  491554 |
|  503828 |
|  504406 |
|  504968 |
|  508946 |
|  523262 |
|  524848 |
|  504978 |
|  505022 |
|  508900 |
|  508464 |
|  508916 |
|  596452 |
|  645872 |
|  761036 |
|  802070 |
|  815910 |
|  815982 |
|  901340 |
| 1030026 |
+---------+
160 rows in set (0.11 sec)