1054 Unknown column 'p.manufacturers_id' in 'on clause'
[select count(*) as total FROM (zen_products p , ge_product_spec , ge_color
LEFT JOIN zen_manufacturers m on (p.manufacturers_id = m.manufacturers_id), zen_products_description pd
LEFT JOIN zen_featured f on pd.products_id = f.products_id )
WHERE p.products_status = 1 and p.products_id = f.products_id and f.status = 1
AND p.products_id = pd.products_id and pd.language_id = 2
AND p.products_id = ge_product_spec.products_id
AND ge_product_spec.color_id = ge_color.id ]