Re: [Jason] Exclude category in search results
OK, just done that. Here is the output
SELECT SQL_CALC_FOUND_ROWS * FROM `ivfpodcast_podcasts`
WHERE ( featured != 'Sponsors') AND hidden = 0 AND publishDate <= NOW() AND (removeDate >= NOW() OR neverRemove = 1)
ORDER BY dragSortOrder DESC
SELECT FOUND_ROWS()
SELECT * FROM `ivfpodcast_uploads`
WHERE tableName = 'podcasts' AND
fieldName IN ('story_image','flv_file','m4v_file','zipped_file','playlist_file') AND
recordNum IN (46,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,14,29,28,24,23,22,25,26,21,20,19,18,17,27,16,15,13,12,11,9,8,7,6,5,4,3,2,1)
ORDER BY `order`, num
SELECT SQL_CALC_FOUND_ROWS * FROM `ivfpodcast_accounts`
WHERE (`num` IN (1))
ORDER BY fullname, username
SELECT FOUND_ROWS()
I have left 'debugSql' => true, live on the site so I hope it will help resolving this sooner.
I did put a line in to test (it is now removed) Category (<?php echo $record['featured'] ?>)
and this did show 'Sponsors' for the sections I am trying to remove.
Thank you for all your help so far.