441 lines
108 KiB
Plaintext
Executable File
441 lines
108 KiB
Plaintext
Executable File
KB Search - User Query: Que me puedes decir sobre la temporada 5?KB Search - Search Query (lowercase): KB Search - Found Mapping: ["General","season"]KB Search - Term after season adjustment: temporada 5KB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["temporada 5","temporada 5%","%temporada 5%","%temporada 5%","%temporada 5%","%temporada 5%","temporada 5","temporada 5%","%temporada 5%","%temporada 5%","%temporada 5%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Search - User Query: hero zombie ghostKB Search - Search Query (lowercase): KB Search - Found Mapping: ["Heroes","hero"]KB Search - Term after season adjustment: heroKB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["hero","hero%","%hero%","%hero%","%hero%","%hero%","hero","hero%","%hero%","%hero%","%hero%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Search - User Query: Que me puedes decir sobre la temporada 5?KB Search - Search Query (lowercase): KB Search - Found Mapping: ["General","season"]KB Search - Term after season adjustment: temporada 5KB Search - Translated Spanish season term to English: season 5KB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["season 5","season 5%","%season 5%","%season 5%","%season 5%","%season 5%","season 5","season 5%","%season 5%","%season 5%","%season 5%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Search - User Query: hero zombie ghostKB Search - Search Query (lowercase): KB Search - Found Mapping: ["Heroes","hero"]KB Search - Term after season adjustment: heroKB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["hero","hero%","%hero%","%hero%","%hero%","%hero%","hero","hero%","%hero%","%hero%","%hero%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Search - User Query: Que me puedes decir sobre la season 5?KB Search - Search Query (lowercase): KB Search - Found Mapping: ["General","season"]KB Search - Term after season adjustment: season 5KB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["season 5","season 5%","%season 5%","%season 5%","%season 5%","%season 5%","season 5","season 5%","%season 5%","%season 5%","%season 5%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Search - User Query: hero zombie ghostKB Search - Search Query (lowercase): KB Search - Found Mapping: ["Heroes","hero"]KB Search - Term after season adjustment: heroKB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["hero","hero%","%hero%","%hero%","%hero%","%hero%","hero","hero%","%hero%","%hero%","%hero%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar2KB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Search - User Query: Que me puedes decir sobre la season 5?KB Search - Search Query (lowercase): KB Search - Found Mapping: ["General","season"]KB Search - Term after season adjustment: season 5KB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["season 5","season 5%","%season 5%","%season 5%","%season 5%","%season 5%","season 5","season 5%","%season 5%","%season 5%","%season 5%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Search - User Query: hero zombie ghostKB Search - Search Query (lowercase): KB Search - Found Mapping: ["Heroes","hero"]KB Search - Term after season adjustment: heroKB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["hero","hero%","%hero%","%hero%","%hero%","%hero%","hero","hero%","%hero%","%hero%","%hero%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar2KB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Search - User Query: Que me puedes decir sobre la temporada 5?KB Search - Search Query (lowercase): KB Search - Found Mapping: ["General","season"]KB Search - Term after season adjustment: temporada 5KB Search - Translated Spanish season term to English: season 5KB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["season 5","season 5%","%season 5%","%season 5%","%season 5%","%season 5%","season 5","season 5%","%season 5%","%season 5%","%season 5%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Search - User Query: hero zombie ghostKB Search - Search Query (lowercase): KB Search - Found Mapping: ["Heroes","hero"]KB Search - Term after season adjustment: heroKB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["hero","hero%","%hero%","%hero%","%hero%","%hero%","hero","hero%","%hero%","%hero%","%hero%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar2KB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Search - User Query: Que me puedes decir sobre la temporada 5?KB Search - Search Query (lowercase): KB Search - Found Mapping: ["General","season"]KB Search - Term after season adjustment: temporada 5KB Search - Translated Spanish season term to English: season 5KB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["season 5","season 5%","%season 5%","%season 5%","%season 5%","%season 5%","season 5","season 5%","%season 5%","%season 5%","%season 5%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Search - User Query: hero zombie ghostKB Search - Search Query (lowercase): KB Search - Found Mapping: ["Heroes","hero"]KB Search - Term after season adjustment: heroKB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["hero","hero%","%hero%","%hero%","%hero%","%hero%","hero","hero%","%hero%","%hero%","%hero%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar2KB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Search - User Query: Que me puedes decir sobre la temporada 5?KB Search - Search Query (lowercase): KB Search - Found Mapping: ["General","season"]KB Search - Term after season adjustment: temporada 5KB Search - Translated Spanish season term to English: season 5KB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["season 5","season 5%","%season 5%","%season 5%","%season 5%","%season 5%","season 5","season 5%","%season 5%","%season 5%","%season 5%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Search - User Query: hero zombie ghostKB Search - Search Query (lowercase): KB Search - Found Mapping: ["Heroes","hero"]KB Search - Term after season adjustment: heroKB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["hero","hero%","%hero%","%hero%","%hero%","%hero%","hero","hero%","%hero%","%hero%","%hero%"]KB Search Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lastwar2.knowledge_base' doesn't existKB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar_mysqlKB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar_mysqlKB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Search - User Query: Que me puedes decir sobre la temporada 5?KB Search - Found Mapping: ["General","season"]KB Search - Term after season adjustment: temporada 5KB Search - Translated Spanish season term to English: season 5KB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["season 5","season 5%","%season 5%","%season 5%","%season 5%","%season 5%","season 5","season 5%","%season 5%","%season 5%","%season 5%"]KB Search - Mapped Results: [{"id":6207,"topic":"Season 5","entity_type":"general","entity_name":"Season 5 Professions \u2013 Profession cap at Level 100, new seasonal skills:\u00a0Banker, Barista, Gunslinger Wager, Train Plunderer \/ Consigner \/ Protection","content_preview":"In Season 5 the Level Cap for professions is at Lv.100 and new seasonal skills are available.\nIf you are looking for professions for other Seasons you can find them in these articles:\n- Season 1 \u2013 Professions\nSeason 1 \u2013 Professions\n- \ud83e\uddca\u00a0Season 2 \u2013 Professions\n\ud83e\uddca\u00a0Season 2 \u2013 Professions\n- \u2600\ufe0f Season 3 \u2013 Professions\n\u2600\ufe0f Season 3 \u2013 Professions\n- \ud83c\udf38 Season 4 \u2013 Professions\nSeason 4 \u2013 Professions\n- Video Overview\nProfessions in Season 5 work the same way they did in earlier seasons.\n2 professions are availa...","article_url":"https:\/\/www.lastwartutorial.com\/season-5-professions\/","article_title":"Season 5 Professions \u2013 Profession cap at Level 100, new seasonal skills:\u00a0Banker, Barista, Gunslinger Wager, Train Plunderer \/ Consigner \/ Protection"},{"id":6400,"topic":"Alliances","entity_type":"building","entity_name":"an off","content_preview":"At the end of \ud83e\udd20 Season 5 \u2013 Wild West the game will enter an off-season phase.\n\ud83e\udd20 Season 5 \u2013 Wild West\nIn early servers we saw the following timeline:\n- Week 8 of Season 5: Transfer Surge event start\n- Week 1 off-season: Return of Alliance Exercise and Zombie Siege\n- Week 2 off-season: Season 5 Celebration Week 1\n- [more coming soon\u2026]\n\ud83e\udd20 Season 5 \u2013 Wild West guides are divided into more articles to keep these guides mobile friendly:\n\ud83e\udd20 Season 5 \u2013 Wild West\n- Season 5 \u2013 Main Overview\n- Season 5 \u2013 Pre...","article_url":"https:\/\/www.lastwartutorial.com\/season-5-celebration\/","article_title":"Season 5 Celebration \u2013 Transfer Surge, Bingo Task, Black Market, Champion Duel, Return of Alliance Exercise and Zombie Siege"},{"id":6401,"topic":"Alliances","entity_type":"building","entity_name":"event start","content_preview":"At the end of \ud83e\udd20 Season 5 \u2013 Wild West the game will enter an off-season phase.\n\ud83e\udd20 Season 5 \u2013 Wild West\nIn early servers we saw the following timeline:\n- Week 8 of Season 5: Transfer Surge event start\n- Week 1 off-season: Return of Alliance Exercise and Zombie Siege\n- Week 2 off-season: Season 5 Celebration Week 1\n- [more coming soon\u2026]\n\ud83e\udd20 Season 5 \u2013 Wild West guides are divided into more articles to keep these guides mobile friendly:\n\ud83e\udd20 Season 5 \u2013 Wild West\n- Season 5 \u2013 Main Overview\n- Season 5 \u2013 Pre...","article_url":"https:\/\/www.lastwartutorial.com\/season-5-celebration\/","article_title":"Season 5 Celebration \u2013 Transfer Surge, Bingo Task, Black Market, Champion Duel, Return of Alliance Exercise and Zombie Siege"},{"id":6402,"topic":"Alliances","entity_type":"building","entity_name":"off","content_preview":"At the end of \ud83e\udd20 Season 5 \u2013 Wild West the game will enter an off-season phase.\n\ud83e\udd20 Season 5 \u2013 Wild West\nIn early servers we saw the following timeline:\n- Week 8 of Season 5: Transfer Surge event start\n- Week 1 off-season: Return of Alliance Exercise and Zombie Siege\n- Week 2 off-season: Season 5 Celebration Week 1\n- [more coming soon\u2026]\n\ud83e\udd20 Season 5 \u2013 Wild West guides are divided into more articles to keep these guides mobile friendly:\n\ud83e\udd20 Season 5 \u2013 Wild West\n- Season 5 \u2013 Main Overview\n- Season 5 \u2013 Pre...","article_url":"https:\/\/www.lastwartutorial.com\/season-5-celebration\/","article_title":"Season 5 Celebration \u2013 Transfer Surge, Bingo Task, Black Market, Champion Duel, Return of Alliance Exercise and Zombie Siege"},{"id":6403,"topic":"Alliances","entity_type":"building","entity_name":"Return","content_preview":"At the end of \ud83e\udd20 Season 5 \u2013 Wild West the game will enter an off-season phase.\n\ud83e\udd20 Season 5 \u2013 Wild West\nIn early servers we saw the following timeline:\n- Week 8 of Season 5: Transfer Surge event start\n- Week 1 off-season: Return of Alliance Exercise and Zombie Siege\n- Week 2 off-season: Season 5 Celebration Week 1\n- [more coming soon\u2026]\n\ud83e\udd20 Season 5 \u2013 Wild West guides are divided into more articles to keep these guides mobile friendly:\n\ud83e\udd20 Season 5 \u2013 Wild West\n- Season 5 \u2013 Main Overview\n- Season 5 \u2013 Pre...","article_url":"https:\/\/www.lastwartutorial.com\/season-5-celebration\/","article_title":"Season 5 Celebration \u2013 Transfer Surge, Bingo Task, Black Market, Champion Duel, Return of Alliance Exercise and Zombie Siege"},{"id":6404,"topic":"Alliances","entity_type":"building","entity_name":"Zombie Siege","content_preview":"At the end of \ud83e\udd20 Season 5 \u2013 Wild West the game will enter an off-season phase.\n\ud83e\udd20 Season 5 \u2013 Wild West\nIn early servers we saw the following timeline:\n- Week 8 of Season 5: Transfer Surge event start\n- Week 1 off-season: Return of Alliance Exercise and Zombie Siege\n- Week 2 off-season: Season 5 Celebration Week 1\n- [more coming soon\u2026]\n\ud83e\udd20 Season 5 \u2013 Wild West guides are divided into more articles to keep these guides mobile friendly:\n\ud83e\udd20 Season 5 \u2013 Wild West\n- Season 5 \u2013 Main Overview\n- Season 5 \u2013 Pre...","article_url":"https:\/\/www.lastwartutorial.com\/season-5-celebration\/","article_title":"Season 5 Celebration \u2013 Transfer Surge, Bingo Task, Black Market, Champion Duel, Return of Alliance Exercise and Zombie Siege"},{"id":6405,"topic":"Alliances","entity_type":"building","entity_name":"Wild West","content_preview":"At the end of \ud83e\udd20 Season 5 \u2013 Wild West the game will enter an off-season phase.\n\ud83e\udd20 Season 5 \u2013 Wild West\nIn early servers we saw the following timeline:\n- Week 8 of Season 5: Transfer Surge event start\n- Week 1 off-season: Return of Alliance Exercise and Zombie Siege\n- Week 2 off-season: Season 5 Celebration Week 1\n- [more coming soon\u2026]\n\ud83e\udd20 Season 5 \u2013 Wild West guides are divided into more articles to keep these guides mobile friendly:\n\ud83e\udd20 Season 5 \u2013 Wild West\n- Season 5 \u2013 Main Overview\n- Season 5 \u2013 Pre...","article_url":"https:\/\/www.lastwartutorial.com\/season-5-celebration\/","article_title":"Season 5 Celebration \u2013 Transfer Surge, Bingo Task, Black Market, Champion Duel, Return of Alliance Exercise and Zombie Siege"},{"id":6406,"topic":"Alliances","entity_type":"building","entity_name":"Main Overview","content_preview":"At the end of \ud83e\udd20 Season 5 \u2013 Wild West the game will enter an off-season phase.\n\ud83e\udd20 Season 5 \u2013 Wild West\nIn early servers we saw the following timeline:\n- Week 8 of Season 5: Transfer Surge event start\n- Week 1 off-season: Return of Alliance Exercise and Zombie Siege\n- Week 2 off-season: Season 5 Celebration Week 1\n- [more coming soon\u2026]\n\ud83e\udd20 Season 5 \u2013 Wild West guides are divided into more articles to keep these guides mobile friendly:\n\ud83e\udd20 Season 5 \u2013 Wild West\n- Season 5 \u2013 Main Overview\n- Season 5 \u2013 Pre...","article_url":"https:\/\/www.lastwartutorial.com\/season-5-celebration\/","article_title":"Season 5 Celebration \u2013 Transfer Surge, Bingo Task, Black Market, Champion Duel, Return of Alliance Exercise and Zombie Siege"},{"id":6407,"topic":"Alliances","entity_type":"building","entity_name":"Pre","content_preview":"At the end of \ud83e\udd20 Season 5 \u2013 Wild West the game will enter an off-season phase.\n\ud83e\udd20 Season 5 \u2013 Wild West\nIn early servers we saw the following timeline:\n- Week 8 of Season 5: Transfer Surge event start\n- Week 1 off-season: Return of Alliance Exercise and Zombie Siege\n- Week 2 off-season: Season 5 Celebration Week 1\n- [more coming soon\u2026]\n\ud83e\udd20 Season 5 \u2013 Wild West guides are divided into more articles to keep these guides mobile friendly:\n\ud83e\udd20 Season 5 \u2013 Wild West\n- Season 5 \u2013 Main Overview\n- Season 5 \u2013 Pre...","article_url":"https:\/\/www.lastwartutorial.com\/season-5-celebration\/","article_title":"Season 5 Celebration \u2013 Transfer Surge, Bingo Task, Black Market, Champion Duel, Return of Alliance Exercise and Zombie Siege"},{"id":6408,"topic":"Alliances","entity_type":"building","entity_name":"Season","content_preview":"At the end of \ud83e\udd20 Season 5 \u2013 Wild West the game will enter an off-season phase.\n\ud83e\udd20 Season 5 \u2013 Wild West\nIn early servers we saw the following timeline:\n- Week 8 of Season 5: Transfer Surge event start\n- Week 1 off-season: Return of Alliance Exercise and Zombie Siege\n- Week 2 off-season: Season 5 Celebration Week 1\n- [more coming soon\u2026]\n\ud83e\udd20 Season 5 \u2013 Wild West guides are divided into more articles to keep these guides mobile friendly:\n\ud83e\udd20 Season 5 \u2013 Wild West\n- Season 5 \u2013 Main Overview\n- Season 5 \u2013 Pre...","article_url":"https:\/\/www.lastwartutorial.com\/season-5-celebration\/","article_title":"Season 5 Celebration \u2013 Transfer Surge, Bingo Task, Black Market, Champion Duel, Return of Alliance Exercise and Zombie Siege"}]KB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar_mysqlKB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Search - User Query: Que me puedes decir sobre la temporada 2?KB Search - Found Mapping: ["General","season"]KB Search - Term after season adjustment: temporada 2KB Search - Translated Spanish season term to English: season 2KB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["season 2","season 2%","%season 2%","%season 2%","%season 2%","%season 2%","season 2","season 2%","%season 2%","%season 2%","%season 2%"]KB Search - Mapped Results: [{"id":10845,"topic":"General","entity_type":"season","entity_name":"Season 2","content_preview":"Get ready for some amazing tools, I will first collect few tools and organize them and then I will share them. Tools specifically designed for features available in Season 1. Tools specifically designed for features available in Season 2.","article_url":"https:\/\/www.lastwartutorial.com\/community\/#gorilla-specialized-training-item-requirements-per-level","article_title":"\ud83c\udf0e Community \u2013 Share your tools, images and strategy books with our amazing community. \u2013 Last War Tutorial - Last War: Survival Game Community Guides"},{"id":2441,"topic":"Season 2","entity_type":"event","entity_name":"Polar Storm","content_preview":"In this article all missions of Season 2 week 7 will be explained.\n\ud83e\uddca Season 2 \u2013 Polar Storm guides are divided into more articles to keep these guides mobile friendly:\nSeason 2 \u2013 Polar Storm\n- Season 2 \u2013 Main Overview\n- Season 2 \u2013 The Ultimate Strategy Guide\n- Season 2 \u2013 Supply Collection Locations\n- Season 2 \u2013 Week 1\n- Season 2 \u2013 Week 2\n- Season 2 \u2013 Week 3\n- Season 2 \u2013 Week 4\n- Season 2 \u2013 Week 5\n- Season 2 \u2013 Week 6\n- Season 2 \u2013 Week 7\n- Season 2 \u2013 Week 8\n- Season 2 \u2013 Celebration\n- Season 2 \u2013 Tr...","article_url":"https:\/\/www.lastwartutorial.com\/season-2-week-7\/","article_title":"Season 2 \u2013 Week 7 \u2013 Cold Wave alert -130 , Faction Duel"},{"id":2442,"topic":"Season 2","entity_type":"event","entity_name":"Main Overview","content_preview":"In this article all missions of Season 2 week 7 will be explained.\n\ud83e\uddca Season 2 \u2013 Polar Storm guides are divided into more articles to keep these guides mobile friendly:\nSeason 2 \u2013 Polar Storm\n- Season 2 \u2013 Main Overview\n- Season 2 \u2013 The Ultimate Strategy Guide\n- Season 2 \u2013 Supply Collection Locations\n- Season 2 \u2013 Week 1\n- Season 2 \u2013 Week 2\n- Season 2 \u2013 Week 3\n- Season 2 \u2013 Week 4\n- Season 2 \u2013 Week 5\n- Season 2 \u2013 Week 6\n- Season 2 \u2013 Week 7\n- Season 2 \u2013 Week 8\n- Season 2 \u2013 Celebration\n- Season 2 \u2013 Tr...","article_url":"https:\/\/www.lastwartutorial.com\/season-2-week-7\/","article_title":"Season 2 \u2013 Week 7 \u2013 Cold Wave alert -130 , Faction Duel"},{"id":2443,"topic":"Season 2","entity_type":"event","entity_name":"The Ultimate Strategy Guide","content_preview":"In this article all missions of Season 2 week 7 will be explained.\n\ud83e\uddca Season 2 \u2013 Polar Storm guides are divided into more articles to keep these guides mobile friendly:\nSeason 2 \u2013 Polar Storm\n- Season 2 \u2013 Main Overview\n- Season 2 \u2013 The Ultimate Strategy Guide\n- Season 2 \u2013 Supply Collection Locations\n- Season 2 \u2013 Week 1\n- Season 2 \u2013 Week 2\n- Season 2 \u2013 Week 3\n- Season 2 \u2013 Week 4\n- Season 2 \u2013 Week 5\n- Season 2 \u2013 Week 6\n- Season 2 \u2013 Week 7\n- Season 2 \u2013 Week 8\n- Season 2 \u2013 Celebration\n- Season 2 \u2013 Tr...","article_url":"https:\/\/www.lastwartutorial.com\/season-2-week-7\/","article_title":"Season 2 \u2013 Week 7 \u2013 Cold Wave alert -130 , Faction Duel"},{"id":2444,"topic":"Season 2","entity_type":"event","entity_name":"Supply Collection Locations","content_preview":"In this article all missions of Season 2 week 7 will be explained.\n\ud83e\uddca Season 2 \u2013 Polar Storm guides are divided into more articles to keep these guides mobile friendly:\nSeason 2 \u2013 Polar Storm\n- Season 2 \u2013 Main Overview\n- Season 2 \u2013 The Ultimate Strategy Guide\n- Season 2 \u2013 Supply Collection Locations\n- Season 2 \u2013 Week 1\n- Season 2 \u2013 Week 2\n- Season 2 \u2013 Week 3\n- Season 2 \u2013 Week 4\n- Season 2 \u2013 Week 5\n- Season 2 \u2013 Week 6\n- Season 2 \u2013 Week 7\n- Season 2 \u2013 Week 8\n- Season 2 \u2013 Celebration\n- Season 2 \u2013 Tr...","article_url":"https:\/\/www.lastwartutorial.com\/season-2-week-7\/","article_title":"Season 2 \u2013 Week 7 \u2013 Cold Wave alert -130 , Faction Duel"},{"id":2445,"topic":"Season 2","entity_type":"event","entity_name":"Celebration","content_preview":"In this article all missions of Season 2 week 7 will be explained.\n\ud83e\uddca Season 2 \u2013 Polar Storm guides are divided into more articles to keep these guides mobile friendly:\nSeason 2 \u2013 Polar Storm\n- Season 2 \u2013 Main Overview\n- Season 2 \u2013 The Ultimate Strategy Guide\n- Season 2 \u2013 Supply Collection Locations\n- Season 2 \u2013 Week 1\n- Season 2 \u2013 Week 2\n- Season 2 \u2013 Week 3\n- Season 2 \u2013 Week 4\n- Season 2 \u2013 Week 5\n- Season 2 \u2013 Week 6\n- Season 2 \u2013 Week 7\n- Season 2 \u2013 Week 8\n- Season 2 \u2013 Celebration\n- Season 2 \u2013 Tr...","article_url":"https:\/\/www.lastwartutorial.com\/season-2-week-7\/","article_title":"Season 2 \u2013 Week 7 \u2013 Cold Wave alert -130 , Faction Duel"},{"id":2446,"topic":"Season 2","entity_type":"event","entity_name":"Cheats","content_preview":"In this article all missions of Season 2 week 7 will be explained.\n\ud83e\uddca Season 2 \u2013 Polar Storm guides are divided into more articles to keep these guides mobile friendly:\nSeason 2 \u2013 Polar Storm\n- Season 2 \u2013 Main Overview\n- Season 2 \u2013 The Ultimate Strategy Guide\n- Season 2 \u2013 Supply Collection Locations\n- Season 2 \u2013 Week 1\n- Season 2 \u2013 Week 2\n- Season 2 \u2013 Week 3\n- Season 2 \u2013 Week 4\n- Season 2 \u2013 Week 5\n- Season 2 \u2013 Week 6\n- Season 2 \u2013 Week 7\n- Season 2 \u2013 Week 8\n- Season 2 \u2013 Celebration\n- Season 2 \u2013 Tr...","article_url":"https:\/\/www.lastwartutorial.com\/season-2-week-7\/","article_title":"Season 2 \u2013 Week 7 \u2013 Cold Wave alert -130 , Faction Duel"},{"id":2447,"topic":"Season 2","entity_type":"event","entity_name":"Min Temp","content_preview":"In this article all missions of Season 2 week 7 will be explained.\n\ud83e\uddca Season 2 \u2013 Polar Storm guides are divided into more articles to keep these guides mobile friendly:\nSeason 2 \u2013 Polar Storm\n- Season 2 \u2013 Main Overview\n- Season 2 \u2013 The Ultimate Strategy Guide\n- Season 2 \u2013 Supply Collection Locations\n- Season 2 \u2013 Week 1\n- Season 2 \u2013 Week 2\n- Season 2 \u2013 Week 3\n- Season 2 \u2013 Week 4\n- Season 2 \u2013 Week 5\n- Season 2 \u2013 Week 6\n- Season 2 \u2013 Week 7\n- Season 2 \u2013 Week 8\n- Season 2 \u2013 Celebration\n- Season 2 \u2013 Tr...","article_url":"https:\/\/www.lastwartutorial.com\/season-2-week-7\/","article_title":"Season 2 \u2013 Week 7 \u2013 Cold Wave alert -130 , Faction Duel"},{"id":2448,"topic":"Season 2","entity_type":"event","entity_name":"Mission goal Reward chest goal","content_preview":"In this article all missions of Season 2 week 7 will be explained.\n\ud83e\uddca Season 2 \u2013 Polar Storm guides are divided into more articles to keep these guides mobile friendly:\nSeason 2 \u2013 Polar Storm\n- Season 2 \u2013 Main Overview\n- Season 2 \u2013 The Ultimate Strategy Guide\n- Season 2 \u2013 Supply Collection Locations\n- Season 2 \u2013 Week 1\n- Season 2 \u2013 Week 2\n- Season 2 \u2013 Week 3\n- Season 2 \u2013 Week 4\n- Season 2 \u2013 Week 5\n- Season 2 \u2013 Week 6\n- Season 2 \u2013 Week 7\n- Season 2 \u2013 Week 8\n- Season 2 \u2013 Celebration\n- Season 2 \u2013 Tr...","article_url":"https:\/\/www.lastwartutorial.com\/season-2-week-7\/","article_title":"Season 2 \u2013 Week 7 \u2013 Cold Wave alert -130 , Faction Duel"},{"id":2449,"topic":"Season 2","entity_type":"event","entity_name":"Mission goal","content_preview":"In this article all missions of Season 2 week 7 will be explained.\n\ud83e\uddca Season 2 \u2013 Polar Storm guides are divided into more articles to keep these guides mobile friendly:\nSeason 2 \u2013 Polar Storm\n- Season 2 \u2013 Main Overview\n- Season 2 \u2013 The Ultimate Strategy Guide\n- Season 2 \u2013 Supply Collection Locations\n- Season 2 \u2013 Week 1\n- Season 2 \u2013 Week 2\n- Season 2 \u2013 Week 3\n- Season 2 \u2013 Week 4\n- Season 2 \u2013 Week 5\n- Season 2 \u2013 Week 6\n- Season 2 \u2013 Week 7\n- Season 2 \u2013 Week 8\n- Season 2 \u2013 Celebration\n- Season 2 \u2013 Tr...","article_url":"https:\/\/www.lastwartutorial.com\/season-2-week-7\/","article_title":"Season 2 \u2013 Week 7 \u2013 Cold Wave alert -130 , Faction Duel"}]KB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar_mysqlKB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Search - User Query: Que me puedes decir sobre la temporada 3?KB Search - Found Mapping: ["General","season"]KB Search - Term after season adjustment: temporada 3KB Search - Translated Spanish season term to English: season 3KB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["season 3","season 3%","%season 3%","%season 3%","%season 3%","%season 3%","season 3","season 3%","%season 3%","%season 3%","%season 3%"]KB Search - Mapped Results: [{"id":10848,"topic":"General","entity_type":"season","entity_name":"Season 3","content_preview":"Get ready for some amazing tools, I will first collect few tools and organize them and then I will share them. Tools specifically designed for features available in Season 1. Tools specifically designed for features available in Season 2.","article_url":"https:\/\/www.lastwartutorial.com\/community\/#gorilla-specialized-training-item-requirements-per-level","article_title":"\ud83c\udf0e Community \u2013 Share your tools, images and strategy books with our amazing community. \u2013 Last War Tutorial - Last War: Survival Game Community Guides"},{"id":6912,"topic":"Season 3","entity_type":"building","entity_name":"for Constructions","content_preview":"In \u2600\ufe0f Season 3 Golden Kingdom , the Level Cap for professions is extended to Lv.100, and new interesting skills are available.\n\u2600\ufe0f Season 3 Golden Kingdom\nIf you are looking for professions for other Seasons you can find them in these articles:\n- Season 1 \u2013 Professions\nSeason 1 \u2013 Professions\n- \ud83e\uddca\u00a0Season 2 \u2013 Professions\n\ud83e\uddca\u00a0Season 2 \u2013 Professions\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom guides are divided into more articles to keep these guides mobile friendly:\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom\n- Season 3 \u2013 Main Over...","article_url":"https:\/\/www.lastwartutorial.com\/season-3-professions\/","article_title":"Season 3 Professions \u2013 Profession cap extended to Level 100, new seasonal skills: Sandworm Traps, Summon Mummies, Nature\u2019s Touch, Trap Landmines"},{"id":6913,"topic":"Season 3","entity_type":"building","entity_name":"for research","content_preview":"In \u2600\ufe0f Season 3 Golden Kingdom , the Level Cap for professions is extended to Lv.100, and new interesting skills are available.\n\u2600\ufe0f Season 3 Golden Kingdom\nIf you are looking for professions for other Seasons you can find them in these articles:\n- Season 1 \u2013 Professions\nSeason 1 \u2013 Professions\n- \ud83e\uddca\u00a0Season 2 \u2013 Professions\n\ud83e\uddca\u00a0Season 2 \u2013 Professions\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom guides are divided into more articles to keep these guides mobile friendly:\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom\n- Season 3 \u2013 Main Over...","article_url":"https:\/\/www.lastwartutorial.com\/season-3-professions\/","article_title":"Season 3 Professions \u2013 Profession cap extended to Level 100, new seasonal skills: Sandworm Traps, Summon Mummies, Nature\u2019s Touch, Trap Landmines"},{"id":6914,"topic":"Season 3","entity_type":"building","entity_name":"marching speed","content_preview":"In \u2600\ufe0f Season 3 Golden Kingdom , the Level Cap for professions is extended to Lv.100, and new interesting skills are available.\n\u2600\ufe0f Season 3 Golden Kingdom\nIf you are looking for professions for other Seasons you can find them in these articles:\n- Season 1 \u2013 Professions\nSeason 1 \u2013 Professions\n- \ud83e\uddca\u00a0Season 2 \u2013 Professions\n\ud83e\uddca\u00a0Season 2 \u2013 Professions\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom guides are divided into more articles to keep these guides mobile friendly:\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom\n- Season 3 \u2013 Main Over...","article_url":"https:\/\/www.lastwartutorial.com\/season-3-professions\/","article_title":"Season 3 Professions \u2013 Profession cap extended to Level 100, new seasonal skills: Sandworm Traps, Summon Mummies, Nature\u2019s Touch, Trap Landmines"},{"id":6915,"topic":"Season 3","entity_type":"building","entity_name":"Durability Damage","content_preview":"In \u2600\ufe0f Season 3 Golden Kingdom , the Level Cap for professions is extended to Lv.100, and new interesting skills are available.\n\u2600\ufe0f Season 3 Golden Kingdom\nIf you are looking for professions for other Seasons you can find them in these articles:\n- Season 1 \u2013 Professions\nSeason 1 \u2013 Professions\n- \ud83e\uddca\u00a0Season 2 \u2013 Professions\n\ud83e\uddca\u00a0Season 2 \u2013 Professions\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom guides are divided into more articles to keep these guides mobile friendly:\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom\n- Season 3 \u2013 Main Over...","article_url":"https:\/\/www.lastwartutorial.com\/season-3-professions\/","article_title":"Season 3 Professions \u2013 Profession cap extended to Level 100, new seasonal skills: Sandworm Traps, Summon Mummies, Nature\u2019s Touch, Trap Landmines"},{"id":6916,"topic":"Season 3","entity_type":"building","entity_name":"Alliance Exercise","content_preview":"In \u2600\ufe0f Season 3 Golden Kingdom , the Level Cap for professions is extended to Lv.100, and new interesting skills are available.\n\u2600\ufe0f Season 3 Golden Kingdom\nIf you are looking for professions for other Seasons you can find them in these articles:\n- Season 1 \u2013 Professions\nSeason 1 \u2013 Professions\n- \ud83e\uddca\u00a0Season 2 \u2013 Professions\n\ud83e\uddca\u00a0Season 2 \u2013 Professions\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom guides are divided into more articles to keep these guides mobile friendly:\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom\n- Season 3 \u2013 Main Over...","article_url":"https:\/\/www.lastwartutorial.com\/season-3-professions\/","article_title":"Season 3 Professions \u2013 Profession cap extended to Level 100, new seasonal skills: Sandworm Traps, Summon Mummies, Nature\u2019s Touch, Trap Landmines"},{"id":6917,"topic":"Season 3","entity_type":"building","entity_name":"City Durability","content_preview":"In \u2600\ufe0f Season 3 Golden Kingdom , the Level Cap for professions is extended to Lv.100, and new interesting skills are available.\n\u2600\ufe0f Season 3 Golden Kingdom\nIf you are looking for professions for other Seasons you can find them in these articles:\n- Season 1 \u2013 Professions\nSeason 1 \u2013 Professions\n- \ud83e\uddca\u00a0Season 2 \u2013 Professions\n\ud83e\uddca\u00a0Season 2 \u2013 Professions\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom guides are divided into more articles to keep these guides mobile friendly:\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom\n- Season 3 \u2013 Main Over...","article_url":"https:\/\/www.lastwartutorial.com\/season-3-professions\/","article_title":"Season 3 Professions \u2013 Profession cap extended to Level 100, new seasonal skills: Sandworm Traps, Summon Mummies, Nature\u2019s Touch, Trap Landmines"},{"id":6918,"topic":"Season 3","entity_type":"building","entity_name":"casualty rate","content_preview":"In \u2600\ufe0f Season 3 Golden Kingdom , the Level Cap for professions is extended to Lv.100, and new interesting skills are available.\n\u2600\ufe0f Season 3 Golden Kingdom\nIf you are looking for professions for other Seasons you can find them in these articles:\n- Season 1 \u2013 Professions\nSeason 1 \u2013 Professions\n- \ud83e\uddca\u00a0Season 2 \u2013 Professions\n\ud83e\uddca\u00a0Season 2 \u2013 Professions\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom guides are divided into more articles to keep these guides mobile friendly:\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom\n- Season 3 \u2013 Main Over...","article_url":"https:\/\/www.lastwartutorial.com\/season-3-professions\/","article_title":"Season 3 Professions \u2013 Profession cap extended to Level 100, new seasonal skills: Sandworm Traps, Summon Mummies, Nature\u2019s Touch, Trap Landmines"},{"id":6919,"topic":"Season 3","entity_type":"building","entity_name":"including season","content_preview":"In \u2600\ufe0f Season 3 Golden Kingdom , the Level Cap for professions is extended to Lv.100, and new interesting skills are available.\n\u2600\ufe0f Season 3 Golden Kingdom\nIf you are looking for professions for other Seasons you can find them in these articles:\n- Season 1 \u2013 Professions\nSeason 1 \u2013 Professions\n- \ud83e\uddca\u00a0Season 2 \u2013 Professions\n\ud83e\uddca\u00a0Season 2 \u2013 Professions\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom guides are divided into more articles to keep these guides mobile friendly:\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom\n- Season 3 \u2013 Main Over...","article_url":"https:\/\/www.lastwartutorial.com\/season-3-professions\/","article_title":"Season 3 Professions \u2013 Profession cap extended to Level 100, new seasonal skills: Sandworm Traps, Summon Mummies, Nature\u2019s Touch, Trap Landmines"},{"id":6920,"topic":"Season 3","entity_type":"building","entity_name":"hour","content_preview":"In \u2600\ufe0f Season 3 Golden Kingdom , the Level Cap for professions is extended to Lv.100, and new interesting skills are available.\n\u2600\ufe0f Season 3 Golden Kingdom\nIf you are looking for professions for other Seasons you can find them in these articles:\n- Season 1 \u2013 Professions\nSeason 1 \u2013 Professions\n- \ud83e\uddca\u00a0Season 2 \u2013 Professions\n\ud83e\uddca\u00a0Season 2 \u2013 Professions\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom guides are divided into more articles to keep these guides mobile friendly:\n\u2600\ufe0f Season 3 \u2013 Golden Kingdom\n- Season 3 \u2013 Main Over...","article_url":"https:\/\/www.lastwartutorial.com\/season-3-professions\/","article_title":"Season 3 Professions \u2013 Profession cap extended to Level 100, new seasonal skills: Sandworm Traps, Summon Mummies, Nature\u2019s Touch, Trap Landmines"}]KB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar_mysqlKB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Search - User Query: Cuales son los nombres de los heroes y sus fortalezas?KB Search - Found Mapping: ["Heroes","hero"]KB Search - Term after season adjustment: heroKB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["hero","hero%","%hero%","%hero%","%hero%","%hero%","hero","hero%","%hero%","%hero%","%hero%"]KB Search - Mapped Results: [{"id":256,"topic":"Heroes","entity_type":"hero","entity_name":"Swift","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5376,"topic":"Heroes","entity_type":"event","entity_name":"Super Sensing","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":257,"topic":"Heroes","entity_type":"hero","entity_name":"Thunder","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5377,"topic":"Heroes","entity_type":"event","entity_name":"Passive","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":258,"topic":"Heroes","entity_type":"hero","entity_name":"Tesla","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5378,"topic":"Heroes","entity_type":"event","entity_name":"check it out in this article","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":259,"topic":"Heroes","entity_type":"hero","entity_name":"Williams","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5379,"topic":"Heroes","entity_type":"event","entity_name":"Stand Firm","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":260,"topic":"Heroes","entity_type":"hero","entity_name":"Hunter","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5380,"topic":"Heroes","entity_type":"event","entity_name":"Ironclad Barrier","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"}]KB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar_mysqlKB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Search - User Query: Cuales son los nombres de los heroes ?KB Search - Found Mapping: ["Heroes","hero"]KB Search - Term after season adjustment: heroKB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["hero","hero%","%hero%","%hero%","%hero%","%hero%","hero","hero%","%hero%","%hero%","%hero%"]KB Search - Mapped Results: [{"id":256,"topic":"Heroes","entity_type":"hero","entity_name":"Swift","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5376,"topic":"Heroes","entity_type":"event","entity_name":"Super Sensing","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":257,"topic":"Heroes","entity_type":"hero","entity_name":"Thunder","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5377,"topic":"Heroes","entity_type":"event","entity_name":"Passive","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":258,"topic":"Heroes","entity_type":"hero","entity_name":"Tesla","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5378,"topic":"Heroes","entity_type":"event","entity_name":"check it out in this article","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":259,"topic":"Heroes","entity_type":"hero","entity_name":"Williams","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5379,"topic":"Heroes","entity_type":"event","entity_name":"Stand Firm","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":260,"topic":"Heroes","entity_type":"hero","entity_name":"Hunter","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5380,"topic":"Heroes","entity_type":"event","entity_name":"Ironclad Barrier","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"}]KB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar_mysqlKB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Search - User Query: Cuales son los nombres de los heroes ?KB Search - Found Mapping: ["Heroes","hero"]KB Search - Term after season adjustment: heroKB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["hero","hero%","%hero%","%hero%","%hero%","%hero%","hero","hero%","%hero%","%hero%","%hero%"]KB Search - Mapped Results: [{"id":256,"topic":"Heroes","entity_type":"hero","entity_name":"Swift","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5376,"topic":"Heroes","entity_type":"event","entity_name":"Super Sensing","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":257,"topic":"Heroes","entity_type":"hero","entity_name":"Thunder","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5377,"topic":"Heroes","entity_type":"event","entity_name":"Passive","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":258,"topic":"Heroes","entity_type":"hero","entity_name":"Tesla","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5378,"topic":"Heroes","entity_type":"event","entity_name":"check it out in this article","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":259,"topic":"Heroes","entity_type":"hero","entity_name":"Williams","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5379,"topic":"Heroes","entity_type":"event","entity_name":"Stand Firm","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":260,"topic":"Heroes","entity_type":"hero","entity_name":"Hunter","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5380,"topic":"Heroes","entity_type":"event","entity_name":"Ironclad Barrier","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"}]KB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar_mysqlKB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Search - User Query: Que me puedes decir de Mason?KB Search - Found Mapping: NoneKB Search - Fallback Search Terms: ["decir","mason?"]KB Search - Fallback SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?) AND (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name LIKE ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN content_preview LIKE ? THEN 2
|
|
ELSE 3
|
|
END,
|
|
LENGTH(content_preview) DESC
|
|
LIMIT 10
|
|
KB Search - Fallback Params: ["%decir%","%decir%","%decir%","%mason?%","%mason?%","%mason?%","%decir%","%decir%","%decir%"]KB Search - Fallback Results: []KB Search - User Query: hero zombie ghostKB Search - Found Mapping: ["Heroes","hero"]KB Search - Term after season adjustment: heroKB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["hero","hero%","%hero%","%hero%","%hero%","%hero%","hero","hero%","%hero%","%hero%","%hero%"]KB Search - Mapped Results: [{"id":256,"topic":"Heroes","entity_type":"hero","entity_name":"Swift","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5376,"topic":"Heroes","entity_type":"event","entity_name":"Super Sensing","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":257,"topic":"Heroes","entity_type":"hero","entity_name":"Thunder","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5377,"topic":"Heroes","entity_type":"event","entity_name":"Passive","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":258,"topic":"Heroes","entity_type":"hero","entity_name":"Tesla","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5378,"topic":"Heroes","entity_type":"event","entity_name":"check it out in this article","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":259,"topic":"Heroes","entity_type":"hero","entity_name":"Williams","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5379,"topic":"Heroes","entity_type":"event","entity_name":"Stand Firm","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":260,"topic":"Heroes","entity_type":"hero","entity_name":"Hunter","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5380,"topic":"Heroes","entity_type":"event","entity_name":"Ironclad Barrier","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"}]KB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar_mysqlKB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Search - User Query: Que me puedes decir sobre los heroesKB Search - Found Mapping: ["Heroes","hero"]KB Search - Term after season adjustment: heroKB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["hero","hero%","%hero%","%hero%","%hero%","%hero%","hero","hero%","%hero%","%hero%","%hero%"]KB Search - Mapped Results: [{"id":256,"topic":"Heroes","entity_type":"hero","entity_name":"Swift","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5376,"topic":"Heroes","entity_type":"event","entity_name":"Super Sensing","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":257,"topic":"Heroes","entity_type":"hero","entity_name":"Thunder","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5377,"topic":"Heroes","entity_type":"event","entity_name":"Passive","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":258,"topic":"Heroes","entity_type":"hero","entity_name":"Tesla","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5378,"topic":"Heroes","entity_type":"event","entity_name":"check it out in this article","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":259,"topic":"Heroes","entity_type":"hero","entity_name":"Williams","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5379,"topic":"Heroes","entity_type":"event","entity_name":"Stand Firm","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":260,"topic":"Heroes","entity_type":"hero","entity_name":"Hunter","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5380,"topic":"Heroes","entity_type":"event","entity_name":"Ironclad Barrier","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"}]KB Connection - Host: 10.10.4.17KB Connection - Port: 3391KB Connection - DBName: lastwar_mysqlKB Connection - User: nickpons666KB Connection - PDO connection established successfully.KB Search - User Query: Me puedes explicar que necesito para subir mi base?KB Search - Found Mapping: NoneKB Search - Fallback Search Terms: ["explicar","necesito","subir","base?"]KB Search - Fallback SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?) AND (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?) AND (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?) AND (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name LIKE ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN content_preview LIKE ? THEN 2
|
|
ELSE 3
|
|
END,
|
|
LENGTH(content_preview) DESC
|
|
LIMIT 10
|
|
KB Search - Fallback Params: ["%explicar%","%explicar%","%explicar%","%necesito%","%necesito%","%necesito%","%subir%","%subir%","%subir%","%base?%","%base?%","%base?%","%explicar%","%explicar%","%explicar%"]KB Search - Fallback Results: []KB Search - User Query: hero zombie ghostKB Search - Found Mapping: ["Heroes","hero"]KB Search - Term after season adjustment: heroKB Search - Mapped SQL:
|
|
SELECT id, topic, entity_type, entity_name, content_preview, article_url, article_title
|
|
FROM knowledge_base
|
|
WHERE
|
|
(entity_name = ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
OR (entity_name LIKE ? OR article_title LIKE ? OR content_preview LIKE ?)
|
|
ORDER BY
|
|
CASE
|
|
WHEN entity_name = ? THEN 0
|
|
WHEN article_title LIKE ? THEN 1
|
|
WHEN entity_name LIKE ? THEN 2
|
|
WHEN article_title LIKE ? THEN 3
|
|
WHEN content_preview LIKE ? THEN 4
|
|
ELSE 5
|
|
END,
|
|
LENGTH(content_preview) DESC,
|
|
LENGTH(article_title) ASC
|
|
LIMIT 10
|
|
KB Search - Mapped Params: ["hero","hero%","%hero%","%hero%","%hero%","%hero%","hero","hero%","%hero%","%hero%","%hero%"]KB Search - Mapped Results: [{"id":256,"topic":"Heroes","entity_type":"hero","entity_name":"Swift","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5376,"topic":"Heroes","entity_type":"event","entity_name":"Super Sensing","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":257,"topic":"Heroes","entity_type":"hero","entity_name":"Thunder","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5377,"topic":"Heroes","entity_type":"event","entity_name":"Passive","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":258,"topic":"Heroes","entity_type":"hero","entity_name":"Tesla","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5378,"topic":"Heroes","entity_type":"event","entity_name":"check it out in this article","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":259,"topic":"Heroes","entity_type":"hero","entity_name":"Williams","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5379,"topic":"Heroes","entity_type":"event","entity_name":"Stand Firm","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":260,"topic":"Heroes","entity_type":"hero","entity_name":"Hunter","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"},{"id":5380,"topic":"Heroes","entity_type":"event","entity_name":"Ironclad Barrier","content_preview":"Heroes, their upgrade and their placement in the squads are crucial to being able to win against other players and missions in the game. Here you can find all the information about the best heroes in Last War.\n- Introduction\n- Ability Defense hero Attack Hero Support Hero\n- Defense hero\n- Attack Hero\n- Support Hero\n- Hero Upgrades Experience Level Upgrade Stars\/Tiers Upgrade Skills Upgrade\n- Experience Level Upgrade\n- Stars\/Tiers Upgrade\n- Skills Upgrade\n- Available heroes Mason \u2013 Raging Marksma...","article_url":"https:\/\/www.lastwartutorial.com\/heroes-teams\/","article_title":"Heroes \u2013 Power up your squads with the best heroes with powerful skills"}] |