select coll.coll_id, ct.content, round(coll.price*(SELECT conversionSEK FROM currency WHERE currency_code="EUR"),0) as price, coll.size, o.filename FROM collection coll INNER JOIN coll_obj_rel AS cor ON coll.coll_id = cor.coll_id INNER JOIN coll_text AS ct ON coll.coll_id = ct.coll_id INNER JOIN object AS o ON cor.obj_id = o.obj_id WHERE ct.lang = "EN" AND coll.seq between 0 AND 5 AND visible='Y' AND NOT EXISTS (select 1 from object o2, coll_obj_rel cor2 WHERE coll.coll_id = cor2.coll_id AND cor2.obj_id = o2.obj_id AND (o2.webshop='S' OR o2.webshop='N')) ORDER BY coll.seq, cor.seqCollection data not found