"Back"

SQL Select

Executed SQL
SELECT `main_table`.*, `additional_table`.*, IF(al.value IS NOT NULL, al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_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 = 4) AND (additional_table.used_in_product_listing = 1)
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 store_label
71 4 name varchar text Name 1 0 0 1 1 1 0 0 0 0 0 0 1 1 1 1 0 0 0 Name
73 4 short_description text textarea Short Description 0 0 0 0 1 1 0 1 0 1 0 0 1 0 1 1 0 1 0 Short Description
75 4 price catalog/product_attribute_backend_price decimal price Price 0 0 0 2 1 1 1 0 0 0 0 0 1 1 1 simple,configurable,virtual,bundle,downloadable 1 0 0 0 Price
76 4 special_price catalog/product_attribute_backend_price decimal price Special Price 0 0 0 The Special Price is active only when lower than the Actual Price 2 1 0 0 0 0 0 0 0 1 0 1 simple,configurable,virtual,bundle,downloadable 0 0 0 0 Special Price
77 4 special_from_date catalog/product_attribute_backend_startdate_specialprice datetime date Special Price From Date 0 0 0 2 1 0 0 0 0 0 0 0 1 0 1 simple,configurable,virtual,bundle,downloadable 0 0 0 0 Special Price From Date
78 4 special_to_date eav/entity_attribute_backend_datetime datetime date Special Price To Date 0 0 0 2 1 0 0 0 0 0 0 0 1 0 1 simple,configurable,virtual,bundle,downloadable 0 0 0 0 Special Price To Date
86 4 small_image varchar catalog/product_attribute_frontend_image media_image Small Image 0 0 0 0 1 0 0 0 0 0 0 0 1 0 1 0 0 0 0 Small Image
87 4 thumbnail varchar catalog/product_attribute_frontend_image media_image Thumbnail 0 0 0 0 1 0 0 0 0 0 0 0 1 0 1 0 0 0 0 Thumbnail
93 4 news_from_date catalog/product_attribute_backend_startdate datetime date Set Product as New from Date 0 0 0 2 1 0 0 0 0 0 0 0 1 0 1 0 0 0 0 Set Product as New from Date
94 4 news_to_date eav/entity_attribute_backend_datetime datetime date Set Product as New to Date 0 0 0 2 1 0 0 0 0 0 0 0 1 0 1 0 0 0 0 Set Product as New to Date
96 4 status int select Status catalog/product_status 1 0 0 2 1 1 0 0 0 0 0 0 1 0 1 0 0 0 0 Status
97 4 url_key catalog/product_attribute_backend_urlkey varchar text URL Key 0 0 0 0 1 0 0 0 0 0 0 0 1 0 1 0 0 0 0 URL Key
110 4 required_options static text 0 0 0 1 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0
112 4 image_label varchar text Image Label 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 Image Label
113 4 small_image_label varchar text Small Image Label 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 Small Image Label
114 4 thumbnail_label varchar text Thumbnail Label 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 Thumbnail Label
118 4 msrp_enabled catalog/product_attribute_backend_msrp varchar select Apply MAP catalog/product_attribute_source_msrp_type_enabled 0 0 2 0 adminhtml/catalog_product_helper_form_msrp_enabled 2 1 0 0 0 0 0 0 0 1 0 1 simple,bundle,configurable,virtual,downloadable 0 0 0 0 Apply MAP
119 4 msrp_display_actual_price_type catalog/product_attribute_backend_boolean varchar select Display Actual Price catalog/product_attribute_source_msrp_type_price 0 0 4 0 adminhtml/catalog_product_helper_form_msrp_price 2 1 0 0 0 0 0 0 0 1 0 1 simple,bundle,configurable,virtual,downloadable 0 0 0 0 Display Actual Price
120 4 msrp catalog/product_attribute_backend_price decimal price Manufacturer's Suggested Retail Price 0 0 0 2 1 0 0 0 0 0 0 0 1 0 1 simple,bundle,configurable,virtual,downloadable 0 0 0 0 Manufacturer's Suggested Retail Price
121 4 tax_class_id int select Tax Class tax/class_source_product 0 0 0 2 1 1 0 0 0 0 0 0 1 0 1 simple,configurable,virtual,bundle,downloadable 1 0 0 0 Tax Class
123 4 price_type int 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 bundle 0 0 0 0
125 4 weight_type int 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 bundle 0 0 0 0
126 4 price_view int select Price View bundle/product_attribute_source_price_view 1 0 0 1 1 0 0 0 0 0 0 0 1 0 0 bundle 0 0 0 0 Price View
127 4 shipment_type int Shipment 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 bundle 0 0 0 0 Shipment
128 4 links_purchased_separately int Links can be purchased separately 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 downloadable 0 0 0 0 Links can be purchased separately
131 4 links_exist int 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 downloadable 0 0 0 0
137 4 featured int boolean Featured product 0 0 0 0 is Featured 0 1 0 0 0 0 0 0 0 1 0 0 simple,configurable,virtual,bundle,downloadable 0 0 0 0 Featured product
144 4 meta_robots varchar select Meta Robots mageplaza_seo/source_robots 0 1 INDEX,FOLLOW 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 Meta Robots