GX-Entwicklung

SEO BOOST Suche nach doppelten URL Keywords verbessern

Bei Shops mit vielen Artikel mehr als 100 000 kann es durch diese Reparatur zu erheblichen Serverbelastungen kommen und damit den Shop für mehrere Minuten lahmlegen.

SEO BOOST Improve search for duplicate URL keywords.

For stores with many items more than 100 000, this repair can cause significant server loads and thus paralyze the store for several minutes.

$t_get_double_keywords = xtc_db_query("SELECT DISTINCT
a.products_id,
a.gm_url_keywords
FROM " . TABLE_PRODUCTS_DESCRIPTION . " a
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " AS b ON (
a.gm_url_keywords = b.gm_url_keywords)
WHERE
a.products_id != b.products_id
AND a.language_id = '" . $c_languages_id . "'
AND b.language_id = '" . $c_languages_id . "'
ORDER BY a.products_id", 'db_link', false);