Alle uitgaven

SELECT GROUP_CONCAT(parent_key ORDER BY IF(NOT ISNULL(publicatiedatum),publicatiedatum,'1970-01-01')  DESC, title ASC) AS p FROM t_bestelitems_cache WHERE version='published' AND site='nt2' AND parent_key IN (
						SELECT CONCAT('p',c1.datasource_id) FROM u_facet_cache c1 INNER JOIN u_facet_cache c2 ON (c1.page_element=c2.page_element AND c1.datasource_id = c2.datasource_id)  INNER JOIN u_facet_cache c3 ON (c1.page_element=c3.page_element AND c1.datasource_id = c3.datasource_id)  INNER JOIN u_facet_cache c4 ON (c1.page_element=c4.page_element AND c1.datasource_id = c4.datasource_id)  INNER JOIN u_facet_cache c5 ON (c1.page_element=c5.page_element AND c1.datasource_id = c5.datasource_id)  INNER JOIN u_facet_cache c6 ON (c1.page_element=c6.page_element AND c1.datasource_id = c6.datasource_id)  INNER JOIN u_facet_cache c7 ON (c1.page_element=c7.page_element AND c1.datasource_id = c7.datasource_id)  WHERE c1.page_element='product' AND c1.value = 709 AND c1.version='published' AND c2.value = 720 AND c2.version='published' AND c3.value = 685 AND c3.version='published' AND c4.value = 690 AND c4.version='published' AND c5.value = 682 AND c5.version='published' AND c6.value = 679 AND c6.version='published' AND c7.value = 728 AND c7.version='published' 
						UNION
						SELECT CONCAT('g',c1.datasource_id) FROM u_facet_cache c1 INNER JOIN u_facet_cache c2 ON (c1.page_element=c2.page_element AND c1.datasource_id = c2.datasource_id)  INNER JOIN u_facet_cache c3 ON (c1.page_element=c3.page_element AND c1.datasource_id = c3.datasource_id)  INNER JOIN u_facet_cache c4 ON (c1.page_element=c4.page_element AND c1.datasource_id = c4.datasource_id)  INNER JOIN u_facet_cache c5 ON (c1.page_element=c5.page_element AND c1.datasource_id = c5.datasource_id)  INNER JOIN u_facet_cache c6 ON (c1.page_element=c6.page_element AND c1.datasource_id = c6.datasource_id)  INNER JOIN u_facet_cache c7 ON (c1.page_element=c7.page_element AND c1.datasource_id = c7.datasource_id)  WHERE c1.page_element='productgroep' AND c1.value = 709 AND c1.version='published' AND c2.value = 720 AND c2.version='published' AND c3.value = 685 AND c3.version='published' AND c4.value = 690 AND c4.version='published' AND c5.value = 682 AND c5.version='published' AND c6.value = 679 AND c6.version='published' AND c7.value = 728 AND c7.version='published'
						UNION
						SELECT CONCAT('x',c1.datasource_id) FROM u_facet_cache c1 INNER JOIN u_facet_cache c2 ON (c1.page_element=c2.page_element AND c1.datasource_id = c2.datasource_id)  INNER JOIN u_facet_cache c3 ON (c1.page_element=c3.page_element AND c1.datasource_id = c3.datasource_id)  INNER JOIN u_facet_cache c4 ON (c1.page_element=c4.page_element AND c1.datasource_id = c4.datasource_id)  INNER JOIN u_facet_cache c5 ON (c1.page_element=c5.page_element AND c1.datasource_id = c5.datasource_id)  INNER JOIN u_facet_cache c6 ON (c1.page_element=c6.page_element AND c1.datasource_id = c6.datasource_id)  INNER JOIN u_facet_cache c7 ON (c1.page_element=c7.page_element AND c1.datasource_id = c7.datasource_id)  WHERE c1.page_element='promoitem' AND c1.value = 709 AND c1.version='published' AND c2.value = 720 AND c2.version='published' AND c3.value = 685 AND c3.version='published' AND c4.value = 690 AND c4.version='published' AND c5.value = 682 AND c5.version='published' AND c6.value = 679 AND c6.version='published' AND c7.value = 728 AND c7.version='published'
						UNION
						SELECT CONCAT('s',c1.datasource_id) FROM u_facet_cache c1 INNER JOIN u_facet_cache c2 ON (c1.page_element=c2.page_element AND c1.datasource_id = c2.datasource_id)  INNER JOIN u_facet_cache c3 ON (c1.page_element=c3.page_element AND c1.datasource_id = c3.datasource_id)  INNER JOIN u_facet_cache c4 ON (c1.page_element=c4.page_element AND c1.datasource_id = c4.datasource_id)  INNER JOIN u_facet_cache c5 ON (c1.page_element=c5.page_element AND c1.datasource_id = c5.datasource_id)  INNER JOIN u_facet_cache c6 ON (c1.page_element=c6.page_element AND c1.datasource_id = c6.datasource_id)  INNER JOIN u_facet_cache c7 ON (c1.page_element=c7.page_element AND c1.datasource_id = c7.datasource_id)  WHERE c1.page_element='product_set' AND c1.value = 709 AND c1.version='published' AND c2.value = 720 AND c2.version='published' AND c3.value = 685 AND c3.version='published' AND c4.value = 690 AND c4.version='published' AND c5.value = 682 AND c5.version='published' AND c6.value = 679 AND c6.version='published' AND c7.value = 728 AND c7.version='published'
					)