Post-second-review fixes for the patch that added the code allowing to use

hash join over equi-join conditions without supporting indexes.

1 files changed, 80 insertions, 2280 deletions

diff --git a/mysql-test/r/join_cache.result b/mysql-test/r/join_cache.result
index f3ac539c98a..cd5984f5099 100644
--- a/mysql-test/r/join_cache.result
+++ b/mysql-test/r/join_cache.result
@@ -71,7 +71,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	Country	ALL	NULL	NULL	NULL	NULL	239	Using where
 1	SIMPLE	CountryLanguage	ALL	NULL	NULL	NULL	NULL	984	Using where; Using join buffer (flat, BNL join)
@@ -81,148 +82,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 set join_cache_level=2;
 show variables like 'join_cache_level';
 Variable_name	Value
@@ -259,7 +149,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	Country	ALL	NULL	NULL	NULL	NULL	239	Using where
 1	SIMPLE	CountryLanguage	ALL	NULL	NULL	NULL	NULL	984	Using where; Using join buffer (flat, BNL join)
@@ -269,148 +160,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 set join_cache_level=3;
 show variables like 'join_cache_level';
 Variable_name	Value
@@ -447,7 +227,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	Country	ALL	NULL	NULL	NULL	NULL	239	Using where
 1	SIMPLE	CountryLanguage	hash	NULL	hj_key	3	world.Country.Code	984	Using where; Using join buffer (flat, BNLH join)
@@ -457,148 +238,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 set join_cache_level=4;
 show variables like 'join_cache_level';
 Variable_name	Value
@@ -635,7 +305,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	Country	ALL	NULL	NULL	NULL	NULL	239	Using where
 1	SIMPLE	City	hash	NULL	hj_key	3	world.Country.Code	4079	Using where; Using join buffer (flat, BNLH join)
@@ -645,148 +316,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 set join_cache_level=default;
 set join_buffer_size=256;
 show variables like 'join_buffer_size';
@@ -827,7 +387,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	Country	ALL	NULL	NULL	NULL	NULL	239	Using where
 1	SIMPLE	City	ALL	NULL	NULL	NULL	NULL	4079	Using where; Using join buffer (flat, BNL join)
@@ -837,148 +398,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 set join_cache_level=2;
 show variables like 'join_cache_level';
 Variable_name	Value
@@ -1015,7 +465,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	Country	ALL	NULL	NULL	NULL	NULL	239	Using where
 1	SIMPLE	City	ALL	NULL	NULL	NULL	NULL	4079	Using where; Using join buffer (flat, BNL join)
@@ -1025,148 +476,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 set join_cache_level=3;
 show variables like 'join_cache_level';
 Variable_name	Value
@@ -1203,7 +543,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	Country	ALL	NULL	NULL	NULL	NULL	239	Using where
 1	SIMPLE	City	hash	NULL	hj_key	3	world.Country.Code	4079	Using where; Using join buffer (flat, BNLH join)
@@ -1213,148 +554,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 set join_cache_level=4;
 show variables like 'join_cache_level';
 Variable_name	Value
@@ -1391,7 +621,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	Country	ALL	NULL	NULL	NULL	NULL	239	Using where
 1	SIMPLE	City	hash	NULL	hj_key	3	world.Country.Code	4079	Using where; Using join buffer (flat, BNLH join)
@@ -1401,148 +632,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 set join_cache_level=default;
 set join_buffer_size=default;
 show variables like 'join_buffer_size';
@@ -1618,7 +738,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	CountryLanguage	ALL	PRIMARY,Percentage	NULL	NULL	NULL	984	Using where
 1	SIMPLE	Country	hash	PRIMARY	PRIMARY	3	world.CountryLanguage.Country	239	Using where; Using join buffer (flat, BNLH join)
@@ -1628,148 +749,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 EXPLAIN
 SELECT Name FROM City
 WHERE City.Country IN (SELECT Code FROM Country WHERE Country.Name LIKE 'L%') AND
