SELECT `blog`.*, `city`.`name` as name_city
FROM (`blog`)
JOIN `city` ON `city`.`tkey`=`blog`.`city_name`
WHERE `city_name` =  'petergof'
AND `type` =  'IS NOT NULL'
AND  `blog`.`type` NOT LIKE '%erobodio%'
ORDER BY `blog`.`id` desc
LIMIT 15