listing_products_new.php File Reference

Go to the source code of this file.

Variables

  • $products_new_query_raw = "select distinct p.products_id, pd.products_name, p.products_image, p.products_price, p.products_model, p.products_weight, p.products_quantity, p.products_tax_class_id, p.products_date_added, m.manufacturers_id, m.manufacturers_name, 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_PRODUCTS_DESCRIPTION . " pd on(p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "') left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on(p.products_id = p2c.products_id) left join " . TABLE_CATEGORIES . " c on (c.categories_id=p2c.categories_id and categories_status = 1) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id) where p.products_status = '1' and p.products_date_added > SUBDATE(now(), INTERVAL 60 DAY) order by p.products_date_added DESC, pd.products_name"
  • $listing_split = new splitPageResults($products_new_query_raw, $page->_conf_value('MAX_DISPLAY_PRODUCTS_NEW'))

Variable Documentation

$listing_split = new splitPageResults($products_new_query_raw, $page->_conf_value('MAX_DISPLAY_PRODUCTS_NEW'))

Definition at line 13 of file listing_products_new.php.

$products_new_query_raw = "select distinct p.products_id, pd.products_name, p.products_image, p.products_price, p.products_model, p.products_weight, p.products_quantity, p.products_tax_class_id, p.products_date_added, m.manufacturers_id, m.manufacturers_name, 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_PRODUCTS_DESCRIPTION . " pd on(p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "') left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on(p.products_id = p2c.products_id) left join " . TABLE_CATEGORIES . " c on (c.categories_id=p2c.categories_id and categories_status = 1) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id) where p.products_status = '1' and p.products_date_added > SUBDATE(now(), INTERVAL 60 DAY) order by p.products_date_added DESC, pd.products_name"

Definition at line 12 of file listing_products_new.php.