SELECT gallery.id FROM gallery INNER JOIN gallery_tags ON (gallery.id = gallery_tags.galleryid) WHERE gallery_tags.tag = 'φθινόπωρο' AND active = 1 GROUP BY gallery.id ORDER BY gallery.date_added desc LIMIT 0,40