Products meeting the search criteria

Number of products to display on a page:

Result Pages:  1  Displaying 1 to 5 (of 5 products)

1054 - Unknown column 'p.products_idp.products_type' in 'group statement'

select m.manufacturers_name, p.item_number, p.products_image, p.image_folder, p.image_display, p.products_quantity, p.hide_qty_over, p.products_bundle, get_sale_expiration(p.products_id) as expires_date, m.manufacturers_id, p.products_id, pd.products_name, p.products_msrp, p.products_price, p.min_ad_price, p.products_tax_class_id, get_sale_price(p.products_id) as specials_new_products_price, IF(get_sale_price(p.products_id) is not null, get_sale_price(p.products_id), p.products_price) as final_price, p.sold_in_bundle_only , p.products_type , p.extra_value_id6 , pd.extra_value5 , p.extra_value_id10 , pd.extra_value3 , pd.extra_value4 , p.extra_value_id12 , pd.extra_value7 , pd.extra_value8 , pd.extra_value9 , p.extra_value_id13 , pd.extra_value14 , pd.extra_value18 , p.extra_value_id20 , p.extra_value_id19 from products p left join manufacturers m using(manufacturers_id) left join products_to_notes ptn on ptn.products_id = p.products_id, products_description pd, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and ((pd.products_name like '%blunami%' or p.products_model like '%blunami%' or m.manufacturers_name like '%blunami%' or p.item_number like '%blunami%' or pd.products_description like '%blunami%' or pd.extra_value5 like '%blunami%' or pd.extra_value3 like '%blunami%' or pd.extra_value4 like '%blunami%' or pd.extra_value7 like '%blunami%' or pd.extra_value8 like '%blunami%' or pd.extra_value9 like '%blunami%' or pd.extra_value14 like '%blunami%' or pd.extra_value18 like '%blunami%') ) group by p.products_idp.products_type , pd.products_name limit 0, 30

[TEP STOP]