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 ') and products.ACTIVE_DATE > 1208258218' 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 < 1223810218 and family_members_prod.FID in () and products.ACTIVE_DATE > 1208258218
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 ') and products.ACTIVE_DATE > 1208258218 order by products.SORT_NAME LIMIT 0,' 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 < 1223810218 and family_members_prod.FID in () and products.ACTIVE_DATE > 1208258218 order by products.SORT_NAME LIMIT 0,20