SELECT DISTINCT piv.pi_value, piv.pi_textvalue, piv.org_id, piv.branch_id FROM pidata.pivalues_0055 piv WHERE piv.pi_id=4629 AND piv.pi_collection_id=55 AND piv.period_id=2010 AND piv.subperiod_id=0 AND CONCAT(piv.org_id,'-',piv.branch_id) IN () ORDER BY piv.pi_value
***
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY piv.pi_value' at line 1