"Back"

SQL Select

Executed SQL
SELECT `main_table`.*, `additional_table`.*, `entity_attribute`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id=3) AND (entity_attribute.attribute_set_id = '3') ORDER BY entity_attribute.sort_order ASC
attribute_id entity_type_id attribute_code attribute_model backend_model backend_type backend_table frontend_model frontend_input frontend_label frontend_class source_model is_required is_user_defined default_value is_unique note frontend_input_renderer is_global is_visible is_searchable is_filterable is_comparable is_visible_on_front is_html_allowed_on_front is_used_for_price_rules is_filterable_in_search used_in_product_listing used_for_sort_by is_configurable apply_to is_visible_in_advanced_search position is_wysiwyg_enabled is_used_for_promo_rules entity_attribute_id attribute_set_id attribute_group_id sort_order store_label
41 3 name varchar text Name 1 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 41 3 4 1 Name
132 3 custom_design_apply int select Apply To core/design_source_apply 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 130 3 18 1 Apply To
133 3 magic_label catalog/category_attribute_backend_image varchar text Category Label 0 1 0 Example: New,Hot,... use in Magicmenu 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 131 3 19 1 Category Label
42 3 is_active int select Is Active eav/entity_attribute_source_boolean 1 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 42 3 4 2 Is Active
134 3 short_desc catalog/category_attribute_backend_image varchar text Short Description 0 1 0 Example: "Sale off 20%" (less than 20 characters) 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 132 3 19 2 Short Description
43 3 url_key catalog/category_attribute_backend_urlkey varchar text URL Key 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 43 3 4 3 URL Key
135 3 magic_image catalog/category_attribute_backend_image varchar image Cat Image 0 1 0 Use for in Module related of Magiccart 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 133 3 19 3 Cat Image
44 3 description text textarea Description 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1 0 0 1 0 44 3 4 4 Description
136 3 magic_thumbnail catalog/category_attribute_backend_image varchar image Cat Thumbnail 0 1 0 Use for in Module related of Magiccart 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 134 3 19 4 Cat Thumbnail
146 3 thumbnail catalog/category_attribute_backend_image varchar image Thumbnail Image 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 3416 3 4 4 Thumbnail Image
45 3 image catalog/category_attribute_backend_image varchar image Image 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 45 3 4 5 Image
68 3 custom_use_parent_settings int select Use Parent Category Settings eav/entity_attribute_source_boolean 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 68 3 6 5 Use Parent Category Settings
46 3 meta_title varchar text Page Title 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 46 3 4 6 Page Title
69 3 custom_apply_to_products int select Apply To Products eav/entity_attribute_source_boolean 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 69 3 6 6 Apply To Products
47 3 meta_keywords text textarea Meta Keywords 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 47 3 4 7 Meta Keywords
48 3 meta_description text textarea Meta Description 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 48 3 4 8 Meta Description
49 3 display_mode varchar select Display Mode catalog/category_attribute_source_mode 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 49 3 5 10 Display Mode
58 3 custom_design varchar select Custom Design core/design_source_design 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 58 3 6 10 Custom Design
67 3 include_in_menu int select Include in Navigation Menu eav/entity_attribute_source_boolean 1 0 1 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 67 3 4 10 Include in Navigation Menu
52 3 path static text Path 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 52 3 4 12 Path
53 3 position static text Position 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 53 3 4 13 Position
54 3 all_children text text 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 54 3 4 14
55 3 path_in_store text text 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 55 3 4 15
56 3 children text text 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 56 3 4 16
57 3 url_path varchar text 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 57 3 4 17
50 3 landing_page int select CMS Block catalog/category_attribute_source_page 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 50 3 5 20 CMS Block
63 3 level static text Level 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 63 3 4 24 Level
64 3 children_count static text Children Count 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 64 3 4 25 Children Count
51 3 is_anchor int select Is Anchor eav/entity_attribute_source_boolean 0 0 0 1 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 51 3 5 30 Is Anchor
59 3 custom_design_from eav/entity_attribute_backend_datetime datetime date Active From 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 59 3 6 30 Active From
60 3 custom_design_to eav/entity_attribute_backend_datetime datetime date Active To 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 60 3 6 40 Active To
65 3 available_sort_by catalog/category_attribute_backend_sortby text multiselect Available Product Listing Sort By catalog/category_attribute_source_sortby 1 0 0 adminhtml/catalog_category_helper_sortby_available 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 65 3 5 40 Available Product Listing Sort By
61 3 page_layout varchar select Page Layout catalog/category_attribute_source_layout 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 61 3 6 50 Page Layout
66 3 default_sort_by catalog/category_attribute_backend_sortby varchar select Default Product Listing Sort By catalog/category_attribute_source_sortby 1 0 0 adminhtml/catalog_category_helper_sortby_default 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 66 3 5 50 Default Product Listing Sort By
70 3 filter_price_range decimal text Layered Navigation Price Step 0 0 0 adminhtml/catalog_category_helper_pricestep 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 70 3 5 51 Layered Navigation Price Step
62 3 custom_layout_update catalog/attribute_backend_customlayoutupdate text textarea Custom Layout Update 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 62 3 6 60 Custom Layout Update
145 3 meta_robots varchar select Meta Robots mageplaza_seo/source_robots 0 1 INDEX,FOLLOW 0 0 1 0 0 0 1 0 0 0 0 0 1 0 0 0 0 3415 3 4 1000 Meta Robots