While building queries for syncing projects and releases from drupal.org to localize.drupal.org, I found out that a huge number of projects lack any release whatsoever. Don't know whether this requires any action, but figured it is best to share. While we have 5580 projects on drupal.org, 609 of them lack any release (even development snapshot release!).
mysql> select pp.nid, pp.uri from project_projects pp left join project_release_nodes prn on pp.nid = prn.pid WHERE prn.nid IS NULL;
+--------+-------------------------------+
| nid | uri |
+--------+-------------------------------+
| 3202 | webmasters |
| 3213 | user_experience |
| 3313 | _title |
| 6787 | locale_switcher |
| 9801 | dkos |
| 10672 | flashtheme |
| 11687 | joepilot |
| 11987 | swish-e |
| 12014 | perf |
| 12191 | metadata |
| 12242 | maillist |
| 12916 | linemanblue |
| 13016 | keyword |
| 13258 | blogthis |
| 13514 | serbian |
| 13530 | pushbuttonPHP |
| 13548 | uptime |
| 13952 | kubrick |
| 14344 | brazilian |
| 14410 | inset_paragraphs |
| 14513 | Drupal-fa |
| 14537 | homepage |
| 14779 | user_nodelist |
| 15305 | bluemarine-phptemplate |
| 15489 | valenciano |
| 16206 | R_M_Replacer |
| 16264 | email-feedback-form |
| 16799 | pastorale |
| 17729 | todos |
| 17798 | dropdown_taxonomy |
| 18044 | agent |
| 18753 | documentation |
| 22172 | Bluesmoke |
| 23132 | TL |
| 23214 | groundswell |
| 23769 | stage0 |
| 23818 | pb_script |
| 23864 | druflower |
| 24086 | translate-drupal-ad |
| 24692 | whalemail |
| 25568 | htmlpage |
| 25594 | taxonomy_flash |
| 25657 | EmailSearch |
| 25693 | portfolio |
| 25695 | happenig |
| 25842 | event_archive |
| 26160 | journal_nobody_ever_cared |
| 26341 | taxonomytabs |
| 26608 | sysinfo |
| 26877 | Lt460 |
| 27698 | nuke2drupal |
| 27952 | teleauth |
| 28068 | imapauth |
| 28129 | migration2 |
| 28725 | taxonomytree |
| 28940 | weblink_browswer |
| 29375 | teltrans |
| 29464 | mailcrypt |
| 29530 | new_flexinode |
| 29537 | geotags |
| 29955 | soundpower |
| 30168 | client_portal |
| 30251 | podcast |
| 30314 | prupal |
| 30672 | tree |
| 30991 | imp |
| 31073 | tagcloud |
| 32060 | googlemapsfornodes |
| 32402 | shift_signup |
| 39303 | simpy |
| 41205 | GeSHi |
| 41718 | RTLthemes |
| 42964 | taxonomy_text |
| 43378 | worldpay |
| 45042 | anchor |
| 45679 | smiletag |
| 47025 | Project_explore_drupal |
| 47627 | img |
| 47891 | TDTLP |
| 48925 | qrios_theme_1 |
| 49001 | simpleshell |
| 49399 | WebEx |
| 49784 | xvwiki |
| 50946 | sql_auth |
| 52243 | Aclide |
| 52493 | siriusc_theme |
| 52587 | googleearth |
| 56549 | image_maxsize |
| 56898 | JunxterClassifieds |
| 56960 | convert_utf8 |
| 57357 | metrix |
| 58314 | locatebygmap |
| 63769 | htmlnodeemailaction |
| 64041 | ModuleFetcher |
| 65545 | getdrupal |
| 67375 | location_views |
| 69881 | summerholiday |
| 69882 | voodoo_dolly |
| 69939 | candy_corn |
| 70362 | raw |
| 70602 | solemnity |
| 70604 | typography_paramount |
| 70704 | gunmetal |
| 70718 | wordprocessing |
| 73479 | clementine |
| 73483 | mini_blog |
| 73488 | plain2 |
| 74224 | lunarphase |
| 77248 | ur |
| 78633 | fintrans |
| 78690 | newsportal |
| 78691 | uncomplicated |
| 78692 | deliciously_blue |
| 82931 | blaknwite |
| 83371 | 1024_v |
| 89091 | jetpacked01 |
| 92471 | tinymce_adv |
| 98841 | showcase |
| 100000 | jquery_tools |
| 100010 | voodooR |
| 101765 | order |
| 101770 | pay |
| 101834 | dia |
| 102084 | slide_menus |
| 102916 | clubindex |
| 103482 | sandbox |
| 103494 | formdraft |
| 103679 | chemical |
| 104721 | profile-ng |
| 105999 | blogringhu |
| 106201 | synth_products |
| 106738 | fileapi |
| 107028 | infrastructure |
| 108519 | contest |
| 108644 | transformer |
| 110595 | ha |
| 110596 | ak |
| 110597 | yo |
| 110814 | MailingList |
| 112006 | hr |
| 113245 | meter |
| 115216 | classifiQ |
| 115388 | SimpleCommerce |
| 115525 | simplyblack |
| 117694 | spaw |
| 118379 | neighbours |
| 118780 | jquery |
| 120060 | ventrilo_status |
| 120566 | download_access |
| 121369 | corei18n |
| 123059 | phpwind |
| 124253 | fa5 |
| 126212 | czechprofile |
| 127119 | rest |
| 129070 | threetone-white |
| 129628 | uz-uz |
| 130278 | droop |
| 130292 | drupal_hub |
| 131655 | views_json |
| 131858 | foreigner |
| 131881 | offload |
| 135601 | pressflow_multidomain |
| 137766 | crm |
| 137773 | watch |
| 139395 | fckeditor_plus |
| 139571 | person |
| 140322 | includer |
| 143170 | norwegian_profile |
| 146407 | ban_users_assist |
| 150477 | calnet |
| 151337 | related_content |
| 151395 | logos |
| 152075 | embed |
| 153700 | agaric_starter |
| 154234 | drupaled |
| 155156 | level1 |
| 157420 | pmp |
| 157448 | warcraft_itemstats |
| 159787 | xcasetracker |
| 160212 | post2blogs |
| 161931 | hyperglass |
| 164973 | projectManagement |
| 164991 | og_translate |
| 165033 | og_hierarchy |
| 165078 | PayJunction |
| 168071 | ebay |
| 168400 | yaml |
| 169923 | hier |
| 170619 | slfeed |
| 172568 | ui |
| 173097 | form_wizard |
| 173178 | class |
| 173189 | class_journal |
| 173201 | class_assignment |
| 173210 | class_note |
| 173228 | class_portfolio |
| 173233 | class_syllabus |
| 173552 | repository |
| 173574 | signal |
| 174076 | kkeyboard |
| 174249 | xen |
| 174854 | dz_code_paste |
| 174928 | facebook_app |
| 176172 | gamabhana |
| 176635 | adaptive_context |
| 176637 | ac_access |
| 176639 | ac_group |
| 176642 | jqselect |
| 177577 | cynergy_payment |
| 178513 | facebook_api |
| 178540 | mk |
| 178714 | site |
| 178893 | Drupaltestbed |
| 178960 | extended |
| 179140 | imscp |
| 181819 | themefactory |
| 182139 | xcache |
| 183188 | moderator |
| 184212 | event_notification |
| 185188 | drupalorg |
| 187420 | place |
| 187487 | builder |
| 187864 | aapi |
| 188997 | emspace |
| 189261 | emspace_code |
| 190597 | emspace_2007 |
| 192985 | newsletter |
| 195177 | javab |
| 196656 | opt-in |
| 196764 | cvs_demo |
| 197080 | event_GCalendar |
| 197195 | ghop |
| 198247 | tumblr |
| 199690 | a_blueprint |
| 201546 | drupal_kata |
| 202000 | drupalmu |
| 202769 | subtitle |
| 204496 | ffmpeg |
| 205156 | convert2drupal |
| 205540 | holidays |
| 206743 | ku |
| 207010 | aws |
| 207409 | admin_notes |
| 207601 | txn_currency |
| 209468 | eugens-web-10 |
| 210482 | berlin |
| 211391 | so_KU |
| 211542 | arc_rdf_store |
| 212677 | opensocial |
| 214739 | mm_flvtool2 |
| 215164 | eugens-web-11 |
| 215327 | DROP |
| 216557 | d-otrs |
| 217954 | credit |
| 218341 | ms-MY |
| 218583 | travelmap |
| 218840 | jalali |
| 219895 | ec2 |
| 220173 | amazon_aws |
| 220481 | calais |
| 221322 | clients |
| 222432 | sesame |
| 225628 | image_app |
| 226834 | taxonomy_pages |
| 226835 | taxonomy_book |
| 228309 | sets |
| 228601 | config_diff |
| 230155 | assignment_studio |
| 230478 | awesome_install |
| 231443 | css_sprites |
| 233019 | simpletest_unit |
| 234658 | knight |
| 238579 | heywatch |
| 239083 | jquery_popupwindow |
| 239258 | verse |
| 239504 | mail_metrics |
| 240195 | jqmodal |
| 241019 | golfpal |
| 241586 | seep |
| 242194 | sso_multidb |
| 242704 | flashblock |
| 243187 | userpoints_lite |
| 243300 | jquery_blockui |
| 243692 | taxtractor |
| 243694 | timetracker |
| 244246 | easyBlast |
| 244584 | textmate |
| 245777 | vertica |
| 245957 | devel_node_access |
| 247045 | jqgalview |
| 248187 | urltaxoselector |
| 249806 | digest |
| 250675 | opensocial-container |
| 251267 | seesmic |
| 253327 | element_marker |
| 253541 | messenger |
| 253546 | img_filter |
| 253549 | ip_locator |
| 253624 | versioncontrol_soc08 |
| 253749 | uc_review |
| 255163 | payment_api |
| 255167 | node_fee |
| 257266 | oauth_services |
| 258210 | charts_soc2008 |
| 258522 | instruction_designer |
| 258870 | innerfade |
| 260796 | siege |
| 262318 | lucene |
| 262319 | eventbrite |
| 262997 | Adab |
| 265032 | og_limits |
| 265167 | hylafax |
| 265178 | newsengine |
| 265596 | user_restrictions |
| 265697 | field |
| 265712 | geo_planet_api |
| 268067 | fireeagle |
| 269636 | refcolab |
| 269731 | maps |
| 269945 | trust_network |
| 272295 | broccoli |
| 272664 | comment_replies |
| 272788 | language_extras |
| 273314 | eugens-web-14 |
| 274332 | criteria_rating |
| 276600 | persiandate |
| 279719 | autotaxonomy |
| 280540 | traclinks |
| 280693 | payflow |
| 280699 | countries |
| 280942 | samizdat |
| 281335 | nodegooglemap |
| 282424 | highlighter |
| 282496 | uc_affiliate |
| 283688 | python_services |
| 284071 | cck_schema_protector |
| 285055 | sprite |
| 286291 | flash_portfolio |
| 286521 | Haitian_creole_Localization |
| 286947 | graph |
| 287933 | basic_adsense_injecter |
| 287934 | js_menu |
| 288180 | scald |
| 289057 | nodes |
| 289409 | potluck |
| 290081 | metaformatter |
| 290308 | openspace |
| 290774 | rw |
| 290862 | BlueSkyDay |
| 291086 | project_access |
| 291102 | media_player |
| 291104 | openlaszlo |
| 291673 | votesmart |
| 292857 | mailman_groups |
| 297497 | vnc_reflector |
| 297578 | uc_ideal |
| 298888 | walkthrough |
| 299083 | floating_block |
| 299114 | autovar |
| 301232 | redhot |
| 301918 | ec2ami |
| 303199 | eyespot |
| 303797 | guestnode |
| 304821 | dynamic_matrix |
| 305141 | prevent_edit |
| 305149 | cck_builder |
| 306669 | nodeadelic |
| 306860 | project_management |
| 307308 | panels_user |
| 309002 | openmicroblogging |
| 309310 | geoproximity |
| 310022 | views_translate |
| 310606 | aggregator_filter |
| 312352 | fooapi |
| 312568 | mirror |
| 313184 | user_availability |
| 314142 | osflv |
| 316516 | drupal_gem |
| 316825 | wicketpixie |
| 317098 | sussex |
| 318995 | cdm_dataportal |
| 319068 | friend |
| 319071 | rlisting |
| 319074 | notice |
| 319243 | vps_api |
| 320340 | yahoo_analytics |
| 320799 | ajax_validation |
| 322309 | drupal_universal_relation_api |
| 323428 | cheapid |
| 323905 | openpublish |
| 323938 | evolution |
| 324145 | acrobat_connect |
| 324166 | results |
| 324248 | set4d |
| 324663 | visitor |
| 324760 | brainfsck |
| 324903 | mybb |
| 326898 | zws |
| 327403 | imgtax |
| 329593 | openid_service |
| 331373 | iss |
| 331495 | draggable_blocks |
| 331743 | userprofile |
| 334930 | AlumniDrupal |
| 335026 | ideal_payment_api |
| 336123 | popout |
| 338092 | forum_support |
| 338147 | eugens_blue |
| 339589 | games |
| 341239 | extra_RSS_fields |
| 342506 | fernest |
| 344626 | tapatio_installation_profile |
| 348888 | videocomment |
| 352104 | simplenews_sub_manager |
| 356238 | image_annotation |
| 358382 | atom_views |
| 359290 | createcontent |
| 359977 | generic_timesheet |
| 360257 | storylink |
| 360418 | leaguesite |
| 360874 | ec_useracc |
| 362200 | iphone |
| 365186 | media_youtube |
| 365624 | mosaic |
| 365921 | xbox_api |
| 367161 | ps_wapi |
| 367166 | bs_wapi |
| 367233 | simplenews_bounce |
| 369703 | versioncontrol_bzr |
| 369868 | drupal_im |
| 370091 | studyabroad |
| 370466 | popularity |
| 373687 | word_import |
| 374929 | time |
| 375670 | book_navigation_tweak |
| 375754 | access_center |
| 376251 | kgp |
| 376954 | content_compose |
| 377172 | time_qb |
| 381292 | materialized_view |
| 381746 | domain_relationships |
| 384804 | twittergator |
| 384964 | course_manager |
| 388202 | node_cluster |
| 389134 | uc_civicrm |
| 393242 | f1 |
| 395750 | linkman |
| 399880 | rubric |
| 400680 | almanac |
| 402960 | taxonomy_select |
| 407354 | pedaltracker |
| 407536 | BasicRed |
| 409132 | sharepal |
| 410734 | dataimport |
| 413940 | gprovisioning |
| 414676 | custom_filters |
| 414682 | openband |
| 415132 | cas_register_invite |
| 415206 | word_clouds |
| 417436 | airborne |
| 420600 | openid_extensions |
| 420798 | biz |
| 421198 | apachesolr_views |
| 423700 | interface |
| 425724 | simplegmap |
| 425738 | hapi |
| 426346 | testlistener |
| 427606 | vcalendar |
| 428254 | smartphone_theme |
| 430826 | freerte |
| 431694 | package-management |
| 431770 | xs_activity |
| 432272 | logger |
| 432310 | anycache |
| 435146 | mossocloud |
| 438514 | protection |
| 438932 | druplog |
| 439052 | jobs |
| 440026 | budget |
| 440062 | contribution |
| 441240 | dynamicsearch |
| 442226 | classify |
| 442344 | or |
| 442594 | ppd2sfl |
| 443370 | o3d |
| 444262 | travian_guild |
| 446618 | mailto_filter |
| 446640 | analytics |
| 447092 | flowplayer_simple |
| 448658 | smartqueue_for_path |
| 452138 | rmes |
| 452674 | snowforecast |
| 460654 | mailbuilder |
| 464098 | imceimage_crop |
| 465292 | commentblock |
| 466298 | mods_editor |
| 467488 | peerreview |
| 467852 | solr_service |
| 468140 | formtweak |
| 468576 | domain_locale |
| 468606 | domain_i18n |
| 468902 | comment_manager |
| 470528 | travian |
| 471508 | arphp |
| 471786 | riat |
| 472472 | liteforum |
| 473692 | google_analytics_api |
| 474392 | userpoints_pay_per_view |
| 475166 | lao |
| 475938 | acquia_prosper |
| 476584 | adlib |
| 477626 | wave |
| 478374 | ka |
| 479454 | user_board_activity |
| 479456 | user_board_userpoints |
| 479460 | user_board_views |
| 482338 | content_importer |
| 482860 | drupalgapps |
| 483048 | dixerit |
| 483164 | voucher_field |
| 484104 | dbfmsearch |
| 484786 | conditions |
| 485984 | schoolreport |
| 485998 | stuffcounter |
| 487332 | sync |
| 487714 | agora |
| 487796 | coupon |
| 488074 | EVM |
| 488910 | ro2 |
| 489462 | reservations |
| 489832 | apachesolr_autotrack |
| 490140 | structdisplay |
| 490180 | structontology |
| 490866 | oembed |
| 491450 | simple_committer |
| 491468 | arclite |
| 495466 | gis |
| 496144 | webform_validate |
| 498536 | uc_print_shop |
| 499042 | rdfproxy |
| 499234 | luceneapi_multisite |
| 499314 | devavrata_theme |
| 499704 | drupalptbr |
| 500112 | video23 |
| 502508 | luceneui |
| 503034 | e_book |
| 504292 | cypherpunk |
| 505292 | googlebase |
| 505536 | dibs |
| 507654 | placemaker |
| 507904 | eid |
| 507960 | sparql_ep |
| 509608 | sparcool |
| 509702 | research |
| 511836 | redirect_external_links |
| 511884 | typography |
| 516392 | og_schedule |
| 516764 | online_subscription |
| 516766 | cck_list |
| 517162 | sugarondrupal |
| 517754 | webservicesapi |
| 517910 | diet |
| 519106 | bacon |
| 521928 | udlocomap |
| 521938 | udplanet |
| 523098 | community_tasks |
| 524478 | pwn |
| 524546 | quick_filter |
| 524810 | background |
| 525024 | vitatiasunset |
| 525870 | idthemes |
| 525904 | idt001 |
| 525912 | cvsapplications |
| 525922 | idt001_01 |
| 525926 | idt001_02 |
| 525930 | idt001_03 |
| 525938 | idt002 |
| 525944 | idt002_01 |
| 525950 | idt002_02 |
| 525954 | idt002_03 |
| 525958 | idt002_04 |
| 525962 | idt002_05 |
| 525966 | idt002_06 |
| 525970 | idt002_07 |
| 525974 | idt002_08 |
| 525978 | idt002_09 |
| 525984 | idt002_10 |
| 525988 | idt002_11 |
| 525994 | idt002_12 |
| 526002 | idt002_13 |
| 526216 | idt011 |
| 526230 | idt011_01 |
| 526258 | idt011_02 |
| 526270 | idt011_03 |
| 526276 | idt011_04 |
| 526286 | idt011_05 |
| 526290 | idt011_06 |
| 526294 | idt011_07 |
| 526532 | idt012 |
| 526596 | vr |
| 529142 | drush_make |
| 529616 | drupalui |
| 530450 | uc_image_product |
| 532072 | classroom |
| 532220 | unfuddle_api |
| 532322 | attachment_expiration |
| 532970 | profile_access |
| 532982 | filehash |
| 533062 | active_taxonomy_links |
+--------+-------------------------------+
609 rows in set (0.04 sec)
Comments
Comment #1
avpadernoIf site maintainers decide to take any action on those projects, is it possible to get the email of the author without to proceed manually?
This would help in the case we want to send an email to the author.
Comment #2
gdemetMan, there's some good namespaces reserved there - I have very high expectations for http://drupal.org/project/bacon
I would advise against taking any unilateral action against these projects; some of them appear to be reserved spaces for upcoming projects that we know are happening, like http://drupal.org/project/acquia_prosper ; others are projects that for whatever reason never got off the ground or were abandoned. It might be good to have some sort of rule of thumb that if you start a project and don't make any commits to it after a certain amount of time (I don't know what's reasonable: 3 months, 6 months, a year?), then the project is considered abandoned and the name space can be taken by someone else.
Comment #3
dave reidNow if you would have included n.status, that would have been useful too, because I think the list would have been reduced signifigantly.
Comment #4
gábor hojtsyI did not intend to suggest any wholesale action either. Rather I thought this data might be important for a number of reasons:
- What's so hard about contributing to Drupal that 609 of 5580 projects (over 10%) never had a release?
- Are there patterns of people using projects to advertise other sites/companies and not actually releasing code (in the wake of the idt* themes seen above, which recently spurred a big discussion).
- Are people interested in taking on worthwile but stalled projects like (just judging from their names) word_import or walkthrough.
Comment #5
gábor hojtsyWell, it is 456 projects, if we remove the unpublished ones:
Comment #6
avpadernoThat is a module I am developing. I didn't completely commit its code because I am trying to release a beta release of Meta tags first.
I committed that code because I am miles away from home, and I thought I could have the time to develop new code in the 2 months I was away.
Comment #7
gerhard killesreiter commentedCan I have the query that you used?
Comment #8
avpadernoWould not it better to remove from the result those projects that have been created only recently? Differently, you are going to get also the ones that have been created not later than one month ago, and you would put them at the same level of projects created one year ago.
Comment #9
gábor hojtsyThe query:
select pp.nid, pp.uri from project_projects pp left join project_release_nodes prn on pp.nid = prn.pid left join node n on n.nid = pp.nid WHERE prn.nid IS NULL and n.status = 1;
Comment #10
gerhard killesreiter commentedI've modified to include only the projects that have been created a year ago and added a nice little GUI. ;)
I guess we should ad least look at these and create issues in their queues and then unpublish them if no releases are forthcoming. There are a few translations among these, I already created issues for them a week ago.
mysql> select concat('http://drupal.org/node/', pp.nid), pp.uri from project_projects pp left join project_release_nodes prn on pp.nid = prn.pid left join node n on n.nid = pp.nid WHERE prn.nid IS NULL and n.status = 1 and from_unixtime(n.created) < '2008-08-01 00:00:00';
+-------------------------------------------+-----------------------------+
| concat('http://drupal.org/node/', pp.nid) | uri |
+-------------------------------------------+-----------------------------+
| http://drupal.org/node/3202 | webmasters |
| http://drupal.org/node/6787 | locale_switcher |
| http://drupal.org/node/16799 | pastorale |
| http://drupal.org/node/17729 | todos |
| http://drupal.org/node/18044 | agent |
| http://drupal.org/node/18753 | documentation |
| http://drupal.org/node/25693 | portfolio |
| http://drupal.org/node/43378 | worldpay |
| http://drupal.org/node/50946 | sql_auth |
| http://drupal.org/node/65545 | getdrupal |
| http://drupal.org/node/67375 | location_views |
| http://drupal.org/node/70718 | wordprocessing |
| http://drupal.org/node/74224 | lunarphase |
| http://drupal.org/node/77248 | ur |
| http://drupal.org/node/89091 | jetpacked01 |
| http://drupal.org/node/98841 | showcase |
| http://drupal.org/node/101765 | order |
| http://drupal.org/node/101770 | pay |
| http://drupal.org/node/101834 | dia |
| http://drupal.org/node/102084 | slide_menus |
| http://drupal.org/node/102916 | clubindex |
| http://drupal.org/node/103482 | sandbox |
| http://drupal.org/node/103494 | formdraft |
| http://drupal.org/node/103679 | chemical |
| http://drupal.org/node/104721 | profile-ng |
| http://drupal.org/node/105999 | blogringhu |
| http://drupal.org/node/106201 | synth_products |
| http://drupal.org/node/106738 | fileapi |
| http://drupal.org/node/107028 | infrastructure |
| http://drupal.org/node/108519 | contest |
| http://drupal.org/node/108644 | transformer |
| http://drupal.org/node/110595 | ha |
| http://drupal.org/node/110596 | ak |
| http://drupal.org/node/110597 | yo |
| http://drupal.org/node/110814 | MailingList |
| http://drupal.org/node/112006 | hr |
| http://drupal.org/node/113245 | meter |
| http://drupal.org/node/115216 | classifiQ |
| http://drupal.org/node/115388 | SimpleCommerce |
| http://drupal.org/node/115525 | simplyblack |
| http://drupal.org/node/117694 | spaw |
| http://drupal.org/node/118379 | neighbours |
| http://drupal.org/node/120060 | ventrilo_status |
| http://drupal.org/node/120566 | download_access |
| http://drupal.org/node/121369 | corei18n |
| http://drupal.org/node/123059 | phpwind |
| http://drupal.org/node/127119 | rest |
| http://drupal.org/node/129070 | threetone-white |
| http://drupal.org/node/129628 | uz-uz |
| http://drupal.org/node/130292 | drupal_hub |
| http://drupal.org/node/131655 | views_json |
| http://drupal.org/node/131858 | foreigner |
| http://drupal.org/node/131881 | offload |
| http://drupal.org/node/135601 | pressflow_multidomain |
| http://drupal.org/node/137766 | crm |
| http://drupal.org/node/137773 | watch |
| http://drupal.org/node/139571 | person |
| http://drupal.org/node/140322 | includer |
| http://drupal.org/node/143170 | norwegian_profile |
| http://drupal.org/node/150477 | calnet |
| http://drupal.org/node/151337 | related_content |
| http://drupal.org/node/152075 | embed |
| http://drupal.org/node/153700 | agaric_starter |
| http://drupal.org/node/154234 | drupaled |
| http://drupal.org/node/155156 | level1 |
| http://drupal.org/node/157420 | pmp |
| http://drupal.org/node/157448 | warcraft_itemstats |
| http://drupal.org/node/159787 | xcasetracker |
| http://drupal.org/node/160212 | post2blogs |
| http://drupal.org/node/161931 | hyperglass |
| http://drupal.org/node/164973 | projectManagement |
| http://drupal.org/node/164991 | og_translate |
| http://drupal.org/node/165033 | og_hierarchy |
| http://drupal.org/node/165078 | PayJunction |
| http://drupal.org/node/168071 | ebay |
| http://drupal.org/node/169923 | hier |
| http://drupal.org/node/170619 | slfeed |
| http://drupal.org/node/172568 | ui |
| http://drupal.org/node/173178 | class |
| http://drupal.org/node/173189 | class_journal |
| http://drupal.org/node/173201 | class_assignment |
| http://drupal.org/node/173210 | class_note |
| http://drupal.org/node/173228 | class_portfolio |
| http://drupal.org/node/173233 | class_syllabus |
| http://drupal.org/node/173552 | repository |
| http://drupal.org/node/173574 | signal |
| http://drupal.org/node/174076 | kkeyboard |
| http://drupal.org/node/174249 | xen |
| http://drupal.org/node/174854 | dz_code_paste |
| http://drupal.org/node/174928 | facebook_app |
| http://drupal.org/node/176635 | adaptive_context |
| http://drupal.org/node/176637 | ac_access |
| http://drupal.org/node/176639 | ac_group |
| http://drupal.org/node/176642 | jqselect |
| http://drupal.org/node/177577 | cynergy_payment |
| http://drupal.org/node/178513 | facebook_api |
| http://drupal.org/node/178540 | mk |
| http://drupal.org/node/178714 | site |
| http://drupal.org/node/178893 | Drupaltestbed |
| http://drupal.org/node/178960 | extended |
| http://drupal.org/node/179140 | imscp |
| http://drupal.org/node/181819 | themefactory |
| http://drupal.org/node/182139 | xcache |
| http://drupal.org/node/183188 | moderator |
| http://drupal.org/node/184212 | event_notification |
| http://drupal.org/node/185188 | drupalorg |
| http://drupal.org/node/187420 | place |
| http://drupal.org/node/187487 | builder |
| http://drupal.org/node/187864 | aapi |
| http://drupal.org/node/188997 | emspace |
| http://drupal.org/node/189261 | emspace_code |
| http://drupal.org/node/190597 | emspace_2007 |
| http://drupal.org/node/192985 | newsletter |
| http://drupal.org/node/195177 | javab |
| http://drupal.org/node/196656 | opt-in |
| http://drupal.org/node/196764 | cvs_demo |
| http://drupal.org/node/197080 | event_GCalendar |
| http://drupal.org/node/197195 | ghop |
| http://drupal.org/node/198247 | tumblr |
| http://drupal.org/node/201546 | drupal_kata |
| http://drupal.org/node/202000 | drupalmu |
| http://drupal.org/node/202769 | subtitle |
| http://drupal.org/node/204496 | ffmpeg |
| http://drupal.org/node/205156 | convert2drupal |
| http://drupal.org/node/205540 | holidays |
| http://drupal.org/node/206743 | ku |
| http://drupal.org/node/207010 | aws |
| http://drupal.org/node/207409 | admin_notes |
| http://drupal.org/node/207601 | txn_currency |
| http://drupal.org/node/209468 | eugens-web-10 |
| http://drupal.org/node/210482 | berlin |
| http://drupal.org/node/211391 | so_KU |
| http://drupal.org/node/211542 | arc_rdf_store |
| http://drupal.org/node/212677 | opensocial |
| http://drupal.org/node/214739 | mm_flvtool2 |
| http://drupal.org/node/215164 | eugens-web-11 |
| http://drupal.org/node/215327 | DROP |
| http://drupal.org/node/216557 | d-otrs |
| http://drupal.org/node/217954 | credit |
| http://drupal.org/node/218583 | travelmap |
| http://drupal.org/node/218840 | jalali |
| http://drupal.org/node/219895 | ec2 |
| http://drupal.org/node/220173 | amazon_aws |
| http://drupal.org/node/220481 | calais |
| http://drupal.org/node/221322 | clients |
| http://drupal.org/node/222432 | sesame |
| http://drupal.org/node/225628 | image_app |
| http://drupal.org/node/226834 | taxonomy_pages |
| http://drupal.org/node/226835 | taxonomy_book |
| http://drupal.org/node/228309 | sets |
| http://drupal.org/node/230155 | assignment_studio |
| http://drupal.org/node/230478 | awesome_install |
| http://drupal.org/node/231443 | css_sprites |
| http://drupal.org/node/233019 | simpletest_unit |
| http://drupal.org/node/234658 | knight |
| http://drupal.org/node/238579 | heywatch |
| http://drupal.org/node/239083 | jquery_popupwindow |
| http://drupal.org/node/239258 | verse |
| http://drupal.org/node/239504 | mail_metrics |
| http://drupal.org/node/240195 | jqmodal |
| http://drupal.org/node/241019 | golfpal |
| http://drupal.org/node/241586 | seep |
| http://drupal.org/node/242194 | sso_multidb |
| http://drupal.org/node/242704 | flashblock |
| http://drupal.org/node/243300 | jquery_blockui |
| http://drupal.org/node/243692 | taxtractor |
| http://drupal.org/node/243694 | timetracker |
| http://drupal.org/node/244246 | easyBlast |
| http://drupal.org/node/244584 | textmate |
| http://drupal.org/node/245777 | vertica |
| http://drupal.org/node/247045 | jqgalview |
| http://drupal.org/node/248187 | urltaxoselector |
| http://drupal.org/node/249806 | digest |
| http://drupal.org/node/250675 | opensocial-container |
| http://drupal.org/node/251267 | seesmic |
| http://drupal.org/node/253327 | element_marker |
| http://drupal.org/node/253541 | messenger |
| http://drupal.org/node/253546 | img_filter |
| http://drupal.org/node/253549 | ip_locator |
| http://drupal.org/node/253624 | versioncontrol_soc08 |
| http://drupal.org/node/253749 | uc_review |
| http://drupal.org/node/255163 | payment_api |
| http://drupal.org/node/255167 | node_fee |
| http://drupal.org/node/257266 | oauth_services |
| http://drupal.org/node/258210 | charts_soc2008 |
| http://drupal.org/node/258522 | instruction_designer |
| http://drupal.org/node/258870 | innerfade |
| http://drupal.org/node/260796 | siege |
| http://drupal.org/node/262318 | lucene |
| http://drupal.org/node/262319 | eventbrite |
| http://drupal.org/node/262997 | Adab |
| http://drupal.org/node/265032 | og_limits |
| http://drupal.org/node/265167 | hylafax |
| http://drupal.org/node/265178 | newsengine |
| http://drupal.org/node/265596 | user_restrictions |
| http://drupal.org/node/265697 | field |
| http://drupal.org/node/265712 | geo_planet_api |
| http://drupal.org/node/268067 | fireeagle |
| http://drupal.org/node/269636 | refcolab |
| http://drupal.org/node/269731 | maps |
| http://drupal.org/node/272664 | comment_replies |
| http://drupal.org/node/272788 | language_extras |
| http://drupal.org/node/273314 | eugens-web-14 |
| http://drupal.org/node/274332 | criteria_rating |
| http://drupal.org/node/276600 | persiandate |
| http://drupal.org/node/279719 | autotaxonomy |
| http://drupal.org/node/280540 | traclinks |
| http://drupal.org/node/280693 | payflow |
| http://drupal.org/node/280942 | samizdat |
| http://drupal.org/node/281335 | nodegooglemap |
| http://drupal.org/node/282424 | highlighter |
| http://drupal.org/node/282496 | uc_affiliate |
| http://drupal.org/node/283688 | python_services |
| http://drupal.org/node/285055 | sprite |
| http://drupal.org/node/286291 | flash_portfolio |
| http://drupal.org/node/286521 | Haitian_creole_Localization |
| http://drupal.org/node/286947 | graph |
| http://drupal.org/node/287933 | basic_adsense_injecter |
| http://drupal.org/node/287934 | js_menu |
| http://drupal.org/node/288180 | scald |
| http://drupal.org/node/289057 | nodes |
| http://drupal.org/node/289409 | potluck |
| http://drupal.org/node/319071 | rlisting |
| http://drupal.org/node/319074 | notice |
+-------------------------------------------+-----------------------------+
224 rows in set (0.04 sec)
Comment #11
avpadernoThere is a project I would put a light on: Drupal webmasters. Who is going to contact the maintainer of that project to ask if his project is still maintained? ;-)
Jokes apart, the list is better, now. The list contains now just 224 projects.
Would it possible to get the list ordered by the time the projects have been created? It would be useful to have the older projects first in the list (if we are going to do anything with that list, we could be interested in take care of the oldest projects first).
Maybe some other information could be used.
Comment #12
gerhard killesreiter commentedOldest first.
I guess we can ask people to do sets of 10.
Comment #13
gerhard killesreiter commentedConsidering that the projects had no releases for a year, I propose a simplified process:
1) look if there are more recent cvs commits
1a) if yes: create issue asking them to create a release, proceed as normal.
1b) if not: unpublish
Comment #14
avpadernoI am marking this support request as fixed because it has been already replied. It doesn't seem the task of marking those projects as unpublished has been done, though.