Products meeting the search criteria
Number of products to display on a page:
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 (p.products_type in (0,1,104,108,105,363,353,106,109,111,338,110,369,317,320,365,157,390,350,396,11,12,8,40,61,194,193,192,191,190,199,198,197,196,195,311,135,136,392,204,205,134,168,171,172,173,169,174,175,170,176,167,180,188,177,187,189,181,179,178,184,183,182,200,201,202,203,58,210,211,212,215,216,414,368,214,213,208,209,206,207,57,140,259,260,397,360,222,141,223,224,373,65,231,229,232,127,225,228,151,233,227,226,252,253,254,156,139,63,255,347,62,256,436,257,258,357,358,137,138,370,269,147,236,237,337,238,339,340,401,239,240,415,394,241,148,242,150,243,466,244,393,336,234,245,247,246,349,249,248,250,235,251,149,230,366,261,267,266,268,262,263,264,265,59,144,143,145,217,218,219,146,220,142,60,427,153,154,161,160,285,286,290,291,287,292,293,294,295,307,288,296,289,297,298,299,300,301,152,302,303,426,304,413,305,306,308,270,271,277,272,278,273,279,274,280,275,281,276,282,284,283,467,458,462,463,459,460,461,374,376,377,378,380,381,379,384,382,383,453,375,386,454,385,309,310,341,447,448,456,449,451,42,455,421,391,329,332,405,404,131,330,313,130,315,129,128,387,331,418,450,155,44,439,440,441,442,443,437,444,438,41,46,464,47,465,48,312,84,166,85,86,133,345,78,79,348,80,327,49,56,64,359,81,82,83,91,54,87,321,372,88,52,53,165,55,89,90,50,77,51,92,100,101,102,97,98,99,93,94,95,96,132,45,43,9,13,37,24,67,69,70,68,71,417,334,162,316,32,35,34,33,422,36,322,163,126,30,21,23,22,221,74,430,431,432,435,434,433,445,75,31,38,39,335,319,73,25,27,28,29,26,314,72,112,423,116,117,118,371,395,323,115,457,113,120,121,10,15,17,14,19,398,403,402,159,76,164,20,16,18,452,122,124,123,2,6,7,3,328,4,5,103,125,362,364,367,361,446,158,318,324,325,326,333,342,343,344,346,351,352,388,406,416,407,408,409,410,411,412,419,420,424,425,428,429)) group by p.products_idp.products_type , pd.products_name limit 0, 30
[TEP STOP]