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 ')' at line 5 select products.PID,products.PRODUCT_NAME,products.PRODUCT_NAME,products.SHORT_NAME,products.CLASS,products.*
from family_members_prod,products
where products.PID=family_members_prod.MEMBER_ID and family_members_prod.DELETED=0 and products.DELETED=0
and products.BRANDID in ('APO','AG','ALX')
and products.ACTIVE_DATE < 1223701418 and family_members_prod.FID in ()
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 products.SORT_NAME LIMIT 0,20' at line 5 select products.PID,products.PRODUCT_NAME,products.PRODUCT_NAME,products.SHORT_NAME,products.CLASS,products.*
from family_members_prod,products
where products.PID=family_members_prod.MEMBER_ID and family_members_prod.DELETED=0 and products.DELETED=0
and products.BRANDID in ('APO','AG','ALX')
and products.ACTIVE_DATE < 1223701418 and family_members_prod.FID in () order by products.SORT_NAME LIMIT 0,20ALEXIS Biochemicals: Families