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)  INNER JOIN u_facet_cache c8 ON (c1.page_element=c8.page_element AND c1.datasource_id = c8.datasource_id)  WHERE c1.page_element='product' AND c1.value = 726 AND c1.version='published' AND c2.value = 730 AND c2.version='published' AND c3.value = 686 AND c3.version='published' AND c4.value = 682 AND c4.version='published' AND c5.value = 699 AND c5.version='published' AND c6.value = 649 AND c6.version='published' AND c7.value = 714 AND c7.version='published' AND c8.value = 695 AND c8.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)  INNER JOIN u_facet_cache c8 ON (c1.page_element=c8.page_element AND c1.datasource_id = c8.datasource_id)  WHERE c1.page_element='productgroep' AND c1.value = 726 AND c1.version='published' AND c2.value = 730 AND c2.version='published' AND c3.value = 686 AND c3.version='published' AND c4.value = 682 AND c4.version='published' AND c5.value = 699 AND c5.version='published' AND c6.value = 649 AND c6.version='published' AND c7.value = 714 AND c7.version='published' AND c8.value = 695 AND c8.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)  INNER JOIN u_facet_cache c8 ON (c1.page_element=c8.page_element AND c1.datasource_id = c8.datasource_id)  WHERE c1.page_element='promoitem' AND c1.value = 726 AND c1.version='published' AND c2.value = 730 AND c2.version='published' AND c3.value = 686 AND c3.version='published' AND c4.value = 682 AND c4.version='published' AND c5.value = 699 AND c5.version='published' AND c6.value = 649 AND c6.version='published' AND c7.value = 714 AND c7.version='published' AND c8.value = 695 AND c8.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)  INNER JOIN u_facet_cache c8 ON (c1.page_element=c8.page_element AND c1.datasource_id = c8.datasource_id)  WHERE c1.page_element='product_set' AND c1.value = 726 AND c1.version='published' AND c2.value = 730 AND c2.version='published' AND c3.value = 686 AND c3.version='published' AND c4.value = 682 AND c4.version='published' AND c5.value = 699 AND c5.version='published' AND c6.value = 649 AND c6.version='published' AND c7.value = 714 AND c7.version='published' AND c8.value = 695 AND c8.version='published'
					)