Home » Contact Us

Contact Us

Full Name:
Email Address:

AE Furniture Online Dept.
18505 E. Gale Ave.
City of Industry, California 91748
United States
(626) 839-6338
(626) 839-3228
Email: service@aefurniture.com

Featured Products

1030 - Got error 122 from storage engine

select a.products_id ,a.products_image,a.products_thumbnail ,b.products_name, b.products_shortdescription, avg(c.`reviews_rating`) as rating from products a JOIN products_description b ON a.is_enabled = 1 and a.products_id=b.products_id and a.products_isfeatured=1 AND (a.products_featured_expirydate > now() OR a.products_featured_expirydate='0000-00-00 00:00:00') and languages_id =1 and LOCATE('1', a.showed_to_customer) LEFT JOIN reviews c ON a.products_id=c.products_id GROUP BY a.products_id ORDER BY rand() DESC limit 5