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":3717,"date":"2019-12-04T17:05:20","date_gmt":"2019-12-04T16:05:20","guid":{"rendered":"https:\/\/cifreceramica.com\/buscador-promocion\/"},"modified":"2020-11-09T10:44:56","modified_gmt":"2020-11-09T09:44:56","slug":"buscador-promocion","status":"publish","type":"page","link":"https:\/\/zenonsurfaces.com\/fr\/buscador-promocion\/","title":{"rendered":"Buscador Promocion"},"content":{"rendered":"<p>[vc_row full_width=\u00a0\u00bbstretch_row_content\u00a0\u00bb el_class=\u00a0\u00bbbreadcrumb\u00a0\u00bb][vc_column]<!-- Modal -->\n\n<div class=\"modal fade\" id=\"guardar_seleccion\" tabindex=\"-1\" role=\"dialog\" aria-labelledby=\"exampleModalLabel\" aria-hidden=\"true\">\n  <div class=\"modal-dialog  modal-md\" role=\"document\" style=\"width:500px;margin-top:100px;\">\n    <div class=\"modal-content\">\n\t<form action=\"\/area-reservada-mis-selecciones\/\" method=\"POST\">\n\t  <div class=\"modal-header\">\n\t\t<h3><span>Sauvegarder:<\/span> Nueva Selecci\u00f3n<\/h3>\n\t  <\/div>\n      <div class=\"modal-body\">\n\t\n\t\t<div class=\"form-group\">\n\t\t<label>Nombre<\/label><br>\n\t\t<input type=\"text\" name=\"nombre\" placeholder=\"Nom\" class=\"form-control\">\n\t\t<\/div>\n\n      <\/div>\n\t\n\t\t<div class=\"modal-footer\">\n\t\t<button class=\"btn-guardar\">Sauvegarder<\/button>\n\t\t<button class=\"btn-cancelar\" data-dismiss=\"modal\" aria-hidden=\"true\">Cancelar<\/button>\n\t\t<\/div>\n\n\t  <\/form>\n\t\t\n    <\/div>\n  <\/div>\n<\/div>\n<!-- Modal -->\n\t\t\n<div class=\"modal fade\" id=\"enviar_pdf_seleccion\" tabindex=\"-1\" role=\"dialog\" aria-labelledby=\"exampleModalLabel\" aria-hidden=\"true\">\n  <div class=\"modal-dialog  modal-md\" role=\"document\" style=\"width:500px;margin-top:100px;\">\n    <div class=\"modal-content\">\n\t<form action=\"\/pdf-seleccion\/\" method=\"POST\">\n<input type=\"hidden\" name=\"url\" value=\"\/fr\/wp-json\/wp\/v2\/pages\/3717\">\n\t  <div class=\"modal-header\">\n\t\t<h3><span>Enviar Selecci\u00f3n:<\/span> PDF<\/h3>\n\t  <\/div>\n      <div class=\"modal-body\">\n\t\t\t\n\t\t<div class=\"form-group\">\n\t\t<label>Nombre<\/label><br>\n\t\t<input type=\"text\" name=\"email\" placeholder=\"Email\" class=\"form-control\">\n\t\t<\/div>\n\t\t\t\n      <\/div>\n\t\t\t\n\t\t<div class=\"modal-footer\">\n\t\t<button class=\"btn-guardar\">Envoyer<\/button>\n\t\t<button class=\"btn-cancelar\" data-dismiss=\"modal\" aria-hidden=\"true\">Cancelar<\/button>\n\t\t<\/div>\n\t\t\t\n\t  <\/form>\n\t\t\t\n    <\/div>\n  <\/div>\n<\/div>\n<!-- Modal -->\n\t\t\n<div class=\"modal fade\" id=\"enviar_jpg_seleccion\" tabindex=\"-1\" role=\"dialog\" aria-labelledby=\"exampleModalLabel\" aria-hidden=\"true\">\n  <div class=\"modal-dialog  modal-md\" role=\"document\" style=\"width:500px;margin-top:100px;\">\n    <div class=\"modal-content\">\n\t<form action=\"\/descarga-seleccion\/\" method=\"POST\">\n<input type=\"hidden\" name=\"url\" value=\"\/fr\/wp-json\/wp\/v2\/pages\/3717\">\n\t  <div class=\"modal-header\">\n\t\t<h3><span>Enviar Selecci\u00f3n:<\/span> JPG<\/h3>\n\t  <\/div>\n      <div class=\"modal-body\">\n\t\t\t\n\t\t<div class=\"form-group\">\n\t\t<label>Nombre<\/label><br>\n\t\t<input type=\"text\" name=\"email\" placeholder=\"Email\" class=\"form-control\">\n\t\t<\/div>\n\t\t\t\n      <\/div>\n\t\t\t\n\t\t<div class=\"modal-footer\">\n\t\t<button class=\"btn-guardar\">Envoyer<\/button>\n\t\t<button class=\"btn-cancelar\" data-dismiss=\"modal\" aria-hidden=\"true\">Cancelar<\/button>\n\t\t<\/div>\n\t\t\t\n\t  <\/form>\n\t\t\t\n    <\/div>\n  <\/div>\n<\/div>\n[\/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\u00a0\u00bb][vc_column_inner][vc_column_text el_class=\u00a0\u00bbtitular\u00a0\u00bb]<strong>Promotion du filtre de recherche<\/strong>[\/vc_column_text][\/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][vc_column_text]<\/p>\n<div class=\"filter_selector\" data-target=\"remove\" data-field=\"all\"><strong>Supprimer tout<\/strong><\/div>\n<p>[\/vc_column_text]<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]<script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><label class=\"check_filtro\"><input type=\"checkbox\" class=\"checkbox-custom filter_selector\" data-field=\"novedad\" data-value=\"1\" > Nouveaut\u00e9 <span class=\"cantidad\">(2)<\/span><span class=\"checkmark\"><\/span><\/label><\/div>[\/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>[\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner]<script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p>Collection<\/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 el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner]<script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p>Format de l'exposant<\/p><select id=\"filter_expositor_formatos\" name=\"expositor_formatos\" 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_expositor_formatos').select2();\n\t\t\t});<\/script><\/div>[\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner]<script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p>Type de promotion<\/p><select id=\"filter_tipo_de_promocion\" name=\"tipo_de_promocion\" class=\"filter_selector_select\"><option value=\"\" data-value=\"\" > S\u00e9lectionnez une option <\/option><option value=\"Cat\u00e1logos\" data-value=\"Cat\u00e1logos\" > Catalogues <\/option><option value=\"Expositores\/Cunas\" data-value=\"Expositores\/Cunas\" > Expositores\/cunas <\/option><option value=\"Paneles Expositor\" data-value=\"Paneles Expositor\" > Paneles Expositor <\/option><option value=\"CATALOGO\" data-value=\"CATALOGO\" > Catalogue <\/option><\/select><script>jQuery(document).ready(function() {\n\t\t\t    jQuery('#filter_tipo_de_promocion').select2();\n\t\t\t});<\/script><\/div>[\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner]<script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p>Tipologie de panneau<\/p><select id=\"filter_tipologia_panel\" name=\"tipologia_panel\" class=\"filter_selector_select\"><option value=\"\" data-value=\"\" > S\u00e9lectionnez une option <\/option><option value=\"IMAGINE\" data-value=\"IMAGINE\" > Imagine <\/option><\/select><script>jQuery(document).ready(function() {\n\t\t\t    jQuery('#filter_tipologia_panel').select2();\n\t\t\t});<\/script><\/div>[\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner]<script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p>Type de panneau<\/p><select id=\"filter_tipo_pasta_panel\" name=\"tipo_pasta_panel\" 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_tipo_pasta_panel').select2();\n\t\t\t});<\/script><\/div>[\/vc_column_inner][\/vc_row_inner][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner]<script>\n                var filtrosSesion = [];\n            <\/script><div class=\"\"><p>Format-pi\u00e8ces-pannau<\/p><select id=\"filter_formato_piezas_panel\" name=\"formato_piezas_panel\" 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_formato_piezas_panel').select2();\n\t\t\t});<\/script><\/div>[\/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 width=\u00a0\u00bb3\/4&Prime;][vc_column_text]<\/p>\n<p style=\"text-align: left;\"><strong><span id=\"num_colecciones\">128<\/span> resultados<\/strong><\/p>\n<p>[\/vc_column_text][\/vc_column_inner][vc_column_inner width=\u00a0\u00bb1\/4&Prime;][\/vc_column_inner][\/vc_row_inner][vc_row_inner el_id=\u00a0\u00bbresultado_filtros\u00a0\u00bb][vc_column_inner]Lo lamentamos, no tienes permiso para acceder a esta secci\u00f3n.[vc_empty_space height=\u00a0\u00bb45px\u00a0\u00bb][\/vc_column_inner][\/vc_row_inner][\/vc_column][\/vc_row][vc_row][vc_column]<!-- Modal -->\n<input type=\"hidden\" id=\"id_pieza_modal\">\n<div style=\"z-index:100000;\"class=\"modal fade\" id=\"modal_pieza\" tabindex=\"-1\" role=\"dialog\" aria-labelledby=\"exampleModalLabel\" aria-hidden=\"true\">\n  <div class=\"modal-dialog\" role=\"document\">\n    <div class=\"modal-content\">\n\n      <div class=\"modal-body\" id=\"contenedor_info_pieza\">\n\n\n      <\/div>\n\n    <\/div>\n  <\/div>\n<\/div>\n[\/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\u00a0\u00bb][vc_column width=\u00a0\u00bb1\/4&Prime; el_class=\u00a0\u00bbfiltros_busqueda\u00a0\u00bb][vc_row_inner el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner][vc_column_text el_class=\u00a0\u00bbtitular\u00a0\u00bb]Promotion du filtre de recherche[\/vc_column_text][\/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][vc_column_text] Supprimer tout [\/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 el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner][\/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 el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner][\/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 el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner][\/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 el_class=\u00a0\u00bbbloque_filtro\u00a0\u00bb][vc_column_inner][\/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 width=\u00a0\u00bb3\/4&Prime;][vc_column_text] resultados [\/vc_column_text][\/vc_column_inner][vc_column_inner width=\u00a0\u00bb1\/4&Prime;][\/vc_column_inner][\/vc_row_inner][vc_row_inner el_id=\u00a0\u00bbresultado_filtros\u00a0\u00bb][vc_column_inner][vc_empty_space height=\u00a0\u00bb45px\u00a0\u00bb][\/vc_column_inner][\/vc_row_inner][\/vc_column][\/vc_row][vc_row][vc_column][\/vc_column][\/vc_row]<\/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-3717","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/pages\/3717","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=3717"}],"version-history":[{"count":4,"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/pages\/3717\/revisions"}],"predecessor-version":[{"id":4740,"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/pages\/3717\/revisions\/4740"}],"wp:attachment":[{"href":"https:\/\/zenonsurfaces.com\/fr\/wp-json\/wp\/v2\/media?parent=3717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}