The Rondo Theatre Company: Current Productions

SELECT FileName, Company.Name as CName, Company.URL as CURL, Production.Name as PName, Author, Notifier, Production.URL as PURL, Words, Type.Name as Type, TicketPrice, ConsessionPrice, TicketOther, DateOther, Production.ID as ID FROM Production LEFT JOIN Picture ON Production.MainPictureIX=Picture.ID LEFT JOIN Review ON Production.BlurbIX=Review.ID LEFT JOIN Company ON Production.CompanyIX=Company.ID LEFT JOIN Date ON Production.ID=Date.ProductionIX LEFT JOIN Type ON Production.TypeIX=Type.ID WHERE Status='Current' AND CompanyIX= GROUP BY PName ORDER BY EventTime
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY PName ORDER BY EventTime' at line 1


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/rondothe/rtc.rondotheatre.co.uk/current.php on line 77