« Overlap between UM and UMBS Herbariums | Main | Installing PostGIS and Postgres on Ubuntu »

March 30, 2011

Adding stable file download links to the Research Bibliography - Part 1

I would like to add a stable link from our bibliographic entries to pdf downloads that DeepBlue has available. The first step in this process is to determine how many of our publications they actually have record of. I am sending them the title, year, journal and first author information for our publications so that they can run a quick-n-dirty match.

Here's the SQL statement I used to pull the information from the database:


SELECT drupal_node.nid,drupal_biblio.biblio_citekey, drupal_biblio.biblio_year, drupal_biblio_contributor_data.lastname, drupal_biblio_contributor_data.firstname, drupal_node.title, drupal_biblio.biblio_secondary_title
FROM `drupal_node`
LEFT JOIN drupal_biblio ON drupal_biblio.nid = drupal_node.nid
LEFT JOIN drupal_biblio_contributor ON drupal_biblio_contributor.nid = drupal_biblio.nid
LEFT JOIN drupal_biblio_contributor_data ON drupal_biblio_contributor_data.cid = drupal_biblio_contributor.cid
WHERE drupal_node.type = 'biblio'
AND drupal_biblio_contributor.rank = '0'
ORDER BY drupal_biblio.biblio_year DESC

OK, for whatever d@mn reason, the above query breaks when I run it on ITS servers (but not on my dev machine). The strangest part is that the query runs but when I go to export query through PHPMyAdmin it breaks and I end up exporting the FROM table. The problem, apparently, is the WHERE statement because the export works as expected without it. The following is what I used on ITS servers:


SELECT drupal_biblio.nid,drupal_biblio.biblio_citekey, drupal_biblio.biblio_year, drupal_node.title, drupal_biblio_contributor_data.lastname, drupal_biblio_contributor.rank

FROM drupal_biblio

LEFT JOIN drupal_node ON drupal_node.nid = drupal_biblio.nid
LEFT JOIN drupal_biblio_contributor ON drupal_biblio_contributor.nid = drupal_biblio.nid
LEFT JOIN drupal_biblio_contributor_data ON drupal_biblio_contributor_data.cid = drupal_biblio_contributor.cid

ORDER BY drupal_biblio.biblio_year DESC

I've tweaked the above query a bit:


SELECT drupal_biblio.nid, drupal_biblio.biblio_year, drupal_node.title, drupal_biblio_contributor_data.lastname,drupal_biblio_contributor_data.firstname, drupal_biblio_contributor_data.initials, drupal_biblio.biblio_secondary_title, drupal_biblio_contributor.rank

FROM drupal_biblio

LEFT JOIN drupal_node ON drupal_node.nid = drupal_biblio.nid
LEFT JOIN drupal_biblio_contributor ON drupal_biblio_contributor.nid = drupal_biblio.nid
LEFT JOIN drupal_biblio_contributor_data ON drupal_biblio_contributor_data.cid = drupal_biblio_contributor.cid

ORDER BY drupal_biblio.biblio_year DESC

Posted by kkwaiser at March 30, 2011 10:40 AM

Trackback Pings

TrackBack URL for this entry:
http://mblog.lib.umich.edu/mt-bin/mt-tb.cgi/2165

Listed below are links to weblogs that reference Adding stable file download links to the Research Bibliography - Part 1:

» イルビゾンテ セール from イルビゾンテ セール
The widely accepted belief is that in case you buy from a Coach outlet then not often covered have the money to buy on the list of pocketbooks from a normal shop. That belief is not reality. [Read More]

Tracked on February 8, 2014 09:51 AM

» イルビゾンテ セール 2014 from イルビゾンテ セール 2014
The most popular belief is that in case you buy from a Coach outlet then you cannot have the money to buy among the pocketbooks from a standard shop. That belief is not reality. [Read More]

Tracked on February 8, 2014 10:41 AM

» サマンサタバサ アウトレット セール from サマンサタバサ アウトレット セール
Hmm, that is some compelling information youve got going! Makes me scratch my head and think. Keep up the good writing! [Read More]

Tracked on February 11, 2014 07:51 AM

» nike air max billiger from nike air max billiger
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]

Tracked on February 16, 2014 08:23 PM

» ケイトスペード バッグ from ケイトスペード バッグ
Although you may were unaware, Kate Spade has new arrivals in fact it i all about “Places going, people to see! ” First stop, Brighton, England! [Read More]

Tracked on February 18, 2014 05:22 PM

» aiHJbXkj from aiHJbXkj
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]

Tracked on February 18, 2014 05:27 PM

» http://pandoraukuk.sayfasi.net/ from http://pandoraukuk.sayfasi.net/
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]

Tracked on February 21, 2014 12:58 PM

» Cheap Ralph Lauren from Cheap Ralph Lauren
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]

Tracked on February 24, 2014 08:00 AM

» wholesale nike air max from wholesale nike air max
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]

Tracked on February 25, 2014 08:53 AM

» structured settlement basics - understanding structured settlement buying selling and investing from structured settlement basics - understanding structured settlement buying selling and investing
How do I know if my blogs are being seen by others? [Read More]

Tracked on March 8, 2014 10:51 AM

» 万年筆 パイロット from 万年筆 パイロット
Another excellent article! Thank you! [Read More]

Tracked on March 16, 2014 04:09 PM

» cheap ralph lauren from cheap ralph lauren
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]

Tracked on April 2, 2014 11:32 AM

» http://www.fenacor.org/ from http://www.fenacor.org/
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]

Tracked on April 5, 2014 06:47 AM

» http://filmworkshop.ru/talk/viewtopic.php?pid=7543 from http://filmworkshop.ru/talk/viewtopic.php?pid=7543
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]

Tracked on April 6, 2014 08:17 AM

» click here from click here
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]

Tracked on April 8, 2014 11:35 PM

» website from website
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]

Tracked on April 9, 2014 06:01 PM

» サマンサタバサ セール 2014 from サマンサタバサ セール 2014
Thought I would comment and say cool theme, did you code it on your own? It looks really good! [Read More]

Tracked on April 18, 2014 04:25 AM

Comments

Login to leave a comment. Create a new account.