Error Query 31 :: Unknown column 'tx.tx_code' in 'field list'
SELECT pd.*, pd.balance AS stock, lk.key_es as title, lk2.key_es as descr, tx.tx_code, tx.tx_rate,
c.catid, c.pcatid, c.uri, pp.priceid, pp.price_buy, pp.price_sale, pp.price_final, pp.shipping, off.price as price_off, subs.hassubs ,lg.def_es as full_description, pm.mediaid, pb.bundle, pb.bundle_qty,pd.* FROM mpc_kombucheria.products pd
LEFT JOIN mpc_kombucheria.lang_keys lk ON (pd.lkey = lk.lkey) LEFT JOIN mpc_kombucheria.lang_keys lk2 ON (pd.descr_lkey = lk2.lkey)
LEFT JOIN mpc_kombucheria.taxes tx ON ( = pd.taxid)
LEFT JOIN mpc_kombucheria.products_manufactors mf ON (pd.manufactor = mf.manfid)
LEFT JOIN mpc_kombucheria.category_ref pc ON (pc.ref = 'products' AND pd.productid = pc.ref_id)
LEFT JOIN mpc_kombucheria.categories c ON (pc.catid=c.catid)
LEFT JOIN mpc_kombucheria.categories pcat ON (c.pcatid = pcat.catid)
LEFT JOIN mpc_kombucheria.products_pricing pp ON (pp.productid = pd.productid AND pp.date_fin IS NULL)
LEFT JOIN mpc_kombucheria.products_prices_offer off ON (pp.priceid = off.priceid AND off.qty = 1
AND (off.date_from <= CURRENT_DATE OR off.date_from IS NULL) AND (off.date_till>=CURRENT_DATE OR off.date_till IS NULL) )
SELECT parentid, COUNT(*) AS hassubs FROM mpc_kombucheria.products
WHERE parentid >= '0' GROUP BY parentid) subs ON (subs.parentid = pd.productid)

LEFT JOIN mpc_kombucheria.lang_generic lg ON (pd.full_descr = lg.constantid)
LEFT JOIN ( SELECT productid, mediaid FROM mpc_kombucheria.products_media GROUP BY productid) pm ON (pd.productid = pm.productid)
LEFT JOIN mpc_kombucheria.products_bundles pb ON (pd.productid = pb.productid) WHERE pd.productid='12817'