øv dubletter
HejsaJeg har følgende sql sætning:
select
pages.id,
PageImages_mtm.page_id,
temp.total as totalen
from
PageImages_mtm, pages, (select sum(total) as total, page_id from keywords where page_id in(select page_id from keywords where keyword in('biler') group by page_id having count(*) > 0 ) and keyword in('biler') group by page_id) as temp where temp.page_id=pages.id and Pages.id=PageImages_mtm.page_id order by totalen desc
problemet er at der kommer en masse ens rækker ud, hvilket der helst ikke skulle...nogen ideer??
Royal12