Your Basket 0 Items
0845 643 9689
  Total:
   

Beautiful personalised gifts...

                   
Newborn & Baby Gifts
  Baby Gift Sets
  Create Your Own Gift Box
  Baby Accessories
  Bath Wear
  Bibs and Dribble Cloths
  Blankets and Shawls
  Sleep Suits
  Socks and Bootees
  Toys
  China Gifts
  Fleece Products
  Toys
Christening & Naming Gifts
China Gifts
Original Art Work
Photo Albums
Toys
Celebration Gifts
Sale Items
1054 - Unknown column 'p.products_id' in 'on clause'

select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price5,p.products_price6,p.products_price7,p.products_price8, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_price4_qty, p.products_price5_qty,p.products_price6_qty,p.products_price7_qty,p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, 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_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = '464' and pd.products_id = '464' and pd.language_id = '1'

[TEP STOP]