Semantisch zoeken

[[Categorie:Hardware]] [[HardwareLocation::!~Museum]] [[HardwareLocation::!~Lab1]] [[HardwareLocation::!~Lab2]] [[HardwareLocation::!~Patchkast]] [[HardwareLocation::!~Balie]]

SELECT DISTINCT
  t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
  `smw_object_ids` AS t0
INNER JOIN
  (`smw_fpt_inst` AS t2
INNER JOIN
  (`smw_di_wikipage` AS t4
INNER JOIN
  `smw_object_ids` AS t6 ON t4.o_id=t6.smw_id) ON t2.s_id=t4.s_id
INNER JOIN
  (`smw_di_wikipage` AS t7
INNER JOIN
  `smw_object_ids` AS t9 ON t7.o_id=t9.smw_id) ON t2.s_id=t7.s_id
INNER JOIN
  (`smw_di_wikipage` AS t10
INNER JOIN
  `smw_object_ids` AS t12 ON t10.o_id=t12.smw_id) ON t2.s_id=t10.s_id
INNER JOIN
  (`smw_di_wikipage` AS t13
INNER JOIN
  `smw_object_ids` AS t15 ON t13.o_id=t15.smw_id) ON t2.s_id=t13.s_id
INNER JOIN
  (`smw_di_wikipage` AS t16
INNER JOIN
  `smw_object_ids` AS t18 ON t16.o_id=t18.smw_id) ON t2.s_id=t16.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.o_id=22177
   AND (t4.p_id=22043
   AND (t6.smw_sortkey NOT LIKE 'Museum')
  )
   AND (t7.p_id=22043
   AND (t9.smw_sortkey NOT LIKE 'Lab1')
  )
   AND (t10.p_id=22043
   AND (t12.smw_sortkey NOT LIKE 'Lab2')
  )
   AND (t13.p_id=22043
   AND (t15.smw_sortkey NOT LIKE 'Patchkast')
  )
   AND (t16.p_id=22043
   AND (t18.smw_sortkey NOT LIKE 'Balie')
  ))
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  55
OFFSET
  242