Your cart is empty
Add to Cart:

THB Bury CP1000 Fixed Car Phone

£367.49

Product Description: BURY Fixed Car Phone

Key Product Features:
Memo Function
12 -24 volt compatible
2.8 inch colour screen
Large keypad
Dedicated SOS call button
Fixed number SIM dialing available
Voice Recognition
Magic Word
Automatic call answering via voice command
Scope of Supply: Device handset, ECU box, microphone, 5W loudspeaker, Power cable and fuses, stripline antenna, mounting bracket
Part Number: 1-92-0001-1
EAN Code: 4023032184360



3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'chamele1_direct.xp.sort_order' which is not in SELECT list; this is incompatible with DISTINCT
in:
[select distinct p.products_id, p.products_image, pd.products_name from products_xsell xp, products p, products_description pd where xp.products_id = '1547' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit 6]