Skip to content

Instantly share code, notes, and snippets.

Avatar
😉

Suvankar Paul shuvoenr

😉
View GitHub Profile
@shuvoenr
shuvoenr / gist:604c34cb0aeff15a09b53cbd50dc2d37
Created Jul 11, 2021
Go Lang Configure in Debian 8/9/10
View gist:604c34cb0aeff15a09b53cbd50dc2d37
https://linuxize.com/post/how-to-install-go-on-debian-10/
@shuvoenr
shuvoenr / Getting Number of Active Product in a Category Magento 2 MYSQL.txt
Last active Aug 1, 2020
Getting Number of Active Product in a Category Magento 2 MYSQL
View Getting Number of Active Product in a Category Magento 2 MYSQL.txt
### Getting Status Attribute ID
SELECT `attribute_id` FROM eav_attribute where entity_type_id = '4' AND attribute_code = 'status'
### Getting Visibility Attribute ID
SELECT `attribute_id` FROM eav_attribute where entity_type_id = 4 AND attribute_code = 'visibility'
### MySQL Query for Getting Count
SELECT
count(CCP.category_id) AS total_products
FROM
View 100-equaltrue.com.vhost
<Directory /var/www/equaltrue.com>
AllowOverride None
Require all denied
</Directory>
<VirtualHost 63.142.252.88:80>
DocumentRoot /var/www/clients/client1/web1/web