...
| Code Block |
|---|
SELECT email FROM ps_customer WHERE newsletter = 1 |
Listing all the products which are active and have a description in French (id_lang = 4)
| Code Block |
|---|
SELECT p.id_product, pl.name, pl.link_rewrite, pl.description FROM ps_product p LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product) WHERE p.active = 1 AND pl.id_lang = 4 |
...