querying with: SELECT Video.Artist,Video.Title,Video.Producer,Video.Label,Video.YouTubeDatePosted,Video.Comments,Video.Rating,Video.Category,z_Video_SearchText.SearchText,Video.Filename,Video.ID,Video.SongTime,Video.Dimensions_Width,Video.Interviewer,Video.New,Video.Downloads,Video.Director FROM Video INNER JOIN z_Video_SearchText ON Video.ID = z_Video_SearchText.ForeignID WHERE (Video.Category='MusicVideo' OR Video.Category='MusicVideo_OS') AND Video.Director like '%KRSP%' AND Video.Live = '1' Order By Video.YouTubeDatePosted desc,Video.Category,z_Video_SearchText.SearchText