1054 Unknown column 'p.manufacturers_id' in 'on clause'
in:
[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 ]