SELECT `e`.*, `at_status`.`value` AS `status`, `at_identifier_sb`.`value` AS `identifier_sb`, `at_order_sb`.`value` AS `order_sb` FROM `blackbird_contenttype_entity` AS `e` INNER JOIN `blackbird_contenttype_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '150') AND (`at_status`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_varchar` AS `at_identifier_sb` ON (`at_identifier_sb`.`entity_id` = `e`.`entity_id`) AND (`at_identifier_sb`.`attribute_id` = '182') AND (`at_identifier_sb`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_text` AS `at_order_sb` ON (`at_order_sb`.`entity_id` = `e`.`entity_id`) AND (`at_order_sb`.`attribute_id` = '181') AND (`at_order_sb`.`store_id` = 0) WHERE (at_status.value = '1') AND (((`e`.`ct_id` = '2'))) AND (((IFNULL(`at_identifier_sb`.`value`, `at_identifier_sb_default`.`value`) = 'home-top-slider') )) ORDER BY `order_sb` ASC LIMIT 3SELECT `e`.*, `at_status`.`value` AS `status`, `at_identifier_db`.`value` AS `identifier_db`, `at_order_db`.`value` AS `order_db` FROM `blackbird_contenttype_entity` AS `e` INNER JOIN `blackbird_contenttype_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '150') AND (`at_status`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_varchar` AS `at_identifier_db` ON (`at_identifier_db`.`entity_id` = `e`.`entity_id`) AND (`at_identifier_db`.`attribute_id` = '212') AND (`at_identifier_db`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_text` AS `at_order_db` ON (`at_order_db`.`entity_id` = `e`.`entity_id`) AND (`at_order_db`.`attribute_id` = '211') AND (`at_order_db`.`store_id` = 0) WHERE (at_status.value = '1') AND (((`e`.`ct_id` = '3'))) AND (((IFNULL(`at_identifier_db`.`value`, `at_identifier_db_default`.`value`) = 'home-shop-man') )) ORDER BY `order_db` ASC LIMIT 1SELECT `e`.*, `at_status`.`value` AS `status`, `at_identifier_db`.`value` AS `identifier_db`, `at_order_db`.`value` AS `order_db` FROM `blackbird_contenttype_entity` AS `e` INNER JOIN `blackbird_contenttype_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '150') AND (`at_status`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_varchar` AS `at_identifier_db` ON (`at_identifier_db`.`entity_id` = `e`.`entity_id`) AND (`at_identifier_db`.`attribute_id` = '212') AND (`at_identifier_db`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_text` AS `at_order_db` ON (`at_order_db`.`entity_id` = `e`.`entity_id`) AND (`at_order_db`.`attribute_id` = '211') AND (`at_order_db`.`store_id` = 0) WHERE (at_status.value = '1') AND (((`e`.`ct_id` = '3'))) AND (((IFNULL(`at_identifier_db`.`value`, `at_identifier_db_default`.`value`) = 'home-shop-woman') )) ORDER BY `order_db` ASC LIMIT 1SELECT `e`.*, `at_status`.`value` AS `status`, `at_identifier_ps`.`value` AS `identifier_ps`, `at_order_ps`.`value` AS `order_ps` FROM `blackbird_contenttype_entity` AS `e` INNER JOIN `blackbird_contenttype_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '150') AND (`at_status`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_varchar` AS `at_identifier_ps` ON (`at_identifier_ps`.`entity_id` = `e`.`entity_id`) AND (`at_identifier_ps`.`attribute_id` = '260') AND (`at_identifier_ps`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_text` AS `at_order_ps` ON (`at_order_ps`.`entity_id` = `e`.`entity_id`) AND (`at_order_ps`.`attribute_id` = '259') AND (`at_order_ps`.`store_id` = 0) WHERE (at_status.value = '1') AND (((`e`.`ct_id` = '4'))) AND (((IFNULL(`at_identifier_ps`.`value`, `at_identifier_ps_default`.`value`) = 'home-products-slider') )) ORDER BY `order_ps` ASC LIMIT 20SELECT `e`.*, `at_status`.`value` AS `status`, `at_identifier_ps`.`value` AS `identifier_ps`, `at_order_ps`.`value` AS `order_ps` FROM `blackbird_contenttype_entity` AS `e` INNER JOIN `blackbird_contenttype_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '150') AND (`at_status`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_varchar` AS `at_identifier_ps` ON (`at_identifier_ps`.`entity_id` = `e`.`entity_id`) AND (`at_identifier_ps`.`attribute_id` = '260') AND (`at_identifier_ps`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_text` AS `at_order_ps` ON (`at_order_ps`.`entity_id` = `e`.`entity_id`) AND (`at_order_ps`.`attribute_id` = '259') AND (`at_order_ps`.`store_id` = 0) WHERE (at_status.value = '1') AND (((`e`.`ct_id` = '4'))) AND (((IFNULL(`at_identifier_ps`.`value`, `at_identifier_ps_default`.`value`) = 'home-products-slider-2') )) ORDER BY `order_ps` ASC LIMIT 20SELECT `e`.*, `at_status`.`value` AS `status`, `at_identifier_db`.`value` AS `identifier_db`, `at_order_db`.`value` AS `order_db` FROM `blackbird_contenttype_entity` AS `e` INNER JOIN `blackbird_contenttype_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '150') AND (`at_status`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_varchar` AS `at_identifier_db` ON (`at_identifier_db`.`entity_id` = `e`.`entity_id`) AND (`at_identifier_db`.`attribute_id` = '212') AND (`at_identifier_db`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_text` AS `at_order_db` ON (`at_order_db`.`entity_id` = `e`.`entity_id`) AND (`at_order_db`.`attribute_id` = '211') AND (`at_order_db`.`store_id` = 0) WHERE (at_status.value = '1') AND (((`e`.`ct_id` = '3'))) AND (((IFNULL(`at_identifier_db`.`value`, `at_identifier_db_default`.`value`) = 'home-shop-woman-2') )) ORDER BY `order_db` ASC LIMIT 1SELECT `e`.*, `at_status`.`value` AS `status`, `at_identifier_db`.`value` AS `identifier_db`, `at_order_db`.`value` AS `order_db` FROM `blackbird_contenttype_entity` AS `e` INNER JOIN `blackbird_contenttype_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '150') AND (`at_status`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_varchar` AS `at_identifier_db` ON (`at_identifier_db`.`entity_id` = `e`.`entity_id`) AND (`at_identifier_db`.`attribute_id` = '212') AND (`at_identifier_db`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_text` AS `at_order_db` ON (`at_order_db`.`entity_id` = `e`.`entity_id`) AND (`at_order_db`.`attribute_id` = '211') AND (`at_order_db`.`store_id` = 0) WHERE (at_status.value = '1') AND (((`e`.`ct_id` = '3'))) AND (((IFNULL(`at_identifier_db`.`value`, `at_identifier_db_default`.`value`) = 'home-shop-man-2') )) ORDER BY `order_db` ASC LIMIT 1SELECT `e`.*, `at_status`.`value` AS `status`, `at_identifier_sb`.`value` AS `identifier_sb`, `at_order_sb`.`value` AS `order_sb` FROM `blackbird_contenttype_entity` AS `e` INNER JOIN `blackbird_contenttype_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '150') AND (`at_status`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_varchar` AS `at_identifier_sb` ON (`at_identifier_sb`.`entity_id` = `e`.`entity_id`) AND (`at_identifier_sb`.`attribute_id` = '182') AND (`at_identifier_sb`.`store_id` = 0) LEFT JOIN `blackbird_contenttype_entity_text` AS `at_order_sb` ON (`at_order_sb`.`entity_id` = `e`.`entity_id`) AND (`at_order_sb`.`attribute_id` = '181') AND (`at_order_sb`.`store_id` = 0) WHERE (at_status.value = '1') AND (((`e`.`ct_id` = '2'))) AND (((IFNULL(`at_identifier_sb`.`value`, `at_identifier_sb_default`.`value`) = 'home-top-slider') )) ORDER BY `order_sb` ASC LIMIT 3