URL:
http://coa.inducks.or...CB+OIL+++6
--------------------
SELECT s.urlbase, eu.endofurl, e.changes, e.identificationuncertain,
p.title, i.issuecode, i.issuenumber, p.countrycode, i.oldestdate,
eu.pagenr
FROM inducks_site s, temp_urlentrystory eu,
inducks_entry e, inducks_issue i, inducks_publication p,
inducks_storyversion sv USE index(fk1)
WHERE e.entrycode=eu.entrycode2
AND e.storyversioncode=sv.storyversioncode
AND sv.storycode='W OS 275-00'
AND eu.siteid=s.sitecode
AND s.sitecode='thumbnails2'
AND i.issuecode=e.issuecode
AND i.publicationcode=p.publicationcode
AND eu.pagenumber=1
GROUP BY eu.entrycode, eu.pagenumber
ORDER BY i.oldestdate
**** ERROR: Unknown column 'eu.pagenumber' in 'where clause'
SELECT s.urlbase, eu.endofurl, e.changes, e.identificationuncertain,
p.title, i.issuecode, i.issuenumber, p.countrycode, i.oldestdate,
eu.pagenr
FROM inducks_site s, temp_urlentrystory eu,
inducks_entry e, inducks_issue i, inducks_publication p,
inducks_storyversion sv USE index(fk1)
WHERE e.entrycode=eu.entrycode2
AND e.storyversioncode=sv.storyversioncode
AND sv.storycode='CB OIL 15'
AND eu.siteid=s.sitecode
AND s.sitecode='thumbnails2'
AND i.issuecode=e.issuecode
AND i.publicationcode=p.publicationcode
AND eu.pagenumber=1
GROUP BY eu.entrycode, eu.pagenumber
ORDER BY i.oldestdate
**** ERROR: Unknown column 'eu.pagenumber' in 'where clause'
SELECT s.urlbase, eu.endofurl, e.changes, e.identificationuncertain,
p.title, i.issuecode, i.issuenumber, p.countrycode, i.oldestdate,
eu.pagenr
FROM inducks_site s, temp_urlentrystory eu,
inducks_entry e, inducks_issue i, inducks_publication p,
inducks_storyversion sv USE index(fk1)
WHERE e.entrycode=eu.entrycode2
AND e.storyversioncode=sv.storyversioncode
AND sv.storycode='Qdk/CBSV 7G'
AND eu.siteid=s.sitecode
AND s.sitecode='thumbnails2'
AND i.issuecode=e.issuecode
AND i.publicationcode=p.publicationcode
AND eu.pagenumber=1
GROUP BY eu.entrycode, eu.pagenumber
ORDER BY i.oldestdate
**** ERROR: Unknown column 'eu.pagenumber' in 'where clause'
SELECT s.urlbase, eu.endofurl, e.changes, e.identificationuncertain,
p.title, i.issuecode, i.issuenumber, p.countrycode, i.oldestdate,
eu.pagenr
FROM inducks_site s, temp_urlentrystory eu,
inducks_entry e, inducks_issue i, inducks_publication p,
inducks_storyversion sv USE index(fk1)
WHERE e.entrycode=eu.entrycode2
AND e.storyversioncode=sv.storyversioncode
AND sv.storycode='Qdk/CBSV 7G'
AND eu.siteid=s.sitecode
AND s.sitecode='thumbnails2'
AND i.issuecode=e.issuecode
AND i.publicationcode=p.publicationcode
AND eu.pagenumber=1
GROUP BY eu.entrycode, eu.pagenumber
ORDER BY i.oldestdate
**** ERROR: Unknown column 'eu.pagenumber' in 'where clause'
SELECT s.urlbase, eu.endofurl, e.changes, e.identificationuncertain,
p.title, i.issuecode, i.issuenumber, p.countrycode, i.oldestdate,
eu.pagenr
FROM inducks_site s, temp_urlentrystory eu,
inducks_entry e, inducks_issue i, inducks_publication p,
inducks_storyversion sv USE index(fk1)
WHERE e.entrycode=eu.entrycode2
AND e.storyversioncode=sv.storyversioncode
AND sv.storycode='CB OIL 6'
AND eu.siteid=s.sitecode
AND s.sitecode='thumbnails2'
AND i.issuecode=e.issuecode
AND i.publicationcode=p.publicationcode
AND eu.pagenumber=1
GROUP BY eu.entrycode, eu.pagenumber
ORDER BY i.oldestdate
**** ERROR: Unknown column 'eu.pagenumber' in 'where clause'
Fixed.
