CMD

California Micro Devices (CMD) Corporation has been acquired by ON Semiconductor. ON Semiconductor´s CMD Group is a leading supplier of application-specific analog and mixed-signal semiconductor products, including protection devices for mobile handsets, analog and mixed-signal ICs for mobile handset displays, as well as digital consumer electronics products such as TVs and personal computers.

ON Semiconductor is a premier supplier of high-performance, energy-efficient silicon solutions for green electronics. ON Semiconductor's broad portfolio of power and signal management, logic, discrete and custom devices helps customers efficiently solve their design challenges in automotive, communications, computing, consumer, industrial, LED lighting, medical, military/aerospace and power applications.


1054 Unknown column 'r.reviews_id' in 'order clause'
in:
[select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status 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 p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1589' order by COUNT(r.reviews_id) desc limit 0,30]