select allt.*, allt.Res as Result, allt.Pos as Posit, index2.*, events.*, alltcountmen.Pos as Posi, alltcountmen.*, venues2.vid as Venue, countries.Countryfull FROM world.events, world.allt, world.venues2, alltcountmen, world.index2, countries WHERE allt.RealCountry=countries.Country AND alltcountmen.Pos<31 AND world.events.Event=alltcountmen.Event AND alltcountmen.Age=99 AND alltcountmen.Ind=1 AND world.venues2.V=world.allt.VID AND alltcountmen.iid=world.allt.IID AND alltcountmen.id=world.index2.ID AND CASE WHEN '430'!='All' THEN allt.enumber='430' ELSE 1=1 END ORDER BY allt.enumber, Posi, allt.Date