Skip to content

Instantly share code, notes, and snippets.

@Lathanao

Lathanao/Clean Prestashop Database Queries.sql

Last active November 16, 2023 17:27
Show Gist options
  • Save Lathanao/62e0a67685c7d3c9b0804479f477a55a to your computer and use it in GitHub Desktop.
Save Lathanao/62e0a67685c7d3c9b0804479f477a55a to your computer and use it in GitHub Desktop.
Download ZIP
Clean Prestashop Database Queries
Raw
Clean Prestashop Database Queries.sql
DELETE FROM ps_search_index
WHERE id_product not in (select id_product from ps_product);
DELETE FROM ps_search_word
WHERE id_word not in (select id_word from ps_search_index);
OPTIMIZE TABLE ps_search_index;
OPTIMIZE TABLE ps_search_word;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment