0 -
SQL:SELECT g.customer_gift_id,g.product_gift_counts unit_counts,g.qty * g.product_gift_counts total_counts,g.qty,replace(replace(replace(g.status,'0','Pending'),'1','Processed'),'2','Cancelled')status_ch,g.status,g.create_date,p.product_item_no,p.product_model,p.product_image1 FROM products p, customer_gift g WHERE p.product_id = g.product_id and g.status =0 and g.customer_id = order by g.create_date desc limit 0,10
[TEP STOP]
| |
Canadian Shoppers
International Shoppers