Ionel,
Is there a requirement of a minimal MySQL version for it to work ?
There shouldn't be a problem. SUBDATE and INNER JOIN have been in since at least 3.23, and these are the only ones that may be a problem. Try running it against your database and tell me what error messages you get! On my DB, with 2.3 million ticket history records and 63,000 tickets, it takes 1.7sec to run. Cheers, -- Steve Durbin Group Manager: Applications Delivery/Cyfarwyddwr Grŵp: Trosglwyddo Rhaglenni Bridgend County Borough Council/Cyngor Bwrdeistref Sirol Pen-y-Bont ar Ogwr Tel/Rhif ffon: 01656 642113 Mob/ffon symudol: 07976 271559 Fax/Ffacs: 01656 642125 Web/We: http://www.bridgend.gov.uk E-mail may be automatically logged, monitored and/or recorded for legal purposes. Please do not print this email unless absolutely necessary. E-bost yn cael ei logio, ei monitro a/neu ei chofnodi yn awtomatig am resymau cyfreithiol Peidiwch ag argraffu’r neges e-bost hon oni bai fod hynny’n gwbl angenrheidiol. ________________________________________________________________________ This e-mail and any attachments transmitted with it represents the views of the individual(s) who sent them and should not be regarded as the official view of Bridgend County Borough Council. The contents are confidential and intended solely for the use of the addressee. If you have received it in error, please inform the system administrator on (+44) 01656 642111. This e-mail and any attachments have been scanned with 'MessageLabs SkyScan' - http://www.messagelabs.com/ ________________________________________________________________________ Mae'r e-bost hwn ac unrhyw atodiadau a drosglwyddir gydag ef yn cynrychioli safbwyntiau'r unigolyn a'i anfonodd (unigolion a'u hanfonodd) ac ni ddylid eu hystyried fel safbwynt swyddogol Cyngor Bwrdeistref Sirol Pen-y-bont ar Ogwr. Mae'r cynnwys yn gyfrinachol ac wedi'i fwriadu ar gyfer y sawl y'i cyfeiriwyd ato yn unig. Os ydych wedi ei dderbyn mewn camgymeriad, rhowch wybod i weinyddwr y system ar (+44) 01656 642111. Mae'r e-bost hwn ac unrhyw atodiadau wedi cael eu sganio gyda 'MessageLabs SkyScan' - http://www.messagelabs.com/ ________________________________________________________________________