<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 12pt; color: #000000'><font size="3">Hello Richard,</font><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;"><br></div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">this is what I get:</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;"><br></div><div><div>mysql> select * from contracts where id = 22;</div><div>+----+-------------+-------------+------------+----------+--------+-------------+---------------------+---------------------+---------------------+---------------------+</div><div>| id | customer_id | reseller_id | contact_id | order_id | status | external_id | modify_timestamp | create_timestamp | activate_timestamp | terminate_timestamp |</div><div>+----+-------------+-------------+------------+----------+--------+-------------+---------------------+---------------------+---------------------+---------------------+</div><div>| 22 | NULL | 1 | NULL | NULL | active | asdfasdfsdf | 2013-03-21 15:02:14 | 2013-03-21 15:02:14 | 2013-03-21 15:02:14 | NULL |</div><div>+----+-------------+-------------+------------+----------+--------+-------------+---------------------+---------------------+---------------------+---------------------+</div><div>1 row in set (0.00 sec)</div><div><br></div><div><br></div><div>mysql> select * from contract_balances where contract_id = 22;</div><div>+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+</div><div>| id | contract_id | cash_balance | cash_balance_interval | free_time_balance | free_time_balance_interval | start | end | invoice_id |</div><div>+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+</div><div>| 21 | 22 | 0 | 0 | 0 | 0 | 2013-03-01 00:00:00 | 2013-03-31 23:59:59 | NULL |</div><div>+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+</div><div>1 row in set (0.00 sec)</div><div><br></div><div><br></div><div>mysql> select * from billing.billing_mappings m, billing.billing_profiles p</div><div> -> where p.id = m.billing_profile_id and m.contract_id = 22;</div><div>+----+------------+----------+--------------------+-------------+------------+----+-------------+--------------+--------------+---------+-----------------+--------------------+--------------------+---------------+----------------+----------------------+---------------------+-------------------------------+-------------------+------------------+--------------------+----------+----------+--------------+</div><div>| id | start_date | end_date | billing_profile_id | contract_id | product_id | id | reseller_id | handle | name | prepaid | interval_charge | interval_free_time | interval_free_cash | interval_unit | interval_count | fraud_interval_limit | fraud_interval_lock | fraud_interval_notify | fraud_daily_limit | fraud_daily_lock | fraud_daily_notify | currency | vat_rate | vat_included |</div><div>+----+------------+----------+--------------------+-------------+------------+----+-------------+--------------+--------------+---------+-----------------+--------------------+--------------------+---------------+----------------+----------------------+---------------------+-------------------------------+-------------------+------------------+--------------------+----------+----------+--------------+</div><div>| 22 | NULL | NULL | 4 | 22 | NULL | 4 | 1 | Tarifa_plana | Tarifa plana | 0 | 0 | 0 | 0 | month | 1 | 100 | 3 | | 100 | 3 | NULL | ⬠| 0 | 0 |</div><div>+----+------------+----------+--------------------+-------------+------------+----+-------------+--------------+--------------+---------+-----------------+--------------------+--------------------+---------------+----------------+----------------------+---------------------+-------------------------------+-------------------+------------------+--------------------+----------+----------+--------------+</div><div>1 row in set (0.00 sec)</div></div><div><br></div><div><br></div><div>Thank you very much!!!</div></div></body></html>