Pinned Loading

1. magento2_get_sample_product_not_asso... magento2_get_sample_product_not_associated_with_parnet

   1

   SELECT * FROM `catalog_product_entity` where entity_id 

   2

   not in (SELECT product_id FROM `catalog_product_super_link`) and type_id='simple'

2. magento_select_sku_and_url_query magento_select_sku_and_url_query

   1

   select e.entity_id, e.sku, ev.value as name,  u.request_path, u.target_path 

   2

   from catalog_product_entity e 

   3

   inner join catalog_product_entity_varchar ev on ev.entity_id = e.entity_id and ev.attribute_id = 

   4

       (select attribute_id from eav_attribute a inner join eav_entity_type et on et.entity_type_id = a.entity_type_id where a.attribute_code = 'name' and et.entity_type_code = 'catalog_product') 

   5

   inner join core_url_rewrite u on u.id_path = concat('product/', e.entity_id) and u.is_system=1 and options is null;

3. Magneto select sku,categories_id,cat... Magneto select sku,categories_id,category_name msyql query

   1

   SELECT product_id, sku,GROUP_CONCAT(catid) AS cat_ids,GROUP_CONCAT(cat_table.name) AS cat_name FROM (

   2

       SELECT entity_id as product_id, category_id as catid FROM (

   3

           SELECT `e`.entity_id, `at_category_id`.`category_id` 

   4

           FROM `catalog_product_entity` AS `e` 

   5

           LEFT JOIN `catalog_category_product` AS `at_category_id`

4. magento2_image_cannot_save_ magento2_image_cannot_save_

   1

   SELECT * FROM catalog_product_entity_varchar WHERE attribute_id = 88 AND entity_id=17919