a:7:{s:15:"fieldTablePairs";a:0:{}s:12:"tableAliases";a:0:{}s:19:"reverseTableAliases";a:0:{}s:12:"fieldAliases";a:0:{}s:19:"fieldTableAliasData";a:0:{}s:10:"fieldCount";i:2;s:3:"sql";s:215:"SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1' AND (start_date<='1226303568' OR start_date=0) AND (end_date>='1226273760' OR end_date=0) AND product_discount_id=discount_id";}