Thank you for the great add-on.
I have having an issue with the new product & featured page. I have set up as a single product linked to multiple categories. For example if an item 1TW is linked to 3 categories and if I set it item a featured then I see that on the featured page this item is displayed three times. The page works fine if the item is only set to one category.
After looking in to the codes( I am not a good programmer) found that includes/pages/featured/header_php.php has the code. How do I make change in the query to take only one one row instead of three rows from TABLE_PRODUCTS_TO_CATEGORIES?
$featured_products_query_raw = "SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping,
p.products_qty_box_status, p.master_categories_id
FROM ("
. TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_MANUFACTURERS . " m
on (p.manufacturers_id = m.manufacturers_id),
"
. TABLE_PRODUCTS_DESCRIPTION . " pd
LEFT JOIN " . TABLE_FEATURED . " f
on pd.products_id = f.products_id,
"
. TABLE_PRODUCTS_TO_CATEGORIES . " p2c
LEFT JOIN " . TABLE_CATEGORIES_CUSTOMERS . " ccu
on p2c.categories_id = ccu.categories_id
)
WHERE p.products_status = 1
and p.products_id = f.products_id
and f.status = 1
AND p.products_id = pd.products_id
and pd.language_id = :languagesID
AND p.products_id = p2c.products_id
AND (ccu.customers_cat_group = '" . (int)$_SESSION['customers_cat_group'] . "' OR ccu.customers_cat_group = '0' )
" . $order_by;
Thanks so much for any help!
Bookmarks