{"id":12245,"date":"2022-11-18T13:00:00","date_gmt":"2022-11-18T12:00:00","guid":{"rendered":"https:\/\/carontestudio.com\/blog\/?p=12245"},"modified":"2022-11-21T17:05:36","modified_gmt":"2022-11-21T16:05:36","slug":"obtener-consultas-sql-en-prestashop","status":"publish","type":"post","link":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/","title":{"rendered":"Obtener consultas SQL en PrestaShop"},"content":{"rendered":"\n

En ocasiones, necesitamos obtener de la base de datos de PrestaShop datos de clientes, facturas, emails, productos\u2026 y utilizamos gestores de base de datos como phpMyAdmin, HeidiSQL, etc. A nivel avanzado utilizamos estos gestores porque podemos utilizar todas las instrucciones, pero disponemos de un gestor SQL en Prestashop<\/strong> que nos ofrece la posibilidad de realizar solo (por seguridad) consultas SELECT y guardarlas para utilizarlas cuando las necesitemos. <\/p>\n\n\n\n

Os ense\u00f1o d\u00f3nde se esconde esta funcionalidad en PrestaShop 1.7<\/p>\n\n\n\n

Dentro del men\u00fa del Back-Office de PrestaShop disponemos de un apartado en par\u00e1metros avanzados llamado Base de datos<\/strong>. En \u00e9l disponemos de dos opciones, gestor SQL y respaldar base de datos.\u00a0\u00a0<\/p>\n\n\n\n

Respaldar base de datos sirve para crear copias de seguridad y restaurarlas si hicieran falta en 10 sencillos pasos. No hay mucho m\u00e1s que explicar de este apartado, solo decir que precauci\u00f3n con este proceso.<\/p>\n\n\n\n

Gestor SQL de PrestaShop<\/h2>\n\n\n\n

En el gestor de SQL podemos crear y almacenar nuestras consultas del d\u00eda a d\u00eda<\/strong>. Por ejemplo, los usuarios que se han apuntado a nuestra newsletter.<\/p>\n\n\n\n

\u00bfC\u00f3mo crear una consulta en el gestor SQL de PrestaShop?<\/h3>\n\n\n\n
  1. Hacemos clic en \u00abA\u00f1adir una nueva consulta SQL\u00bb.<\/li>
  2. Nombramos la consulta para diferenciarla.<\/li>
  3. Creamos la consulta ayud\u00e1ndonos de las secciones de exploraci\u00f3n de base de datos. \u201cLista de las tablas MySQL\u201d y \u201cLista de atributos para la tabla escogida\u201d<\/li>
  4. Guardamos.<\/li>
  5. A continuaci\u00f3n, podemos ver los resultados de la consulta haciendo clic en la acci\u00f3n \u00abVer<\/strong>\u00bb en el men\u00fa desplegable o exportar los resultados de la consulta como un archivo CSV haciendo clic en el bot\u00f3n \u00abExportar<\/strong>\u00ab. Tambi\u00e9n podemos editarla o borrarla.<\/li><\/ol>\n\n\n\n
    <\/div>\n\n\n\n

    El \u00fanico ajuste que se puede seleccionar es el tipo de codificaci\u00f3n de caracteres a utilizar: UTF-8 o ISO-8859-1<\/p>\n\n\n

    \n
    \"Ajuste
    Selecci\u00f3n de ajuste de codificaci\u00f3n de las consultas guardadas en el gestor de base de datos de PrestaShop<\/figcaption><\/figure>\n<\/div>\n\n\n

    Ejemplo de usuarios registrados a la newsletter de nuestra tienda online<\/h4>\n\n\n\n
    SELECT id, email, newsletter_date_add, ip_registration_newsletter\n\nFROM emailsubscription   \n\nWHERE active = 1\n<\/code><\/pre>\n\n\n\n
    La sentencia dice: seleccionamos las columnas id, email, newsletter_date_add y ip_registration_newsletter de la tabla emailsubscription donde la columna active sea igual a 1, es decir, est\u00e9n activos.<\/p>\n\n\n
    \n
    \"Consultas
    Consultas guardadas en el gestor de base de datos de PrestaShop<\/figcaption><\/figure>\n<\/div>\n\n\n
    Hacemos clic en la opci\u00f3n ver y obtendremos los resultados:<\/p>\n\n\n\n
    id<\/strong><\/td>email<\/strong><\/td>newsletter_date_add<\/strong><\/td>ip_registration_newsletter<\/strong><\/td><\/tr>
    1<\/td>usuario1@gmail.com<\/td>2022-11-18 18:12:54<\/td>000.000.000.000<\/td><\/tr>
    2<\/td>usuario2@hotmail.com<\/td>2022-11-19 13:10:05<\/td>000.000.000.000<\/td><\/tr>
    3<\/td>usuario3@gmail.com<\/td>2022-11-20 17:08:44<\/td>000.000.000.000<\/td><\/tr>
    4<\/td>usuario4@gmail.com<\/td>2022-11-21 11:32:21<\/td>000.000.000.000<\/td><\/tr>
    5<\/td>usuario5@icloud.com<\/td>2022-11-22 21:12:34<\/td>000.000.000.000<\/td><\/tr><\/tbody><\/table>
    Resultado de consulta SQL: Listado de emails con newsletter activa<\/figcaption><\/figure>\n\n\n\n
    Conclusiones<\/strong><\/h2>\n\n\n\n
    Como veis con esta caracter\u00edstica de PrestaShop, no necesitamos programas externos para hacer consultas en la base de datos de nuestra tienda online<\/strong>. Solo necesitamos saber crear consultas o tirar de sentencias encontradas en Internet.<\/p>\n\n\n\n
    Lo mejor es que en cualquier momento podemos acceder y exportar los datos deseados en una hoja de c\u00e1lculo.<\/p>\n\n\n\n
    \u00a1Nos vemos en la pr\u00f3xima! Chaito.<\/p>\n\n\n\n
    \n
    \n
    \n
    \n
    \"Nuevo
    PrestaShop 8 (aka 1.8) ya est\u00e1 aqu\u00ed<\/a><\/figcaption><\/figure>\n<\/div>\n\n\n\n
    \n
    \"PrestaShop:<\/a>
    Migrar PrestaShop de local a otro servidor<\/a><\/figcaption><\/figure>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
    \u00bfSabes que PrestaShop dispone de un gestor de base de datos para descargar los datos que contiene? Te muestro d\u00f3nde est\u00e1 y c\u00f3mo usarlo<\/p>\n","protected":false},"author":5,"featured_media":12262,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[50],"tags":[63],"class_list":["post-12245","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programacion-web","tag-prestashop"],"acf":[],"yoast_head":"\nObtener consultas SQL en PrestaShop - Caronte Web Studio<\/title>\n<meta name=\"description\" content=\"Obt\u00e9n los datos de tu tienda online con el gestor de SQL que nos ofrece PrestaShop, sin necesidad de gestores externos\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u00edtulo P\u00e1gina Separador Caronte Web Studio\" \/>\n<meta property=\"og:description\" content=\"Obt\u00e9n los datos de tu tienda online con el gestor de SQL que nos ofrece PrestaShop, sin necesidad de gestores externos\" \/>\n<meta property=\"og:url\" content=\"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de maketing | Caronte\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/carontewebstudio\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-18T12:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-21T16:05:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/carontestudio.com\/blog\/wp-content\/uploads\/2022\/11\/obtener-consultas-sql-en-prestashop.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1250\" \/>\n\t<meta property=\"og:image:height\" content=\"737\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Gorka Gallego\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"T\u00edtulo P\u00e1gina Separador Caronte Web Studio\" \/>\n<meta name=\"twitter:description\" content=\"Obt\u00e9n los datos de tu tienda online con el gestor de SQL que nos ofrece PrestaShop, sin necesidad de gestores externos\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/carontestudio.com\/blog\/wp-content\/uploads\/2022\/11\/obtener-consultas-sql-en-prestashop.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gorka Gallego\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/obtener-consultas-sql-en-prestashop\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/obtener-consultas-sql-en-prestashop\\\/\"},\"author\":{\"name\":\"Gorka Gallego\",\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/#\\\/schema\\\/person\\\/de698def3f3805fcdfacc9863dfb963b\"},\"headline\":\"Obtener consultas SQL en PrestaShop\",\"datePublished\":\"2022-11-18T12:00:00+00:00\",\"dateModified\":\"2022-11-21T16:05:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/obtener-consultas-sql-en-prestashop\\\/\"},\"wordCount\":507,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/obtener-consultas-sql-en-prestashop\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/obtener-consultas-sql-en-prestashop.jpg\",\"keywords\":[\"PrestaShop\"],\"articleSection\":[\"Programaci\u00f3n\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/carontestudio.com\\\/blog\\\/obtener-consultas-sql-en-prestashop\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/obtener-consultas-sql-en-prestashop\\\/\",\"url\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/obtener-consultas-sql-en-prestashop\\\/\",\"name\":\"Obtener consultas SQL en PrestaShop - Caronte Web Studio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/obtener-consultas-sql-en-prestashop\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/obtener-consultas-sql-en-prestashop\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/obtener-consultas-sql-en-prestashop.jpg\",\"datePublished\":\"2022-11-18T12:00:00+00:00\",\"dateModified\":\"2022-11-21T16:05:36+00:00\",\"description\":\"Obt\u00e9n los datos de tu tienda online con el gestor de SQL que nos ofrece PrestaShop, sin necesidad de gestores externos\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/obtener-consultas-sql-en-prestashop\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/carontestudio.com\\\/blog\\\/obtener-consultas-sql-en-prestashop\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/obtener-consultas-sql-en-prestashop\\\/#primaryimage\",\"url\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/obtener-consultas-sql-en-prestashop.jpg\",\"contentUrl\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/obtener-consultas-sql-en-prestashop.jpg\",\"width\":1250,\"height\":737,\"caption\":\"Obtener consultas SQL con el gestor de base de datos de PrestaShop\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/obtener-consultas-sql-en-prestashop\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Obtener consultas SQL en PrestaShop\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/\",\"name\":\"Blog de marketing | Caronte\",\"description\":\"En nuestro blog encontrar\u00e1s art\u00edculos semanales sobre SEO, marketing online, programaci\u00f3n web y mucho m\u00e1s.\",\"publisher\":{\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/#organization\",\"name\":\"Caronte - Agencia de marketing\",\"url\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/caronte-agencia-de-marketing-logo.png\",\"contentUrl\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/caronte-agencia-de-marketing-logo.png\",\"width\":1090,\"height\":155,\"caption\":\"Caronte - Agencia de marketing\"},\"image\":{\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/carontewebstudio\\\/\",\"https:\\\/\\\/www.instagram.com\\\/caronte_studio\\\/\",\"https:\\\/\\\/www.tiktok.com\\\/@carontewebstudio\",\"https:\\\/\\\/www.youtube.com\\\/@carontewebstudio\",\"https:\\\/\\\/es.linkedin.com\\\/company\\\/carontewebstudio\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/#\\\/schema\\\/person\\\/de698def3f3805fcdfacc9863dfb963b\",\"name\":\"Gorka Gallego\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f568f008c60a7aed96b78db1cc4677776c6840751f2cea14a7b2bb4899c6e58c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f568f008c60a7aed96b78db1cc4677776c6840751f2cea14a7b2bb4899c6e58c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f568f008c60a7aed96b78db1cc4677776c6840751f2cea14a7b2bb4899c6e58c?s=96&d=mm&r=g\",\"caption\":\"Gorka Gallego\"},\"description\":\"Nuestro experto en SEM Gorka Gallego te cuenta c\u00f3mo mejorar tus campa\u00f1as de anuncios de Google ADS. Dispara tus visitas de tr\u00e1fico pagado. Dise\u00f1a una campa\u00f1a de anuncios desde cero y descubre todos los secretos de Adwords\",\"sameAs\":[\"https:\\\/\\\/carontestudio.com\"],\"url\":\"https:\\\/\\\/carontestudio.com\\\/blog\\\/author\\\/gorka-gallego\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Obtener consultas SQL en PrestaShop - Caronte Web Studio","description":"Obt\u00e9n los datos de tu tienda online con el gestor de SQL que nos ofrece PrestaShop, sin necesidad de gestores externos","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/","og_locale":"es_ES","og_type":"article","og_title":"T\u00edtulo P\u00e1gina Separador Caronte Web Studio","og_description":"Obt\u00e9n los datos de tu tienda online con el gestor de SQL que nos ofrece PrestaShop, sin necesidad de gestores externos","og_url":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/","og_site_name":"Blog de maketing | Caronte","article_publisher":"https:\/\/www.facebook.com\/carontewebstudio\/","article_published_time":"2022-11-18T12:00:00+00:00","article_modified_time":"2022-11-21T16:05:36+00:00","og_image":[{"width":1250,"height":737,"url":"https:\/\/carontestudio.com\/blog\/wp-content\/uploads\/2022\/11\/obtener-consultas-sql-en-prestashop.jpg","type":"image\/jpeg"}],"author":"Gorka Gallego","twitter_card":"summary_large_image","twitter_title":"T\u00edtulo P\u00e1gina Separador Caronte Web Studio","twitter_description":"Obt\u00e9n los datos de tu tienda online con el gestor de SQL que nos ofrece PrestaShop, sin necesidad de gestores externos","twitter_image":"https:\/\/carontestudio.com\/blog\/wp-content\/uploads\/2022\/11\/obtener-consultas-sql-en-prestashop.jpg","twitter_misc":{"Escrito por":"Gorka Gallego","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/#article","isPartOf":{"@id":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/"},"author":{"name":"Gorka Gallego","@id":"https:\/\/carontestudio.com\/blog\/#\/schema\/person\/de698def3f3805fcdfacc9863dfb963b"},"headline":"Obtener consultas SQL en PrestaShop","datePublished":"2022-11-18T12:00:00+00:00","dateModified":"2022-11-21T16:05:36+00:00","mainEntityOfPage":{"@id":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/"},"wordCount":507,"commentCount":0,"publisher":{"@id":"https:\/\/carontestudio.com\/blog\/#organization"},"image":{"@id":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/#primaryimage"},"thumbnailUrl":"https:\/\/carontestudio.com\/blog\/wp-content\/uploads\/2022\/11\/obtener-consultas-sql-en-prestashop.jpg","keywords":["PrestaShop"],"articleSection":["Programaci\u00f3n"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/","url":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/","name":"Obtener consultas SQL en PrestaShop - Caronte Web Studio","isPartOf":{"@id":"https:\/\/carontestudio.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/#primaryimage"},"image":{"@id":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/#primaryimage"},"thumbnailUrl":"https:\/\/carontestudio.com\/blog\/wp-content\/uploads\/2022\/11\/obtener-consultas-sql-en-prestashop.jpg","datePublished":"2022-11-18T12:00:00+00:00","dateModified":"2022-11-21T16:05:36+00:00","description":"Obt\u00e9n los datos de tu tienda online con el gestor de SQL que nos ofrece PrestaShop, sin necesidad de gestores externos","breadcrumb":{"@id":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/#primaryimage","url":"https:\/\/carontestudio.com\/blog\/wp-content\/uploads\/2022\/11\/obtener-consultas-sql-en-prestashop.jpg","contentUrl":"https:\/\/carontestudio.com\/blog\/wp-content\/uploads\/2022\/11\/obtener-consultas-sql-en-prestashop.jpg","width":1250,"height":737,"caption":"Obtener consultas SQL con el gestor de base de datos de PrestaShop"},{"@type":"BreadcrumbList","@id":"https:\/\/carontestudio.com\/blog\/obtener-consultas-sql-en-prestashop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/carontestudio.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Obtener consultas SQL en PrestaShop"}]},{"@type":"WebSite","@id":"https:\/\/carontestudio.com\/blog\/#website","url":"https:\/\/carontestudio.com\/blog\/","name":"Blog de marketing | Caronte","description":"En nuestro blog encontrar\u00e1s art\u00edculos semanales sobre SEO, marketing online, programaci\u00f3n web y mucho m\u00e1s.","publisher":{"@id":"https:\/\/carontestudio.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/carontestudio.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/carontestudio.com\/blog\/#organization","name":"Caronte - Agencia de marketing","url":"https:\/\/carontestudio.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/carontestudio.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/carontestudio.com\/blog\/wp-content\/uploads\/2025\/06\/caronte-agencia-de-marketing-logo.png","contentUrl":"https:\/\/carontestudio.com\/blog\/wp-content\/uploads\/2025\/06\/caronte-agencia-de-marketing-logo.png","width":1090,"height":155,"caption":"Caronte - Agencia de marketing"},"image":{"@id":"https:\/\/carontestudio.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/carontewebstudio\/","https:\/\/www.instagram.com\/caronte_studio\/","https:\/\/www.tiktok.com\/@carontewebstudio","https:\/\/www.youtube.com\/@carontewebstudio","https:\/\/es.linkedin.com\/company\/carontewebstudio"]},{"@type":"Person","@id":"https:\/\/carontestudio.com\/blog\/#\/schema\/person\/de698def3f3805fcdfacc9863dfb963b","name":"Gorka Gallego","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/f568f008c60a7aed96b78db1cc4677776c6840751f2cea14a7b2bb4899c6e58c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f568f008c60a7aed96b78db1cc4677776c6840751f2cea14a7b2bb4899c6e58c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f568f008c60a7aed96b78db1cc4677776c6840751f2cea14a7b2bb4899c6e58c?s=96&d=mm&r=g","caption":"Gorka Gallego"},"description":"Nuestro experto en SEM Gorka Gallego te cuenta c\u00f3mo mejorar tus campa\u00f1as de anuncios de Google ADS. Dispara tus visitas de tr\u00e1fico pagado. Dise\u00f1a una campa\u00f1a de anuncios desde cero y descubre todos los secretos de Adwords","sameAs":["https:\/\/carontestudio.com"],"url":"https:\/\/carontestudio.com\/blog\/author\/gorka-gallego\/"}]}},"_links":{"self":[{"href":"https:\/\/carontestudio.com\/blog\/wp-json\/wp\/v2\/posts\/12245","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/carontestudio.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/carontestudio.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/carontestudio.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/carontestudio.com\/blog\/wp-json\/wp\/v2\/comments?post=12245"}],"version-history":[{"count":25,"href":"https:\/\/carontestudio.com\/blog\/wp-json\/wp\/v2\/posts\/12245\/revisions"}],"predecessor-version":[{"id":12309,"href":"https:\/\/carontestudio.com\/blog\/wp-json\/wp\/v2\/posts\/12245\/revisions\/12309"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/carontestudio.com\/blog\/wp-json\/wp\/v2\/media\/12262"}],"wp:attachment":[{"href":"https:\/\/carontestudio.com\/blog\/wp-json\/wp\/v2\/media?parent=12245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/carontestudio.com\/blog\/wp-json\/wp\/v2\/categories?post=12245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/carontestudio.com\/blog\/wp-json\/wp\/v2\/tags?post=12245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}