« 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:
» nike high heels from nike high heels
and so on, Chinese elements are referred to as a new fashion elements, such as the 2001 Shanghai APEC summit, 20 world leaders wearing uniform large red or royal blue Chinese Dui Jin Tang suit, sometimes set off in the global heat Tang suit. There are ... [Read More]
Tracked on April 9, 2013 06:22 AM
» cheap chanel from cheap chanel
I’m just commenting to let you know what a excellent discovery my cousin’s girl encountered going via your internet web site. She noticed several details, which include how it really is like to possess an perfect coaching spirit to let ot... [Read More]
Tracked on April 11, 2013 02:43 AM
» nike flyknit from nike flyknit
If you're still on the fence: grab your favorite earphones, head down to a Best Buy and ask to plug them into a Zune then an iPod and see which one sounds better to you, and which interface makes you smile more. Then you'll know which is right for you. [Read More]
Tracked on April 13, 2013 03:06 AM
» rRRONkpo from rRRONkpo
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]
Tracked on April 13, 2013 04:10 AM
» Burberry Handbags from Burberry Handbags
Irrrm a sucker for a new off white colour of a few Burberry Handbags and in addition have actually been giving all of them winter weather. The actual fashionth and luxury work most effectively, but additionally shortage superior the alignment assist, r... [Read More]
Tracked on April 14, 2013 04:51 AM
» michael kors outlet online from michael kors outlet online
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 michael kors outlet online . [Read More]
Tracked on April 17, 2013 05:57 PM
» Air Jordan shoes sale from Air Jordan shoes sale
Fabiano, Robinho and Nilmar, customers of Brazil's national group, host the speed module, with ideas plus a strategy to test your quickness. Juventus supervisor Ciro Ferrara prospects Nike Blazer classic you Nike Blazer... [Read More]
Tracked on April 27, 2013 08:14 AM
» burberry bags from burberry bags
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]
Tracked on April 27, 2013 09:46 AM
» Nike Ireland from Nike Ireland
of buying incredibly experienced leads and immediately calling them up in order to achieve out to them. Monthly bill Me Nike Air Max Later operates under Nike store IrelandNike store Ireland [Read More]
Tracked on April 28, 2013 04:30 AM
» sac louis vuitton from sac louis vuitton
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]
Tracked on April 28, 2013 12:52 PM
» seo tools from seo tools
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]
Tracked on April 29, 2013 06:54 AM
» miu miu from miu miu
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]
Tracked on April 30, 2013 12:48 AM
» celine bags from celine bags
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]
Tracked on April 30, 2013 02:22 AM
» mulberry bags from mulberry bags
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]
Tracked on April 30, 2013 06:58 AM
» wow gold from wow gold
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]
Tracked on May 6, 2013 07:52 PM
» 整形美容 from 整形美容
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]
Tracked on May 7, 2013 05:53 PM
» chanel bags from chanel bags
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]
Tracked on May 7, 2013 05:53 PM
» prada bags from prada bags
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]
Tracked on May 8, 2013 07:46 AM
» michael kors outlet from michael kors outlet
oakley polarized antix sunglasses vr28 black iridium wearing high heels [Read More]
Tracked on May 10, 2013 03:18 AM
» CELINE BAGS from CELINE BAGS
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]
Tracked on May 16, 2013 08:43 AM
» cheap designer bags from cheap designer bags
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 cheap designer bags [Read More]
Tracked on May 17, 2013 03:57 PM
» CHANEL HANDBAGS from CHANEL HANDBAGS
Data Discussions: Adding stable file download links to the Research Bibliography - Part 1 [Read More]
Tracked on May 22, 2013 08:21 AM