Diff
219
230
230
products.php
  |
81 | 81 | | function &execute() { |
| |
82 | 82 | | global $osC_Database; |
| |
83 | 83 | | |
 |
84 | | - | $Qlisting = $osC_Database->query('select distinct p.*, pd.*, m.*, if(s.status, s.specials_new_products_price, null) as specials_new_products_price, if(s.status, s.specials_new_products_price, p.products_price) as final_price from :table_products p left join :table_manufacturers m using(manufacturers_id), :table_products_description pd left join :table_specials s on p.products_id = s.products_id, :table_categories c, :table_products_to_categories p2c where p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id'); |
| |
| 84 | + | $Qlisting = $osC_Database->query('select distinct p.*, pd.*, m.*, if(s.status, s.specials_new_products_price, null) as specials_new_products_price, if(s.status, s.specials_new_products_price, p.products_price) as final_price from :table_products p left join :table_manufacturers m using(manufacturers_id) left join :table_specials s on (p.products_id = s.products_id), :table_products_description pd, :table_categories c, :table_products_to_categories p2c where p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id'); |
|
85 | 85 | | $Qlisting->bindTable(':table_products', TABLE_PRODUCTS); |
| |
86 | 86 | | $Qlisting->bindTable(':table_manufacturers', TABLE_MANUFACTURERS); |
| |
87 | 87 | | $Qlisting->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION); |
|