Laptops We R: Gateway Parts by Model

1054: Unknown column 'final_price' in 'order clause'; select distinct p.products_id from osc_products p left join osc_product_attributes pa on (p.products_id = pa.products_id) left join osc_templates_boxes tb on (pa.id = tb.id and tb.code = "manufacturers"), osc_products_description pd, osc_categories c, osc_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 p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and p2c.categories_id in (1,123,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,239,240,241,242,243,244,245,246,247,70,72,73,74,75,71,249,248,250,230,233,231,232,234,235,236,237,238,18,19,20,21,22,23,17,69,12,183,14,97,110,111,112,113,114,115,116,117,118,162,161,121,122,98,99,100,101,102,163,176,164,165,166,167,168,169,170,171,173,172,174,177,178,179,180,175,8,9,103,104,105,106,107,125,126,127,128,129,88,89,90,91,92,93,94,95,96,131,132,133,28,29,30,109,33,34,35,36,37,43,42,41,40,38,39,44,45,46,76,77,78,134,135,136,137,138,139,140,141,142,143,144,145,87,146,147,148,149,150,151,152,153,154,155,79,51,84,85,86,184,186,187,188,185,189,190,191,215,192,52,81,82,83,194,195,196,197,198,199,200,201,216,202,193,203,204,205,206,207,208,209,210,211,212,213,214,47,48,49,50) order by final_price , pd.products_name limit 0, 20

1 x	Acer Aspire L100 Motherboard MB.S6909.004
1 x	Gateway M685, M685-E Laptop Motherboard
2 x	M360, M465, 6000, MX6000, MT6000, ML6000 15.4" LCD SCREEN CLAA154WA03
9 x	M360, M465, 6000, MX6000, MT6000, ML6000 15.4" LCD SCREEN LTN154X3-L03
1 x	M520, M520S MOTHERBOARD 40-A06600-D571
1 x	M685, MX8700 INTEL MINI PCIe WIFI CARD 6003022R, WM3945ABG
1 x	M685, MX8700, MX8500, NX800 VIDEO CARD FAN
4 x	MX6000, ML6000, MT6000 MA8 MOTHERBOARD 31MA8MB0030
2 x	MX6900 HEATSINK WITH FAN 36MA7TATA10
1 x	MX6900, MA7 MOTHERBOARD 31MA7MB0000
1 x	PROFILE 4, 4.5 1GB DDR MEMORY WMEM368L2923BTM-CCC
1 x	PROFILE 4, 4.5, PROFILE 5, 5.5 512MB DDR DESKTOP MEMORY 5000584

Gateway Parts by Model