want to have a mysql query that does the same thing as magento 2 catelog does

[AliveHealth]

Hi,

In magento 2 banck end -> products -> catalog is showing all the products with its attributes (including the custom one), i want to have a same mysql query to does the same thing and show it in my databases

Thank you

https://drive.google.com/file/d/0B6UYOu37akeTeGZaSGktMXhldDQ/view?usp=sharing

[Damian Culotta]

Hi @AliveHealth,

If you have the collection you can try with to print the raw sql with:

$collection->printLogQuery(true);

Or:

echo $collection->getSelect()->assemble();

[AliveHealth]

Thanks 

[AliveHealth]

Here is the most related Answer for myself 

http://blog.vanewebsite.com/index.php/2017/01/17/select-all-products-based-on-a-custom-attribute/

[AliveHealth]

Here is the most related Answer for myself 

http://blog.vanewebsite.com/index.php/2017/01/17/select-all-products-based-on-a-custom-attribute/