@@ -1928,7 +938,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	CountryLanguage	ALL	PRIMARY,Percentage	NULL	NULL	NULL	984	Using where
 1	SIMPLE	Country	hash	PRIMARY	PRIMARY	3	world.CountryLanguage.Country	239	Using where; Using join buffer (flat, BNLH join)
@@ -1938,148 +949,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 EXPLAIN
 SELECT Name FROM City
 WHERE City.Country IN (SELECT Code FROM Country WHERE Country.Name LIKE 'L%') AND
@@ -2238,7 +1138,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	CountryLanguage	ALL	PRIMARY,Percentage	NULL	NULL	NULL	984	Using where
 1	SIMPLE	Country	eq_ref	PRIMARY	PRIMARY	3	world.CountryLanguage.Country	1	Using where; Using join buffer (flat, BKA join)
@@ -2248,148 +1149,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 EXPLAIN
 SELECT Name FROM City
 WHERE City.Country IN (SELECT Code FROM Country WHERE Country.Name LIKE 'L%') AND
@@ -2545,7 +1335,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	CountryLanguage	ALL	PRIMARY,Percentage	NULL	NULL	NULL	984	Using where
 1	SIMPLE	Country	eq_ref	PRIMARY	PRIMARY	3	world.CountryLanguage.Country	1	Using where; Using join buffer (flat, BKA join)
@@ -2555,148 +1346,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 EXPLAIN
 SELECT Name FROM City
 WHERE City.Country IN (SELECT Code FROM Country WHERE Country.Name LIKE 'L%') AND
@@ -2852,7 +1532,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	CountryLanguage	ALL	PRIMARY,Percentage	NULL	NULL	NULL	984	Using where
 1	SIMPLE	Country	eq_ref	PRIMARY	PRIMARY	3	world.CountryLanguage.Country	1	Using where; Using join buffer (flat, BKAH join)
@@ -2862,148 +1543,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 EXPLAIN
 SELECT Name FROM City
 WHERE City.Country IN (SELECT Code FROM Country WHERE Country.Name LIKE 'L%') AND
@@ -3159,7 +1729,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	CountryLanguage	ALL	PRIMARY,Percentage	NULL	NULL	NULL	984	Using where
 1	SIMPLE	Country	eq_ref	PRIMARY	PRIMARY	3	world.CountryLanguage.Country	1	Using where; Using join buffer (flat, BKAH join)
@@ -3169,148 +1740,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 EXPLAIN
 SELECT Name FROM City
 WHERE City.Country IN (SELECT Code FROM Country WHERE Country.Name LIKE 'L%') AND
@@ -3470,7 +1930,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	CountryLanguage	ALL	PRIMARY,Percentage	NULL	NULL	NULL	984	Using where
 1	SIMPLE	Country	hash	PRIMARY	PRIMARY	3	world.CountryLanguage.Country	239	Using where; Using join buffer (flat, BNLH join)
@@ -3480,148 +1941,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 EXPLAIN
 SELECT Name FROM City
 WHERE City.Country IN (SELECT Code FROM Country WHERE Country.Name LIKE 'L%') AND
@@ -3684,7 +2034,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	CountryLanguage	ALL	PRIMARY,Percentage	NULL	NULL	NULL	984	Using where
 1	SIMPLE	Country	hash	PRIMARY	PRIMARY	3	world.CountryLanguage.Country	239	Using where; Using join buffer (flat, BNLH join)
@@ -3694,148 +2045,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 EXPLAIN
 SELECT Name FROM City
 WHERE City.Country IN (SELECT Code FROM Country WHERE Country.Name LIKE 'L%') AND
@@ -3898,7 +2138,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	CountryLanguage	ALL	PRIMARY,Percentage	NULL	NULL	NULL	984	Using where
 1	SIMPLE	Country	eq_ref	PRIMARY	PRIMARY	3	world.CountryLanguage.Country	1	Using where; Using join buffer (flat, BKA join)
