SELECT restaurants.id AS id, restaurants.name AS name, restaurants.canonical AS canonical, restaurants.street AS street, restaurants.street_number AS street_number, restaurants.street_rest AS street_rest, restaurants.postcode AS postcode, restaurants.location AS location, restaurants.province AS province, countries_i18n.text AS country, restaurants.latitude AS latitude, restaurants.longitude AS longitude, restaurants_average_prices_i18n.text AS average_price, COALESCE(restaurants.level_ecocook_manual, restaurants.level_ecocook) AS certificate, restaurants.country AS id_country, restaurants.img_list AS img_list, 0 as new_web FROM restaurants INNER JOIN users ON (users.id = restaurants.id_user) INNER JOIN countries_i18n ON (countries_i18n.id_country = restaurants.country) LEFT JOIN restaurants_average_prices_i18n ON (restaurants_average_prices_i18n.id_average_price = restaurants.id_average_price) WHERE restaurants.active = "1" AND countries_i18n.code_language = "de_DE" AND restaurants_average_prices_i18n.code_language = "de_DE" ORDER BY certificate DESC, name ASC LIMIT 0, 100

SELECT `restaurants`.`id` AS id, IFNULL(`restaurants_comunications`.`public_name`, `restaurants`.`name`) AS name, `restaurants`.`slug` AS canonical, `restaurants_comunications`.`street` AS street, `restaurants_comunications`.`street_number` AS street_number, `restaurants_comunications`.`street_rest` AS street_rest, `restaurants_comunications`.`post_code` AS postcode, `restaurants_comunications`.`location` AS location, `restaurants_comunications`.`province` AS province, `countries_i18n`.`name` AS country, `restaurants_comunications`.`latitude` AS latitude, `restaurants_comunications`.`longitude` AS longitude, `restaurants_average_prices_i18n`.`name` AS average_price, CASE WHEN `restaurants`.`level_id` IS NULL THEN NULL ELSE `restaurants`.`level_id` - 1 END AS certificate, /*`restaurants`.`level_id` AS certificate,*/ `restaurants_comunications`.`country_id` AS id_country, `restaurants_images`.`path` AS img_list, 1 as new_web FROM `restaurants` INNER JOIN `restaurants_comunications` ON ( `restaurants`.`id` = `restaurants_comunications`.`restaurant_id`) LEFT JOIN `restaurants_images` ON ( `restaurants`.`id` = `restaurants_images`.`restaurant_id` ) LEFT JOIN `countries` ON ( `restaurants_comunications`.`country_id` = `countries`.`id` ) LEFT JOIN `countries_i18n` ON ( `countries`.`id` = `countries_i18n`.`country_id` ) LEFT JOIN `restaurants_average_prices` ON ( `restaurants_comunications`.`average_price_id` = `restaurants_average_prices`.`id`) LEFT JOIN `restaurants_average_prices_i18n` ON ( `restaurants_average_prices`.`id` = `restaurants_average_prices_i18n`.`average_price_id` ) LEFT JOIN `levels` ON ( `restaurants`.`level_id` = `levels`.`id` ) LEFT JOIN `levels_i18n` ON ( `levels`.`id` = `levels_i18n`.`level_id` ) LEFT JOIN `rel_restaurants_cuisine_types` ON ( `restaurants`.`id` = `rel_restaurants_cuisine_types`.`restaurant_id` ) LEFT JOIN `cuisine_types_i18n` ON ( `rel_restaurants_cuisine_types`.`cuisine_type_id` = `cuisine_types_i18n`.`cuisine_type_id` ) WHERE `restaurants`.`status` = 1 AND `restaurants_comunications`.`publicar_en_web` = 1 AND ( `restaurants_images`.`presentation` = 1 OR `restaurants_images`.`presentation` IS NULL ) AND ( `countries_i18n`.`lang_id` = "de" OR `countries_i18n`.`lang_id` IS NULL ) AND ( `levels_i18n`.`lang_id` = "de" OR `levels_i18n`.`lang_id` IS NULL ) AND ( `restaurants_average_prices_i18n`.`lang_id` = "de" OR `restaurants_average_prices_i18n`.`lang_id` IS NULL ) GROUP BY `restaurants`.`id` ORDER BY certificate DESC, name ASC LIMIT 0, 100