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":4257,"date":"2020-04-13T17:40:40","date_gmt":"2020-04-13T15:40:40","guid":{"rendered":"https:\/\/cifreceramica.com\/cifre-store\/"},"modified":"2020-10-20T17:50:54","modified_gmt":"2020-10-20T15:50:54","slug":"cifre-store","status":"publish","type":"page","link":"https:\/\/zenonsurfaces.com\/fr\/cifre-store\/","title":{"rendered":"Cifre Store"},"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\u00a0\u00bb el_class=\u00a0\u00bbcabecera_store\u00a0\u00bb][vc_column width=\u00a0\u00bb1\/3&Prime;][\/vc_column][vc_column width=\u00a0\u00bb1\/3&Prime;][vc_column_text]<\/p>\n<h1>Cifre Store<\/h1>\n<p>[\/vc_column_text][\/vc_column][vc_column width=\u00a0\u00bb1\/3&Prime;][vc_column_text el_class=\"carrito_store\"](<span id=\"num_el_cart\">0<\/span>)<a href=\"https:\/\/zenonsurfaces.com\/fr\/\/cifre-store-carrito\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4134\" src=\"https:\/\/cifreceramica.com\/wp-content\/uploads\/2020\/04\/carrito.png\" alt=\"\" width=\"30\" height=\"30\" \/><\/a>[\/vc_column_text][\/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\u00a0\u00bb][vc_column width=\u00a0\u00bb1\/4&Prime; el_class=\u00a0\u00bbfiltros_busqueda\u00a0\u00bb][vc_row_inner el_class=\u00a0\u00bbbloque_filtro sinborde\u00a0\u00bb][vc_column_inner][vc_column_text el_class=\u00a0\u00bbtitular\u00a0\u00bb]<strong>RECHERCHE ACTUELLE<\/strong>[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro sinborde\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\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_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner]<div class=\"\"><p>Pr\u00e9nom<\/p><input type=\"text\" name=\"buscador\" class=\"filtro_buscador\"><\/div><script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><label class=\"check_filtro red\" ><input type=\"checkbox\" class=\"checkbox-custom filter_selector\" data-field=\"unidad_stock\" data-value=\"ST\"  data-padre=\"\"> St <span class=\"cantidad\">(17)<\/span><span class=\"checkmark\"><\/span><\/label><\/div>[\/vc_column_inner][\/vc_row_inner][vc_row_inner][vc_column_inner][vc_toggle title=\u00a0\u00bbTypologie\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb open=\u00a0\u00bbtrue\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb]<script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><\/div>[\/vc_toggle][vc_toggle title=\u00a0\u00bbType de p\u00e2te\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb open=\u00a0\u00bbtrue\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb]<\/p>\n<div class=\"check_filtro\"><script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><\/div><\/div>\n<p>[\/vc_toggle][\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner][vc_column_text el_class=\u00a0\u00bbtitular\u00a0\u00bb]<strong>AUTRES FILTRES<\/strong>[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner][vc_custom_heading text=\u00a0\u00bbCaract\u00e9ristiques techniques\u00a0\u00bb font_container=\u00a0\u00bbtag:p|text_align:left\u00a0\u00bb use_theme_fonts=\u00a0\u00bbyes\u00a0\u00bb][vc_custom_heading text=\u00a0\u00bbClase glissement\u00a0\u00bb font_container=\u00a0\u00bbtag:div|text_align:left\u00a0\u00bb use_theme_fonts=\u00a0\u00bbyes\u00a0\u00bb]<script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><select id=\"filter_deslizamiento_clase\" name=\"deslizamiento_clase\" class=\"filter_selector_select\"><option value=\"\" data-value=\"\" > S\u00e9lectionnez une option <\/option><\/select><script>jQuery(document).ready(function() {\n\t\t\t    jQuery('#filter_deslizamiento_clase').select2();\n\t\t\t});<\/script><\/div>[vc_custom_heading text=\u00a0\u00bbGlissement R\u00a0\u00bb font_container=\u00a0\u00bbtag:div|text_align:left\u00a0\u00bb use_theme_fonts=\u00a0\u00bbyes\u00a0\u00bb css=\u00a0\u00bb.vc_custom_1589271857131{margin-top: 15px !important;}\u00a0\u00bb]<script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><select id=\"filter_deslizamiento_r\" name=\"deslizamiento_r\" class=\"filter_selector_select\"><option value=\"\" data-value=\"\" > S\u00e9lectionnez une option <\/option><\/select><script>jQuery(document).ready(function() {\n\t\t\t    jQuery('#filter_deslizamiento_r').select2();\n\t\t\t});<\/script><\/div>[vc_empty_space height=\u00a0\u00bb12px\u00a0\u00bb]<script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><\/div><script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><\/div><script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><\/div>[\/vc_column_inner][\/vc_row_inner][vc_row_inner][vc_column_inner][vc_toggle title=\u00a0\u00bbCollection\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb]<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_toggle][vc_toggle title=\u00a0\u00bbInspiration\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb open=\u00a0\u00bbtrue\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb]<script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><\/div>[\/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\"><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\">(120)<\/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<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\"><script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p><\/p><select id=\"filter_formato\" name=\"formato\" class=\"filter_selector_select\"><option value=\"\" data-value=\"\" > S\u00e9lectionnez une option <\/option><option value=\"0.000\" data-value=\"0.000\" > 0.000 <\/option><\/select><script>jQuery(document).ready(function() {\n\t\t\t    jQuery('#filter_formato').select2();\n\t\t\t});<\/script><\/div><\/div>\n<p>[\/vc_toggle][\/vc_column_inner][\/vc_row_inner][\/vc_column][vc_column width=\u00a0\u00bb3\/4&Prime; el_class=\u00a0\u00bbresultado_busqueda\u00a0\u00bb][vc_row_inner el_class=\u00a0\u00bbbloque_filtro titular_resultados\u00a0\u00bb][vc_column_inner][vc_column_text]<\/p>\n<p style=\"text-align: center;\"><strong><span id=\"num_colecciones\">0<\/span> r\u00e9sultats<\/strong><\/p>\n<p>[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_row_inner el_id=\u00a0\u00bbresultado_filtros\u00a0\u00bb][vc_column_inner][vc_row_inner ][vc_column][vc_custom_heading text=\"Lo sentimos, no hay ninguna colecci\u00f3n que cumpla con los filtros que has establecido.\n<br>Prueba a eliminar alg\u00fan filtro. Gracias.\" font_container=\"tag:div|font_size:20|text_align:center|color:%233f3f3f|line_height:30px\" use_theme_fonts=\"yes\"][\/vc_column][\/vc_row_inner][vc_empty_space height=\u00a0\u00bb45px\u00a0\u00bb][\/vc_column_inner][\/vc_row_inner][\/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\u00a0\u00bb el_class=\u00a0\u00bbcabecera_store\u00a0\u00bb][vc_column width=\u00a0\u00bb1\/3&Prime;][\/vc_column][vc_column width=\u00a0\u00bb1\/3&Prime;][vc_column_text] Cifre Store [\/vc_column_text][\/vc_column][vc_column width=\u00a0\u00bb1\/3&Prime;][\/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\u00a0\u00bb][vc_column width=\u00a0\u00bb1\/4&Prime; el_class=\u00a0\u00bbfiltros_busqueda\u00a0\u00bb][vc_row_inner el_class=\u00a0\u00bbbloque_filtro sinborde\u00a0\u00bb][vc_column_inner][vc_column_text el_class=\u00a0\u00bbtitular\u00a0\u00bb]RECHERCHE ACTUELLE[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro sinborde\u00a0\u00bb][vc_column_inner el_id=\u00a0\u00bbfiltros_activos\u00a0\u00bb][\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner][vc_column_text] Tout effacer [\/vc_column_text][\/vc_column_inner][\/vc_row_inner][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\u00bbTypologie\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb open=\u00a0\u00bbtrue\u00a0\u00bb el_class=\u00a0\u00bbacordeon_busqueda_avanzada\u00a0\u00bb][\/vc_toggle][vc_toggle title=\u00a0\u00bbType de p\u00e2te\u00a0\u00bb style=\u00a0\u00bbsquare\u00a0\u00bb open=\u00a0\u00bbtrue\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][vc_column_text el_class=\u00a0\u00bbtitular\u00a0\u00bb]AUTRES FILTRES[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner][vc_custom_heading text=\u00a0\u00bbCaract\u00e9ristiques techniques\u00a0\u00bb font_container=\u00a0\u00bbtag:p|text_align:left\u00a0\u00bb use_theme_fonts=\u00a0\u00bbyes\u00a0\u00bb][vc_custom_heading text=\u00a0\u00bbClase glissement\u00a0\u00bb font_container=\u00a0\u00bbtag:div|text_align:left\u00a0\u00bb use_theme_fonts=\u00a0\u00bbyes\u00a0\u00bb][vc_custom_heading text=\u00a0\u00bbGlissement R\u00a0\u00bb font_container=\u00a0\u00bbtag:div|text_align:left\u00a0\u00bb use_theme_fonts=\u00a0\u00bbyes\u00a0\u00bb [&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-4257","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/pages\/4257","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=4257"}],"version-history":[{"count":4,"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/pages\/4257\/revisions"}],"predecessor-version":[{"id":4664,"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/pages\/4257\/revisions\/4664"}],"wp:attachment":[{"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/media?parent=4257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}