@@ -3908,148 +2149,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 EXPLAIN
 SELECT Name FROM City
 WHERE City.Country IN (SELECT Code FROM Country WHERE Country.Name LIKE 'L%') AND
@@ -4112,7 +2242,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	CountryLanguage	ALL	PRIMARY,Percentage	NULL	NULL	NULL	984	Using where
 1	SIMPLE	Country	eq_ref	PRIMARY	PRIMARY	3	world.CountryLanguage.Country	1	Using where; Using join buffer (flat, BKA join)
@@ -4122,148 +2253,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 EXPLAIN
 SELECT Name FROM City
 WHERE City.Country IN (SELECT Code FROM Country WHERE Country.Name LIKE 'L%') AND
@@ -4326,7 +2346,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	CountryLanguage	ALL	PRIMARY,Percentage	NULL	NULL	NULL	984	Using where
 1	SIMPLE	Country	eq_ref	PRIMARY	PRIMARY	3	world.CountryLanguage.Country	1	Using where; Using join buffer (flat, BKAH join)
@@ -4336,148 +2357,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 EXPLAIN
 SELECT Name FROM City
 WHERE City.Country IN (SELECT Code FROM Country WHERE Country.Name LIKE 'L%') AND
@@ -4540,7 +2450,8 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	CountryLanguage	ALL	PRIMARY,Percentage	NULL	NULL	NULL	984	Using where
 1	SIMPLE	Country	eq_ref	PRIMARY	PRIMARY	3	world.CountryLanguage.Country	1	Using where; Using join buffer (flat, BKAH join)
@@ -4550,148 +2461,37 @@ FROM City,Country,CountryLanguage
 WHERE City.Country=Country.Code AND
 CountryLanguage.Country=Country.Code AND
 City.Name LIKE 'L%' AND Country.Population > 3000000 AND
-CountryLanguage.Percentage > 50;
+CountryLanguage.Percentage > 50 AND
+LENGTH(Language) < LENGTH(City.Name) - 2;
 Name	Name	Language
-Leiden	Netherlands	Dutch
 La Matanza	Argentina	Spanish
 Lomas de Zamora	Argentina	Spanish
-La Plata	Argentina	Spanish
-Lanús	Argentina	Spanish
-Las Heras	Argentina	Spanish
-La Rioja	Argentina	Spanish
-Liège	Belgium	Dutch
-La Paz	Bolivia	Spanish
-Londrina	Brazil	Portuguese
-Limeira	Brazil	Portuguese
-Lages	Brazil	Portuguese
-Luziânia	Brazil	Portuguese
 Lauro de Freitas	Brazil	Portuguese
-Linhares	Brazil	Portuguese
-London	United Kingdom	English
-Liverpool	United Kingdom	English
-Leeds	United Kingdom	English
-Leicester	United Kingdom	English
-Luton	United Kingdom	English
 Los Angeles	Chile	Spanish
-La Serena	Chile	Spanish
-La Romana	Dominican Republic	Spanish
-Loja	Ecuador	Spanish
-Luxor	Egypt	Arabic
 Las Palmas de Gran Canaria	Spain	Spanish
 L´Hospitalet de Llobregat	Spain	Spanish
-Leganés	Spain	Spanish
-León	Spain	Spanish
-Logroño	Spain	Spanish
 Lleida (Lérida)	Spain	Spanish
-Le-Cap-Haïtien	Haiti	Haiti Creole
-La Ceiba	Honduras	Spanish
-Livorno	Italy	Italian
-Latina	Italy	Italian
-Lecce	Italy	Italian
-La Spezia	Italy	Italian
-Linz	Austria	German
-London	Canada	English
-Laval	Canada	English
-Longueuil	Canada	English
-Lanzhou	China	Chinese
-Luoyang	China	Chinese
-Liuzhou	China	Chinese
-Liaoyang	China	Chinese
 Liupanshui	China	Chinese
