content-type:text/html
Server astm2 Failed In db_New_ProcessQuery on Query >>>> SELECT DESIGNATIOYEAR,DESIGNATIO,TITLE,YEAR,IMAGE_PATH,IF(0 < INSTR(YEAR,"("),if(LEFT(SUBSTRING(YEAR,6),2) < 20, CONCAT('20',SUBSTRING(YEAR,6)),CONCAT('19',SUBSTRING(YEAR,6)) ), if(LEFT(YEAR,2) < 20, CONCAT('20',YEAR),CONCAT('19',YEAR) ) ) AS YSORT
FROM _usr6_htdocs_astm_org_DATABASE_allstandards_msq
WHERE (
DESIGNATIO='D2492' OR
REPLACE(DESIGNATIO,"/","")='D2492' OR
DESIGNATIO='D2492/D2492M' OR
DESIGNATIO=SUBSTRING('D2492',1,LOCATE('/','D2492')-1)
)
AND TYPE='Historical'
ORDER BY YSORT DESC
<<<<<
Click any Designation link to view a Document Summary Description.
|
|||