Cookie preferences
This website uses cookies, which are necessary for the technical operation of the website and are always set. Other cookies, which increase the comfort when using this website, are used for direct advertising or to facilitate interaction with other websites and social networks, are only set with your consent.
Configuration
Technically required
These cookies are necessary for the basic functions of the shop.
"Allow all cookies" cookie
"Decline all cookies" cookie
CSRF token
Cookie preferences
Currency change
Customer-specific caching
Individual prices
Selected shop
Session
Comfort functions
These cookies are used to make the shopping experience even more appealing, for example for the recognition of the visitor.
Note
Statistics & Tracking
Affiliate program
Track device being used
SELECT url,title,description,content,
IF (LOCATE(LOWER('TEB2000'), LOWER(content))-30 <=1,
IF (LENGTH(content) > 300, CONCAT(SUBSTRING(content,1,300),'...'), SUBSTRING(content,1,300)),
CONCAT('...',SUBSTRING(content, LOCATE(LOWER('TEB2000'), LOWER(content))-30, 300),'...')) AS snippet,
IF (url LIKE 'https://wiki.trenz-electronic.de/%', 1, 0) as ranking_iswiki,
((IF (title LIKE '%TEB2000%', 1, 0))) as ranking_words_exists,
(ROUND(((LENGTH(title)-LENGTH(REPLACE(LOWER(title),LOWER('TEB2000'),'')))/LENGTH(LOWER('TEB2000'))))) AS ranking_title,
(ROUND(((LENGTH(url)-LENGTH(REPLACE(LOWER(url),LOWER('TEB2000'),'')))/LENGTH(LOWER('TEB2000'))))) AS ranking_url,
(ROUND(((LENGTH(title)-LENGTH(REPLACE(LOWER(title),LOWER('TEB2000'),'')))/LENGTH(LOWER('TEB2000'))
+(LENGTH(description)-LENGTH(REPLACE(LOWER(description),LOWER('TEB2000'),'')))/LENGTH(LOWER('TEB2000'))
+(LENGTH(content)-LENGTH(REPLACE(LOWER(content),LOWER('TEB2000'),'')))/LENGTH(LOWER('TEB2000'))
))) AS ranking_full
FROM slurp_index
WHERE ((title LIKE '%TEB2000%' OR description LIKE '%TEB2000%' OR content LIKE '%TEB2000%' OR url LIKE '%TEB2000%'))
AND (statuscode=200)
AND (language LIKE 'en%' OR language='')
ORDER BY ranking_iswiki DESC, ranking_words_exists DESC, ranking_title DESC, ranking_url DESC, ranking_full DESC
Individual search
No Matches