"Back"

SQL Select

Executed SQL
SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `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 = 4) AND (entity_attribute.attribute_set_id = '4') ORDER BY entity_attribute.sort_order ASC
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 attribute_id 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
4 name varchar text Name 1 0 0 71 1 1 1 0 0 0 0 0 0 1 1 1 1 0 0 0 2798 4 7 1 Name
4 price catalog/product_attribute_backend_price decimal price Price 0 0 0 75 2 1 1 1 0 0 0 0 0 1 1 1 simple,configurable,virtual,bundle,downloadable 1 0 0 0 2822 4 8 1 Price
4 meta_title varchar text Meta Title 0 0 0 82 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2844 4 9 1 Meta Title
4 image varchar catalog/product_attribute_frontend_image media_image Base Image 0 0 0 85 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2850 4 10 1 Base Image
4 is_recurring int select Enable Recurring Profile eav/entity_attribute_source_boolean 0 0 0 Products with recurring profile participate in catalog as nominal items. 100 1 1 0 0 0 0 0 0 0 0 0 0 simple,virtual 0 0 0 0 2860 4 11 1 Enable Recurring Profile
4 custom_design varchar select Custom Design core/design_source_design 0 0 0 103 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2864 4 12 1 Custom Design
4 gift_message_available catalog/product_attribute_backend_boolean varchar select Allow Gift Message eav/entity_attribute_source_boolean 0 0 0 122 giftmessage/adminhtml_product_helper_form_config 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2876 4 17 1 Allow Gift Message
4 description text textarea Description 0 0 0 72 0 1 1 0 1 0 1 0 0 0 0 1 1 0 1 0 2800 4 7 2 Description
4 group_price catalog/product_attribute_backend_groupprice decimal text Group Price 0 0 0 90 2 1 0 0 0 0 0 0 0 0 0 1 simple,configurable,virtual,bundle,downloadable 0 0 0 0 2830 4 8 2 Group Price
4 meta_keyword text textarea Meta Keywords 0 0 0 83 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2846 4 9 2 Meta Keywords
4 small_image varchar catalog/product_attribute_frontend_image media_image Small Image 0 0 0 86 0 1 0 0 0 0 0 0 0 1 0 1 0 0 0 0 2852 4 10 2 Small Image
4 recurring_profile catalog/product_attribute_backend_recurring text text Recurring Payment Profile 0 0 0 101 1 1 0 0 0 0 0 0 0 0 0 0 simple,virtual 0 0 0 0 2862 4 11 2 Recurring Payment Profile
4 custom_design_from catalog/product_attribute_backend_startdate datetime date Active From 0 0 0 104 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2866 4 12 2 Active From
4 short_description text textarea Short Description 0 0 0 73 0 1 1 0 1 0 1 0 0 1 0 1 1 0 1 0 2802 4 7 3 Short Description
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 76 2 1 0 0 0 0 0 0 0 1 0 1 simple,configurable,virtual,bundle,downloadable 0 0 0 0 2824 4 8 3 Special Price
4 meta_description varchar textarea Meta Description 0 0 0 Maximum 255 chars 84 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2848 4 9 3 Meta Description
4 thumbnail varchar catalog/product_attribute_frontend_image media_image Thumbnail 0 0 0 87 0 1 0 0 0 0 0 0 0 1 0 1 0 0 0 0 2854 4 10 3 Thumbnail
4 custom_design_to eav/entity_attribute_backend_datetime datetime date Active To 0 0 0 105 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2868 4 12 3 Active To
4 sku catalog/product_attribute_backend_sku static text SKU 1 0 1 74 1 1 1 0 1 0 0 0 0 0 0 1 1 0 0 0 2804 4 7 4 SKU
4 special_from_date catalog/product_attribute_backend_startdate_specialprice datetime date Special Price From Date 0 0 0 77 2 1 0 0 0 0 0 0 0 1 0 1 simple,configurable,virtual,bundle,downloadable 0 0 0 0 2826 4 8 4 Special Price From Date
4 media_gallery catalog/product_attribute_backend_media varchar gallery Media Gallery 0 0 0 88 1 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2856 4 10 4 Media Gallery
4 custom_layout_update catalog/attribute_backend_customlayoutupdate text textarea Custom Layout Update 0 0 0 106 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2870 4 12 4 Custom Layout Update
4 weight decimal weight Weight 0 0 0 80 1 1 0 0 0 0 0 0 0 0 0 1 simple,bundle 0 0 0 0 2806 4 7 5 Weight
4 special_to_date eav/entity_attribute_backend_datetime datetime date Special Price To Date 0 0 0 78 2 1 0 0 0 0 0 0 0 1 0 1 simple,configurable,virtual,bundle,downloadable 0 0 0 0 2828 4 8 5 Special Price To Date
4 gallery varchar gallery Image Gallery 0 0 0 95 1 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2858 4 10 5 Image Gallery
4 page_layout varchar select Page Layout catalog/product_attribute_source_layout 0 0 0 107 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2872 4 12 5 Page Layout
4 old_id int text 0 0 0 89 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 88 4 7 6
4 news_from_date catalog/product_attribute_backend_startdate datetime date Set Product as New from Date 0 0 0 93 2 1 0 0 0 0 0 0 0 1 0 1 0 0 0 0 2808 4 7 6 Set Product as New from Date
4 tier_price catalog/product_attribute_backend_tierprice decimal text Tier Price 0 0 0 91 2 1 0 0 0 0 0 0 0 0 0 1 simple,configurable,virtual,bundle,downloadable 0 0 0 0 2832 4 8 6 Tier Price
4 options_container varchar select Display Product Options In catalog/entity_product_attribute_design_options_container 0 0 container1 0 109 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2874 4 12 6 Display Product Options In
4 news_to_date eav/entity_attribute_backend_datetime datetime date Set Product as New to Date 0 0 0 94 2 1 0 0 0 0 0 0 0 1 0 1 0 0 0 0 2810 4 7 7 Set Product as New to Date
4 msrp_enabled catalog/product_attribute_backend_msrp varchar select Apply MAP catalog/product_attribute_source_msrp_type_enabled 0 0 2 0 118 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 2834 4 8 7 Apply MAP
4 minimal_price decimal price Minimal Price 0 0 0 99 0 0 0 0 0 0 0 0 0 0 0 1 simple,configurable,virtual,bundle,downloadable 0 0 0 0 97 4 8 8 Minimal Price
4 status int select Status catalog/product_status 1 0 0 96 2 1 1 0 0 0 0 0 0 1 0 1 0 0 0 0 2812 4 7 8 Status
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 119 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 2836 4 8 8 Display Actual Price
4 url_key catalog/product_attribute_backend_urlkey varchar text URL Key 0 0 0 97 0 1 0 0 0 0 0 0 0 1 0 1 0 0 0 0 2814 4 7 9 URL Key
4 msrp catalog/product_attribute_backend_price decimal price Manufacturer's Suggested Retail Price 0 0 0 120 2 1 0 0 0 0 0 0 0 1 0 1 simple,bundle,configurable,virtual,downloadable 0 0 0 0 2838 4 8 9 Manufacturer's Suggested Retail Price
4 visibility int select Visibility catalog/product_visibility 1 0 4 0 102 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2816 4 7 10 Visibility
4 tax_class_id int select Tax Class tax/class_source_product 0 0 0 121 2 1 1 0 0 0 0 0 0 1 0 1 simple,configurable,virtual,bundle,downloadable 1 0 0 0 2840 4 8 10 Tax Class
4 url_path varchar text 0 0 0 98 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 96 4 7 11
4 country_of_manufacture varchar select Country of Manufacture catalog/product_attribute_source_countryofmanufacture 0 0 0 117 2 1 0 0 0 0 0 0 0 0 0 0 simple,configurable,bundle,grouped 0 0 0 0 2818 4 7 11 Country of Manufacture
4 price_view int select Price View bundle/product_attribute_source_price_view 1 0 0 126 1 1 0 0 0 0 0 0 0 1 0 0 bundle 0 0 0 0 2842 4 8 11 Price View
4 featured int boolean Featured product 0 0 0 0 is Featured 137 0 1 0 0 0 0 0 0 0 1 0 0 simple,configurable,virtual,bundle,downloadable 0 0 0 0 2820 4 7 12 Featured product
4 category_ids static text 0 0 0 108 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 106 4 7 13
4 required_options static text 0 0 0 110 1 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 108 4 7 14
4 has_options static text 0 0 0 111 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 109 4 7 15
4 image_label varchar text Image Label 0 0 0 112 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 110 4 7 16 Image Label
4 small_image_label varchar text Small Image Label 0 0 0 113 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 111 4 7 17 Small Image Label
4 thumbnail_label varchar text Thumbnail Label 0 0 0 114 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 112 4 7 18 Thumbnail Label
4 created_at eav/entity_attribute_backend_time_created static text 1 0 0 115 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 113 4 7 19
4 updated_at eav/entity_attribute_backend_time_updated static text 1 0 0 116 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 114 4 7 20
4 price_type int 1 0 0 123 1 0 0 0 0 0 0 0 0 1 0 0 bundle 0 0 0 0 121 4 7 22
4 sku_type int 1 0 0 124 1 0 0 0 0 0 0 0 0 0 0 0 bundle 0 0 0 0 122 4 7 23
4 weight_type int 1 0 0 125 1 0 0 0 0 0 0 0 0 1 0 0 bundle 0 0 0 0 123 4 7 24
4 shipment_type int Shipment 1 0 0 127 1 0 0 0 0 0 0 0 0 1 0 0 bundle 0 0 0 0 125 4 7 25 Shipment
4 links_purchased_separately int Links can be purchased separately 1 0 0 128 1 0 0 0 0 0 0 0 0 1 0 0 downloadable 0 0 0 0 126 4 7 26 Links can be purchased separately
4 samples_title varchar Samples title 1 0 0 129 0 0 0 0 0 0 0 0 0 0 0 0 downloadable 0 0 0 0 127 4 7 27 Samples title
4 links_title varchar Links title 1 0 0 130 0 0 0 0 0 0 0 0 0 0 0 0 downloadable 0 0 0 0 128 4 7 28 Links title
4 links_exist int 0 0 0 0 131 1 0 0 0 0 0 0 0 0 1 0 0 downloadable 0 0 0 0 129 4 7 29
4 ebizmarts_mark_visited int select Send Browsed Product Autoresponder eav/entity_attribute_source_boolean 0 1 0 0 141 2 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 3409 4 7 30 Send Browsed Product Autoresponder
4 meta_robots varchar select Meta Robots mageplaza_seo/source_robots 0 1 INDEX,FOLLOW 0 144 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 3412 4 9 1000 Meta Robots