Account: Log In or Register

Find Out How We Can Help

Call us: 01743 297 937 [Clinic is Open] Email us: here

Cookies

This website uses the following cookies as specified in our Privacy Notice here.

Essential

These cookies are required for the functionality of the website and can't be switched off in our system.

Performance

We use these cookies to provide statistical information about our website - they are used for performance measurement and improvement.

  1. SELECT EM.*,EMS.*, ES.* FROM EventMain EM LEFT JOIN EventMainSub EMS ON EM.Id = EMS.EventMain LEFT JOIN EventSub ES ON EMS.EventSub = ES.Id WHERE Date(NOW()) >= Date(EM.StartDate) AND Date(EM.EndDate) > Date(NOW()) ORDER BY EM.StartDate ASC
  2. SELECT N.*,NC.*, NCS.* FROM Navigation N LEFT JOIN Navigation NC ON NC.Parent = N.Id LEFT JOIN Navigation NCS ON NCS.Parent = NC.Id WHERE N.Parent IS NULL AND N.Invisible = 0 AND NC.Ordinate IS NOT NULL AND NC.Invisible = 0 AND NCS.Invisible = 0 ORDER BY N.Ordinate ASC,NC.Ordinate ASC, NC.Name ASC, NCS.Ordinate ASC, NCS.Name ASC