videotool - Mannsdörfer GmbH Stuttgart

SELECT `e`.*, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, IF(at_news_teaser_date.value_id > 0, at_news_teaser_date.value, at_news_teaser_date_default.value) AS `news_teaser_date` FROM `blackbird_contenttype_entity` AS `e` INNER JOIN `blackbird_contenttype_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '151') AND `at_status_default`.`store_id` = 0 LEFT JOIN `blackbird_contenttype_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '151') AND (`at_status`.`store_id` = 1) INNER JOIN `blackbird_contenttype_entity_datetime` AS `at_news_teaser_date_default` ON (`at_news_teaser_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_news_teaser_date_default`.`attribute_id` = '330') AND `at_news_teaser_date_default`.`store_id` = 0 LEFT JOIN `blackbird_contenttype_entity_datetime` AS `at_news_teaser_date` ON (`at_news_teaser_date`.`entity_id` = `e`.`entity_id`) AND (`at_news_teaser_date`.`attribute_id` = '330') AND (`at_news_teaser_date`.`store_id` = 1) WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (IF(at_news_teaser_date.value_id > 0, at_news_teaser_date.value, at_news_teaser_date_default.value) IS NOT NULL) ORDER BY `e`.`entity_id` desc