Wiki Forum
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('Starter'), LOWER(content))-30 <=1, IF (LENGTH(content) > 300, CONCAT(SUBSTRING(content,1,300),'...'), SUBSTRING(content,1,300)), CONCAT('...',SUBSTRING(content, LOCATE(LOWER('Starter'), LOWER(content))-30, 300),'...')) AS snippet, IF (url LIKE 'https://wiki.trenz-electronic.de/%', 1, 0) as ranking_iswiki, ((IF (title LIKE '%Starter%', 1, 0))+(IF (title LIKE '%Kit%', 1, 0))+(IF (title LIKE '%TE0808%', 1, 0))) as ranking_words_exists, (ROUND(((LENGTH(title)-LENGTH(REPLACE(LOWER(title),LOWER('Starter'),'')))/LENGTH(LOWER('Starter'))))+ROUND(((LENGTH(title)-LENGTH(REPLACE(LOWER(title),LOWER('Kit'),'')))/LENGTH(LOWER('Kit'))))+ROUND(((LENGTH(title)-LENGTH(REPLACE(LOWER(title),LOWER('TE0808'),'')))/LENGTH(LOWER('TE0808'))))) AS ranking_title, (ROUND(((LENGTH(url)-LENGTH(REPLACE(LOWER(url),LOWER('Starter'),'')))/LENGTH(LOWER('Starter'))))+ROUND(((LENGTH(url)-LENGTH(REPLACE(LOWER(url),LOWER('Kit'),'')))/LENGTH(LOWER('Kit'))))+ROUND(((LENGTH(url)-LENGTH(REPLACE(LOWER(url),LOWER('TE0808'),'')))/LENGTH(LOWER('TE0808'))))) AS ranking_url, (ROUND(((LENGTH(title)-LENGTH(REPLACE(LOWER(title),LOWER('Starter'),'')))/LENGTH(LOWER('Starter')) +(LENGTH(description)-LENGTH(REPLACE(LOWER(description),LOWER('Starter'),'')))/LENGTH(LOWER('Starter')) +(LENGTH(content)-LENGTH(REPLACE(LOWER(content),LOWER('Starter'),'')))/LENGTH(LOWER('Starter')) ))+ROUND(((LENGTH(title)-LENGTH(REPLACE(LOWER(title),LOWER('Kit'),'')))/LENGTH(LOWER('Kit')) +(LENGTH(description)-LENGTH(REPLACE(LOWER(description),LOWER('Kit'),'')))/LENGTH(LOWER('Kit')) +(LENGTH(content)-LENGTH(REPLACE(LOWER(content),LOWER('Kit'),'')))/LENGTH(LOWER('Kit')) ))+ROUND(((LENGTH(title)-LENGTH(REPLACE(LOWER(title),LOWER('TE0808'),'')))/LENGTH(LOWER('TE0808')) +(LENGTH(description)-LENGTH(REPLACE(LOWER(description),LOWER('TE0808'),'')))/LENGTH(LOWER('TE0808')) +(LENGTH(content)-LENGTH(REPLACE(LOWER(content),LOWER('TE0808'),'')))/LENGTH(LOWER('TE0808')) ))) AS ranking_full FROM slurp_index WHERE ((title LIKE '%Starter%' OR description LIKE '%Starter%' OR content LIKE '%Starter%' OR url LIKE '%Starter%') AND (title LIKE '%Kit%' OR description LIKE '%Kit%' OR content LIKE '%Kit%' OR url LIKE '%Kit%') AND (title LIKE '%TE0808%' OR description LIKE '%TE0808%' OR content LIKE '%TE0808%' OR url LIKE '%TE0808%')) 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

This website uses cookies, which are necessary for the technical operation of the website and are always set. Other cookies, which increase the usability of this website, serve for direct advertising or simplify interaction with other websites and social networks, will only be used with your consent. More information
Decline Accept all Configure