0
well my scenario is this, I have 1 slide where shows the 4 last news
SELECT * FROM noticias WHERE destacar='Destacado' ORDER BY idnoticia DESC LIMIT 4
below the slide I have a list of the other materials where you should present the ones not marked as NOT HIGHLIGHTED and those marked with HIGHLIGHTED from the 4th result, I am using the following query.
SELECT * FROM noticias n WHERE idnoticia NOT IN ( SELECT * FROM (SELECT idnoticia FROM noticias WHERE destacar = 'Destacado' ORDER BY idnoticia ASC LIMIT 10) p) ORDER BY idnoticia DESC LIMIT 9 OFFSET 4
is functioning in parts, this listing from the 4th result but if I include a news in the middle (assuming between the 2nd and 4th HIGHLIGHTED) marked NOT HIGHLIGHTED it does not appear.
Some way around this problem?