SELECT DISTINCT p.categoria_padre_es as referencia_de_categoria, c.imagen_de_categoria FROM products p
                        JOIN categories c ON p.categoria_padre_es = c.nombre_de_categoria_es
                        WHERE p.activo = '1' AND p.catalogo = '1' AND p.categoria_padre_es IS NOT NULL AND p.categoria_padre_es != '' AND p.categoria_padre_es != 'ENCIMERA' AND c.imagen_de_categoria IS NOT NULL AND c.imagen_de_categoria != '' {"id":2614,"date":"2019-09-23T10:07:51","date_gmt":"2019-09-23T08:07:51","guid":{"rendered":"https:\/\/cifreceramica.com\/?page_id=2614"},"modified":"2019-09-23T11:20:57","modified_gmt":"2019-09-23T09:20:57","slug":"zone-reservee","status":"publish","type":"page","link":"https:\/\/zenonsurfaces.com\/fr\/zone-reservee\/","title":{"rendered":"Zone r\u00e9serv\u00e9e &#8211; Promotion g\u00e9n\u00e9rale"},"content":{"rendered":"<p>[vc_row full_width=\u00a0\u00bbstretch_row_content\u00a0\u00bb el_class=\u00a0\u00bbbreadcrumb\u00a0\u00bb][vc_column][\/vc_column][\/vc_row][vc_row full_width=\u00a0\u00bbstretch_row_content\u00a0\u00bb equal_height=\u00a0\u00bbyes\u00a0\u00bb el_class=\u00a0\u00bbbusqueda_coleccion promociones_top\u00a0\u00bb][vc_column width=\u00a0\u00bb1\/4&Prime; el_class=\u00a0\u00bbfiltros_busqueda cesta_promocion\u00a0\u00bb][vc_row_inner][vc_column_inner el_class=\u00a0\u00bbcesta\u00a0\u00bb width=\u00a0\u00bb1\/2&Prime;][vc_column_text el_class=\u00a0\u00bbtitular\u00a0\u00bb]<span style=\"color: #ffffff;\"><a style=\"color: #ffffff;\" href=\"https:\/\/cifreceramica.com\/cesta\/\"><strong>Ver cesta<\/strong><\/a><\/span>[\/vc_column_text][\/vc_column_inner][vc_column_inner el_class=\u00a0\u00bbnproductos\u00a0\u00bb width=\u00a0\u00bb1\/2&Prime;][vc_column_text el_class=\u00a0\u00bbtitular\u00a0\u00bb]0 produits[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][\/vc_column][vc_column width=\u00a0\u00bb3\/4&Prime; el_class=\u00a0\u00bbresultado_busqueda\u00a0\u00bb][\/vc_column][\/vc_row][vc_row full_width=\u00a0\u00bbstretch_row_content\u00a0\u00bb el_class=\u00a0\u00bbbusqueda_merchandising\u00a0\u00bb][vc_column width=\u00a0\u00bb3\/12&Prime; el_class=\u00a0\u00bbfiltros_busqueda promocion_filtros\u00a0\u00bb][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner]<script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><select id=\"filter_referencia_de_categoria\" name=\"referencia_de_categoria\" class=\"filter_selector_select\"><option value=\"\" data-value=\"\" > S\u00e9lectionnez une option <\/option><option value=\"Ba\u00f1eras\" data-value=\"Ba\u00f1eras\" > Baignoires <\/option><option value=\"Lavabos\" data-value=\"Lavabos\" > Vasques <\/option><option value=\"Mobiliario\" data-value=\"Mobiliario\" > Meubles <\/option><option value=\"Plato Ducha\" data-value=\"Plato Ducha\" > Receveur De Douche <\/option><option value=\"Spc\" data-value=\"Spc\" > Spc <\/option><\/select><script>jQuery(document).ready(function() {\n\t\t\t    jQuery('#filter_referencia_de_categoria').select2();\n\t\t\t});<\/script><\/div>[\/vc_column_inner][\/vc_row_inner][vc_row_inner][vc_column_inner][vc_toggle title=\u00a0\u00bbUtilisation\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb]<\/p>\n<div><script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><\/div><\/div>\n<p>[\/vc_toggle][vc_toggle title=\u00a0\u00bbFinition\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb]<\/p>\n<div class=\"check_filtro\">\n<div><script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><label class=\"check_filtro \" ><input type=\"checkbox\" class=\"checkbox-custom filter_selector\" data-field=\"acabado\" data-value=\"MATE\"  data-padre=\"\"> Mat <span class=\"cantidad\">(119)<\/span><span class=\"checkmark\"><\/span><\/label><label class=\"check_filtro \" ><input type=\"checkbox\" class=\"checkbox-custom filter_selector\" data-field=\"acabado\" data-value=\"BRILLO\"  data-padre=\"\"> Brillant  <span class=\"cantidad\">(4)<\/span><span class=\"checkmark\"><\/span><\/label><\/div><\/div>\n<\/div>\n<p>[\/vc_toggle][vc_toggle title=\u00a0\u00bbFormat\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb]<\/p>\n<div class=\"check_filtro\">\n<div><script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><label class=\"check_filtro \" ><input type=\"checkbox\" class=\"checkbox-custom filter_selector\" data-field=\"formato\" data-value=\"0.000\"  data-padre=\"\"> 0.000 <span class=\"cantidad\">(1)<\/span><span class=\"checkmark\"><\/span><\/label><\/div><\/div>\n<\/div>\n<p>[\/vc_toggle][vc_toggle title=\u00a0\u00bbTypo de p\u00e2te\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb]<\/p>\n<div class=\"check_filtro\">\n<div><script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><\/div><\/div>\n<\/div>\n<p>[\/vc_toggle][vc_toggle title=\u00a0\u00bbCouleur\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb]<\/p>\n<div class=\"check_filtro\">\n<div><script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><div style=\"height:30px;\"><\/div><\/div><\/div>\n<\/div>\n<p>[\/vc_toggle][vc_toggle title=\u00a0\u00bbType de panneau\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb]<\/p>\n<div class=\"check_filtro\">\n<div><script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><label class=\"check_filtro \" ><input type=\"checkbox\" class=\"checkbox-custom filter_selector\" data-field=\"tipo_de_promocion\" data-value=\"Cat\u00e1logos\"  data-padre=\"\"> Catalogues <span class=\"cantidad\">(6)<\/span><span class=\"checkmark\"><\/span><\/label><label class=\"check_filtro \" ><input type=\"checkbox\" class=\"checkbox-custom filter_selector\" data-field=\"tipo_de_promocion\" data-value=\"Expositores\/Cunas\"  data-padre=\"\"> Expositores\/cunas <span class=\"cantidad\">(5)<\/span><span class=\"checkmark\"><\/span><\/label><label class=\"check_filtro \" ><input type=\"checkbox\" class=\"checkbox-custom filter_selector\" data-field=\"tipo_de_promocion\" data-value=\"Paneles Expositor\"  data-padre=\"\"> Paneles Expositor <span class=\"cantidad\">(7)<\/span><span class=\"checkmark\"><\/span><\/label><label class=\"check_filtro \" ><input type=\"checkbox\" class=\"checkbox-custom filter_selector\" data-field=\"tipo_de_promocion\" data-value=\"CATALOGO\"  data-padre=\"\"> Catalogue <span class=\"cantidad\">(2)<\/span><span class=\"checkmark\"><\/span><\/label><\/div><\/div>\n<\/div>\n<p>[\/vc_toggle][\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner el_id=\u00a0\u00bbfiltros_activos\u00a0\u00bb]<div class=\"wrapper_filtros_activos\"><\/div>[\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro borrar_filtro\u00a0\u00bb][vc_column_inner][vc_column_text]<\/p>\n<div class=\"filter_selector\" data-target=\"remove\" data-field=\"all\"><strong>Tout effacer<\/strong><\/div>\n<p>[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][\/vc_column][vc_column width=\u00a0\u00bb2\/12&Prime; el_class=\u00a0\u00bbpromocion_colecciones\u00a0\u00bb el_id=\u00a0\u00bbresultado_filtros\u00a0\u00bb]<ul><\/ul>[\/vc_column][vc_column width=\u00a0\u00bb7\/12&Prime; el_class=\u00a0\u00bbpromocion_resultados\u00a0\u00bb][vc_row_inner el_class=\"fila_promocion_tipo\"][vc_column_inner el_class=\"item\" width=\"1\/4\"][vc_single_image image=\"620\" img_size=\"full\" alignment=\"center\"][vc_btn title=\"Paneles\" style=\"outline-custom\" outline_custom_color=\"#0a0a0a\" outline_custom_hover_background=\"#0a0a0a\" outline_custom_hover_text=\"#ffffff\" shape=\"square\" size=\"sm\" align=\"center\" el_class=\"boton_negro\" link=\"url:https%3A%2F%2Fcifreweb.atic.green%2Farea-reservada%2Fpaneles%2F|title:%C3%81rea%20reservada%20%E2%80%93%20Promoci%C3%B3n%20Paneles||\"][\/vc_column_inner][vc_column_inner el_class=\"item\" width=\"1\/4\"][vc_single_image image=\"621\" img_size=\"full\" alignment=\"center\"][vc_btn title=\"Expositores\" style=\"outline-custom\" outline_custom_color=\"#0a0a0a\" outline_custom_hover_background=\"#0a0a0a\" outline_custom_hover_text=\"#ffffff\" shape=\"square\" size=\"sm\" align=\"center\" el_class=\"boton_negro\" link=\"url:https%3A%2F%2Fcifreweb.atic.green%2Farea-reservada%2Fexpositores%2F|title:%C3%81rea%20reservada%20%E2%80%93%20Promoci%C3%B3n%20Expositor||\"][\/vc_column_inner][vc_column_inner el_class=\"item\" width=\"1\/4\"][vc_single_image image=\"622\" img_size=\"full\" alignment=\"center\"][vc_btn title=\"Piezas\" style=\"outline-custom\" outline_custom_color=\"#0a0a0a\" outline_custom_hover_background=\"#0a0a0a\" outline_custom_hover_text=\"#ffffff\" shape=\"square\" size=\"sm\" align=\"center\" el_class=\"boton_negro\" link=\"url:https%3A%2F%2Fcifreweb.atic.green%2Farea-reservada%2Fpiezas%2F|title:%C3%81rea%20reservada%20%E2%80%93%20Promoci%C3%B3n%20Piezas||\"][\/vc_column_inner][vc_column_inner el_class=\"item\" width=\"1\/4\"][vc_single_image image=\"623\" img_size=\"full\" alignment=\"center\"][vc_btn title=\"Cat\u00e1logos\" style=\"outline-custom\" outline_custom_color=\"#0a0a0a\" outline_custom_hover_background=\"#0a0a0a\" outline_custom_hover_text=\"#ffffff\" shape=\"square\" size=\"sm\" align=\"center\" el_class=\"boton_negro\" link=\"url:https%3A%2F%2Fcifreweb.atic.green%2Farea-reservada%2Fcatalogos%2F|title:%C3%81rea%20reservada%20%E2%80%93%20Promoci%C3%B3n%20cat%C3%A1logos||\"][\/vc_column_inner][\/vc_row_inner][\/vc_column][\/vc_row][vc_row][vc_column][vc_raw_js]JTNDc2NyaXB0JTNFJTIwalF1ZXJ5JTI4ZnVuY3Rpb24lMjglMjklN0IlMEElMEElMjAlMjBqUXVlcnklMjglMjdpbnB1dCU1QnR5cGUlM0QlMjJudW1iZXIlMjIlNUQlMjclMjkubmljZU51bWJlciUyOCUyOSUzQiUwQSUwQSU3RCUyOSUzQiUzQyUyRnNjcmlwdCUzRQ==[\/vc_raw_js][\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_row full_width=\u00a0\u00bbstretch_row_content\u00a0\u00bb el_class=\u00a0\u00bbbreadcrumb\u00a0\u00bb][vc_column][\/vc_column][\/vc_row][vc_row full_width=\u00a0\u00bbstretch_row_content\u00a0\u00bb equal_height=\u00a0\u00bbyes\u00a0\u00bb el_class=\u00a0\u00bbbusqueda_coleccion promociones_top\u00a0\u00bb][vc_column width=\u00a0\u00bb1\/4&Prime; el_class=\u00a0\u00bbfiltros_busqueda cesta_promocion\u00a0\u00bb][vc_row_inner][vc_column_inner el_class=\u00a0\u00bbcesta\u00a0\u00bb width=\u00a0\u00bb1\/2&Prime;][vc_column_text el_class=\u00a0\u00bbtitular\u00a0\u00bb]Ver cesta[\/vc_column_text][\/vc_column_inner][vc_column_inner el_class=\u00a0\u00bbnproductos\u00a0\u00bb width=\u00a0\u00bb1\/2&Prime;][vc_column_text el_class=\u00a0\u00bbtitular\u00a0\u00bb]0 produits[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][\/vc_column][vc_column width=\u00a0\u00bb3\/4&Prime; el_class=\u00a0\u00bbresultado_busqueda\u00a0\u00bb][\/vc_column][\/vc_row][vc_row full_width=\u00a0\u00bbstretch_row_content\u00a0\u00bb el_class=\u00a0\u00bbbusqueda_merchandising\u00a0\u00bb][vc_column width=\u00a0\u00bb3\/12&Prime; el_class=\u00a0\u00bbfiltros_busqueda promocion_filtros\u00a0\u00bb][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner][\/vc_column_inner][\/vc_row_inner][vc_row_inner][vc_column_inner][vc_toggle title=\u00a0\u00bbUtilisation\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb] [\/vc_toggle][vc_toggle title=\u00a0\u00bbFinition\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb] [\/vc_toggle][vc_toggle title=\u00a0\u00bbFormat\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb] [\/vc_toggle][vc_toggle title=\u00a0\u00bbTypo de p\u00e2te\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb] [\/vc_toggle][vc_toggle title=\u00a0\u00bbCouleur\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb] [\/vc_toggle][vc_toggle title=\u00a0\u00bbType de panneau\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb] [\/vc_toggle][\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"om_disable_all_campaigns":false,"footnotes":""},"class_list":["post-2614","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/pages\/2614","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/comments?post=2614"}],"version-history":[{"count":4,"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/pages\/2614\/revisions"}],"predecessor-version":[{"id":2691,"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/pages\/2614\/revisions\/2691"}],"wp:attachment":[{"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/media?parent=2614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}