-Liaoyuan	China	Chinese
 Lianyungang	China	Chinese
-Leshan	China	Chinese
-Linyi	China	Chinese
-Luzhou	China	Chinese
-Laiwu	China	Chinese
-Liaocheng	China	Chinese
-Laizhou	China	Chinese
-Linfen	China	Chinese
 Liangcheng	China	Chinese
-Longkou	China	Chinese
-Langfang	China	Chinese
-Liu´an	China	Chinese
-Longjing	China	Chinese
 Lengshuijiang	China	Chinese
-Laiyang	China	Chinese
-Longyan	China	Chinese
-Linhe	China	Chinese
-Leiyang	China	Chinese
-Loudi	China	Chinese
-Luohe	China	Chinese
-Linqing	China	Chinese
-Laohekou	China	Chinese
-Linchuan	China	Chinese
-Lhasa	China	Chinese
-Lianyuan	China	Chinese
-Liyang	China	Chinese
-Liling	China	Chinese
-Linhai	China	Chinese
-Larisa	Greece	Greek
-La Habana	Cuba	Spanish
-Lilongwe	Malawi	Chichewa
-León	Mexico	Spanish
-La Paz	Mexico	Spanish
-La Paz	Mexico	Spanish
 Lázaro Cárdenas	Mexico	Spanish
 Lagos de Moreno	Mexico	Spanish
-Lerdo	Mexico	Spanish
-Los Cabos	Mexico	Spanish
-Lerma	Mexico	Spanish
 Las Margaritas	Mexico	Spanish
 Lashio (Lasho)	Myanmar	Burmese
 Lalitapur	Nepal	Nepali
-León	Nicaragua	Spanish
-Lambaré	Paraguay	Spanish
-Lima	Peru	Spanish
-Lisboa	Portugal	Portuguese
-Lódz	Poland	Polish
-Lublin	Poland	Polish
-Legnica	Poland	Polish
-Lyon	France	French
-Le Havre	France	French
-Lille	France	French
-Le Mans	France	French
-Limoges	France	French
-Linköping	Sweden	Swedish
-Lund	Sweden	Swedish
-Leipzig	Germany	German
-Lübeck	Germany	German
 Ludwigshafen am Rhein	Germany	German
 Leverkusen	Germany	German
-Lünen	Germany	German
-Lahti	Finland	Finnish
-Lausanne	Switzerland	German
-Latakia	Syria	Arabic
 Luchou	Taiwan	Min
 Lungtan	Taiwan	Min
-Liberec	Czech Republic	Czech
-Lviv	Ukraine	Ukrainian
-Lugansk	Ukraine	Ukrainian
-Lutsk	Ukraine	Ukrainian
-Lysyt?ansk	Ukraine	Ukrainian
 Lower Hutt	New Zealand	English
-Lida	Belarus	Belorussian
 Los Teques	Venezuela	Spanish
-Lipetsk	Russian Federation	Russian
-Ljubertsy	Russian Federation	Russian
 Leninsk-Kuznetski	Russian Federation	Russian
-Long Xuyen	Vietnam	Vietnamese
 Los Angeles	United States	English
-Las Vegas	United States	English
 Long Beach	United States	English
 Lexington-Fayette	United States	English
 Louisville	United States	English
-Lincoln	United States	English
-Lubbock	United States	English
 Little Rock	United States	English
-Laredo	United States	English
-Lakewood	United States	English
-Lansing	United States	English
-Lancaster	United States	English
-Lafayette	United States	English
-Lowell	United States	English
-Livonia	United States	English
 EXPLAIN
 SELECT Name FROM City
 WHERE City.Country IN (SELECT Code FROM Country WHERE Country.Name LIKE 'L%') AND