SELECT e.sku, cpev.value as productName, COUNT(m.value) as cnt FROM catalog_product_entity e inner join catalog_product_entity_varchar cpev on e.entity_id = cpev.entity_id and cpev.attribute_id=73 LEFT JOIN catalog_product_entity_media_gallery_value_to_entity r ON e.entity_id = r.entity_id LEFT JOIN catalog_product_entity_media_gallery m ON r.value_id = m.value_id GROUP BY e.entity_id HAVING cnt = 0 cpev.attribute_id=73 is name attribute id.
Import a large sql dump file to a MySQL database from command line
Today I had to import a very large SQL dump file (6 Gb) to a MySQL database using windows command line. If you are using linux it is the same. The process is the following: Open a command prompt (or shell in Linux) with administrative privilleges If you are in Windows set character set to […]
Get list of Category & Category Product from Magento using Mysql Query
If you want to get magento category list using mysql. Use following query to get Categories List SELECT DISTINCT cc.entity_id as category_id, cc.value as name, cc1.value as url_path ,cce.parent_id as parent_id ,0 as top,level as `column`,position as sort_order,1 as status,created_at as date_added,updated_at as date_modified FROM catalog_category_entity_varchar cc JOIN catalog_category_entity_varchar cc1 ON cc.entity_id=cc1.entity_id JOIN catalog_category_entity_int cc_int […]
How to enable remote MySQL access on Debian & Linux
This walkthrough is designed for any Debian-based distribution. Step 1: open /etc/mysql/my.cnf. Step 2: comment out the bind-address line, which tells MySQL where to listen. If you remove it, MySQL will accept any connection. You could also assign an IP address like bind-address = <ip-here> if you wish to give access to a specific machine. Comment it out otherwise. Step […]