Sample:

SQL:
```
SELECT  img_name, img_metadata  
FROM `image`  
WHERE img_media_type = 'VIDEO' AND img_minor_mime = 'ooyala'  
ORDER BY img_name 
LIMIT 3

SELECT  img_name, img_metadata  
FROM `image`  
WHERE img_media_type = 'VIDEO' AND img_minor_mime = 'ooyala' AND img_name >= 'THE_HUNGER_GAMES_(GERMAN_DVD_BLU_RAY_TRAILER)' 
ORDER BY img_name 
LIMIT 3

SELECT  img_name, img_metadata  
FROM `image`  WHERE img_media_type = 'VIDEO' AND img_minor_mime = 'ooyala' AND img_metadata like '%"pageCategories%"'  
ORDER BY img_name 
LIMIT 3 

SELECT  img_name, img_metadata  
FROM `image`  WHERE img_media_type = 'VIDEO' AND img_minor_mime = 'ooyala' AND img_metadata like '%"pageCategories%"'  AND img_name >= 'THE_HUNGER_GAMES_(GERMAN_DVD_BLU_RAY_TRAILER)' 
ORDER BY img_name 
LIMIT 3 

SELECT  img_name,img_metadata  
FROM `image`  
WHERE img_media_type = 'VIDEO' AND img_minor_mime = 'ooyala' AND exists ( 
     SELECT 1 
     FROM page 
     LEFT JOIN categorylinks ON page_id = cl_from 
     WHERE cl_to = 'Foreign' AND page_namespace = 6 AND page_title = img_name 
)
ORDER BY img_name 
LIMIT 3;

SELECT  img_name,img_metadata  
FROM `image`  
WHERE img_media_type = 'VIDEO' AND img_minor_mime = 'ooyala' AND exists ( 
     SELECT 1 
     FROM page 
     LEFT JOIN categorylinks ON page_id = cl_from 
     WHERE cl_to = 'Foreign' AND page_namespace = 6 AND page_title = img_name 
) AND img_name >= 'THE_HUNGER_GAMES_(GERMAN_DVD_BLU_RAY_TRAILER)'  
ORDER BY img_name 
LIMIT 3;
```

