Kings Lynn Model Shop
0 item(s) in basket - 0.00
View Basket Checkout
 
 
Home Special Offers Contact Us Log In My Account Checkout
Products
Brands
Secure Ordering - Secure 128bit Encryption
More Info
 
 
 
Special Offers Special Offers
Displaying 1 to 6 (of 6 products) Result Pages:  1 
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by final_price , pd.products_name limit 0, 12' at line 1

select distinct p.products_image, pd.products_name, p.products_id, if (isnull(pg.customers_group_price), p.products_price, pg.customers_group_price) as products_price, p.products_tax_class_id, p.products_image, 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 products p left join products_groups pg on p.products_id = pg.products_id and pg.customers_group_id like '%G%', products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and pd.products_id = p.products_id and pd.language_id = '1' and s.status = '1' and p.products_group_access like '%G%' order by p.products_id DESC order by final_price , pd.products_name limit 0, 12

[TEP STOP]