Explain:
```
mysql>  explain SELECT  img_name, img_metadata   FROM `image`   WHERE img_media_type = 'VIDEO' AND img_minor_mime = 'ooyala'   ORDER BY img_name  LIMIT 3;
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
| id | select_type | table | type  | possible_keys | key     | key_len | ref  | rows | Extra       |
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
|  1 | SIMPLE      | image | index | NULL          | PRIMARY | 257     | NULL |    3 | Using where |
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
1 row in set (0.00 sec)

mysql>  explain SELECT  img_name, img_metadata   FROM `image`   WHERE img_media_type = 'VIDEO' AND img_minor_mime = 'ooyala' AND img_name >= 'THE_HUNGER_GAMES_(GERMAN_DVD_BLU_RAY_TRAILER)'  ORDER BY img_name  LIMIT 3;
+----+-------------+-------+-------+---------------+---------+---------+------+-------+-------------+
| id | select_type | table | type  | possible_keys | key     | key_len | ref  | rows  | Extra       |
+----+-------------+-------+-------+---------------+---------+---------+------+-------+-------------+
|  1 | SIMPLE      | image | range | PRIMARY       | PRIMARY | 257     | NULL | 91872 | Using where |
+----+-------------+-------+-------+---------------+---------+---------+------+-------+-------------+
1 row in set (0.00 sec)

mysql> explain SELECT  img_name, img_metadata   FROM `image`  WHERE img_media_type = 'VIDEO' AND img_minor_mime = 'ooyala' AND img_metadata like '%"pageCategories%"'   ORDER BY img_name  LIMIT 3;
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
| id | select_type | table | type  | possible_keys | key     | key_len | ref  | rows | Extra       |
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
|  1 | SIMPLE      | image | index | NULL          | PRIMARY | 257     | NULL |    3 | Using where |
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
1 row in set (0.00 sec)

mysql> explain SELECT  img_name, img_metadata   FROM `image`  WHERE img_media_type = 'VIDEO' AND img_minor_mime = 'ooyala' AND img_metadata like '%"pageCategories%"'  AND img_name >= 'THE_HUNGER_GAMES_(GERMAN_DVD_BLU_RAY_TRAILER)'  ORDER BY img_name  LIMIT 3;
+----+-------------+-------+-------+---------------+---------+---------+------+-------+-------------+
| id | select_type | table | type  | possible_keys | key     | key_len | ref  | rows  | Extra       |
+----+-------------+-------+-------+---------------+---------+---------+------+-------+-------------+
|  1 | SIMPLE      | image | range | PRIMARY       | PRIMARY | 257     | NULL | 91872 | Using where |
+----+-------------+-------+-------+---------------+---------+---------+------+-------+-------------+
1 row in set (0.00 sec)

mysql> explain SELECT  img_name,img_metadata   FROM `image`   WHERE img_media_type = 'VIDEO' AND img_minor_mime = 'ooyala' AND exists ( SELECT 1 FROM page LEFT JOIN categorylinks ON page_id = cl_from WHERE cl_to = 'Foreign' AND page_namespace = 6 AND page_title = img_name  ) ORDER BY img_name  LIMIT 3;
+----+--------------------+---------------+--------+---------------------------------+------------+---------+-------------------------------+------+--------------------------+
| id | select_type        | table         | type   | possible_keys                   | key        | key_len | ref                           | rows | Extra                    |
+----+--------------------+---------------+--------+---------------------------------+------------+---------+-------------------------------+------+--------------------------+
|  1 | PRIMARY            | image         | index  | NULL                            | PRIMARY    | 257     | NULL                          |    3 | Using where              |
|  2 | DEPENDENT SUBQUERY | page          | eq_ref | PRIMARY,name_title              | name_title | 261     | const,video151.image.img_name |    1 | Using index              |
|  2 | DEPENDENT SUBQUERY | categorylinks | eq_ref | cl_from,cl_timestamp,cl_sortkey | cl_from    | 261     | video151.page.page_id,const   |    1 | Using where; Using index |
+----+--------------------+---------------+--------+---------------------------------+------------+---------+-------------------------------+------+--------------------------+
3 rows in set (0.00 sec)

mysql>  explain SELECT  img_name,img_metadata   FROM `image`   WHERE img_media_type = 'VIDEO' AND img_minor_mime = 'ooyala' AND exists ( SELECT 1  FROM page LEFT JOIN categorylinks ON page_id = cl_from WHERE cl_to = 'Foreign' AND page_namespace = 6 AND page_title = img_name  ) AND img_name >= 'THE_HUNGER_GAMES_(GERMAN_DVD_BLU_RAY_TRAILER)'   ORDER BY img_name  LIMIT 3;
+----+--------------------+---------------+--------+---------------------------------+------------+---------+-------------------------------+-------+--------------------------+
| id | select_type        | table         | type   | possible_keys                   | key        | key_len | ref                           | rows  | Extra                    |
+----+--------------------+---------------+--------+---------------------------------+------------+---------+-------------------------------+-------+--------------------------+
|  1 | PRIMARY            | image         | range  | PRIMARY                         | PRIMARY    | 257     | NULL                          | 91872 | Using where              |
|  2 | DEPENDENT SUBQUERY | page          | eq_ref | PRIMARY,name_title              | name_title | 261     | const,video151.image.img_name |     1 | Using index              |
|  2 | DEPENDENT SUBQUERY | categorylinks | eq_ref | cl_from,cl_timestamp,cl_sortkey | cl_from    | 261     | video151.page.page_id,const   |     1 | Using where; Using index |
+----+--------------------+---------------+--------+---------------------------------+------------+---------+-------------------------------+-------+--------------------------+
3 rows in set (0.00 sec)

```
Result:
```
mysql> SELECT  img_name,img_metadata   FROM `image`   WHERE img_media_type = 'VIDEO' AND img_minor_mime = 'ooyala' AND exists ( SELECT 1  FROM page LEFT JOIN categorylinks ON page_id = cl_from WHERE cl_to = 'Foreign' AND page_namespace = 6 AND page_title = img_name  ) AND img_name >= 'THE_HUNGER_GAMES_(GERMAN_DVD_BLU_RAY_TRAILER)'   ORDER BY img_name  LIMIT 3;
+---------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| img_name                                          | img_metadata                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
+---------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| THE_HUNGER_GAMES_(GERMAN_DVD_BLU_RAY_TRAILER)     | a:22:{s:7:"videoId";s:32:"o4bnZyZDqVXctMQxRi-4wb_dOq_Eqqtm";s:2:"hd";i:1;s:8:"duration";i:58;s:9:"published";i:1345507200;s:7:"ageGate";i:0;s:11:"ageRequired";i:0;s:14:"industryRating";s:5:"PG-13";s:9:"thumbnail";s:73:"http://content.internetvideoarchive.com/content/photos/8002/50783_048.jpg";s:8:"category";s:6:"Movies";s:8:"keywords";s:47:"Hunger Games, The Hunger Games, Movies, Foreign";s:8:"provider";s:10:"ooyala/iva";s:8:"language";s:2:"de";s:6:"genres";s:16:"Action-Adventure";s:6:"actors";s:96:"Jennifer Lawrence, Liam Hemsworth, Leven Rambin, Elizabeth Banks, Josh Hutcherson, Stanley Tucci";s:8:"playerId";s:32:"52bc289bedc847e3aa8eb2b347644f68";s:13:"targetCountry";s:2:"DE";s:6:"source";s:3:"iva";s:8:"sourceId";s:5:"50783";s:6:"series";s:16:"The Hunger Games";s:5:"title";s:45:"THE HUNGER GAMES (GERMAN DVD BLU RAY TRAILER)";s:8:"canEmbed";b:1;s:11:"aspectRatio";d:1.77777779999999996363158061285503208637237548828125;}                                       |
| TWILIGHT_SAGA_BREAKING_DAWN-PART_1_(GERMAN),_THE  | a:22:{s:7:"videoId";s:32:"NoMTZyZDpdShLN2XLyRO1fdDoI26A1xy";s:2:"hd";i:1;s:8:"duration";i:107;s:9:"published";i:1321574400;s:7:"ageGate";i:0;s:11:"ageRequired";i:0;s:14:"industryRating";s:5:"PG-13";s:9:"thumbnail";s:74:"http://content.internetvideoarchive.com/content/photos/7519/469460_104.jpg";s:8:"category";s:6:"Movies";s:8:"keywords";s:66:"Twilight, The Twilight Saga: Breaking Dawn-Part 1, Movies, Foreign";s:8:"provider";s:10:"ooyala/iva";s:8:"language";s:2:"de";s:6:"genres";s:8:"Thriller";s:6:"actors";s:95:"Anna Kendrick, Dakota Fanning, Michael Sheen, Kristen Stewart, Taylor Lautner, Robert Pattinson";s:8:"playerId";s:32:"52bc289bedc847e3aa8eb2b347644f68";s:13:"targetCountry";s:2:"DE";s:6:"source";s:3:"iva";s:8:"sourceId";s:6:"469460";s:6:"series";s:39:"The Twilight Saga: Breaking Dawn-Part 1";s:5:"title";s:48:"TWILIGHT SAGA BREAKING DAWN-PART 1 (GERMAN), THE";s:8:"canEmbed";b:1;s:11:"aspectRatio";d:1.77777779999999996363158061285503208637237548828125;} |
| TWILIGHT_SAGA_BREAKING_DAWN-PART_1_(ITALIAN),_THE | a:22:{s:7:"videoId";s:32:"tkMTZyZDqZh5PsEapsdGWNXMj8uSglqM";s:2:"hd";i:0;s:8:"duration";i:31;s:9:"published";i:1323302400;s:7:"ageGate";i:0;s:11:"ageRequired";i:0;s:14:"industryRating";s:5:"PG-13";s:9:"thumbnail";s:74:"http://content.internetvideoarchive.com/content/photos/7548/227499_012.jpg";s:8:"category";s:6:"Movies";s:8:"keywords";s:66:"Twilight, The Twilight Saga: Breaking Dawn-Part 1, Movies, Foreign";s:8:"provider";s:10:"ooyala/iva";s:8:"language";s:2:"it";s:6:"genres";s:8:"Thriller";s:6:"actors";s:95:"Anna Kendrick, Dakota Fanning, Michael Sheen, Kristen Stewart, Taylor Lautner, Robert Pattinson";s:8:"playerId";s:32:"52bc289bedc847e3aa8eb2b347644f68";s:13:"targetCountry";s:2:"IT";s:6:"source";s:3:"iva";s:8:"sourceId";s:6:"227499";s:6:"series";s:39:"The Twilight Saga: Breaking Dawn-Part 1";s:5:"title";s:49:"TWILIGHT SAGA BREAKING DAWN-PART 1 (ITALIAN), THE";s:8:"canEmbed";b:1;s:11:"aspectRatio";d:1.77777779999999996363158061285503208637237548828125;} |
+---------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)
```