Page 2 of 3
hmmm
Posted: Wed Jul 28, 2004 3:14 pm
by jglicken
this is cut and paste of the last query you posted ( am i missing something)?
Code: Select all
mysql> select a.calldate, a.src, b.destination, a.dst, substring(a.dst,4), b.name, sec_to_time(a.billsec) as billsec, format((a.billsec/60 * b.rate + b.connectCost), 2) totalcost from cdr a left join rates b on a.dst regexp (concat('^', b.destination)) where src='erick' and dst like '011%' order by 'calldate' desc;
+---------------------+-------+-------------+--------------------+--------------------+------+----------+-----------+
| calldate | src | destination | dst | substring(a.dst,4) | name | billsec | totalcost |
+---------------------+-------+-------------+--------------------+--------------------+------+----------+-----------+
| 2004-07-27 10:52:52 | erick | NULL | 0115058885694 | 5058885694 | NULL | 00:00:00 | NULL |
| 2004-07-27 10:52:23 | erick | NULL | 0115058885694 | 5058885694 | NULL | 00:00:00 | NULL |
| 2004-07-27 10:51:13 | erick | NULL | 0115058885694 | 5058885694 | NULL | 00:00:00 | NULL |
| 2004-07-27 10:46:45 | erick | NULL | 0115058885694 | 5058885694 | NULL | 00:00:00 | NULL |
| 2004-07-03 13:47:34 | erick | NULL | 011582869237134 | 582869237134 | NULL | 00:00:48 | NULL |
| 2004-07-03 13:46:01 | erick | NULL | 0115114229804 | 5114229804 | NULL | 00:01:50 | NULL |
| 2004-06-30 00:10:42 | erick | NULL | 011582869237134 | 582869237134 | NULL | 00:19:16 | NULL |
| 2004-06-29 23:50:15 | erick | NULL | 011582869237134 | 582869237134 | NULL | 00:00:51 | NULL |
| 2004-05-09 00:11:40 | erick | NULL | 011582869237134 | 582869237134 | NULL | 00:03:18 | NULL |
| 2004-04-17 13:52:56 | erick | NULL | 011582869237134 | 582869237134 | NULL | 00:01:44 | NULL |
| 2004-04-17 13:50:20 | erick | NULL | 011582869237134 | 582869237134 | NULL | 00:00:00 | NULL |
| 2004-04-17 13:48:21 | erick | NULL | 011584142869237134 | 584142869237134 | NULL | 00:00:00 | NULL |
| 2004-04-17 13:45:23 | erick | NULL | 011584142869237134 | 584142869237134 | NULL | 00:00:00 | NULL |
| 2004-04-16 18:51:01 | erick | NULL | 011584148681837 | 584148681837 | NULL | 00:01:16 | NULL |
| 2004-04-16 10:23:00 | erick | NULL | 0115114220165 | 5114220165 | NULL | 00:00:03 | NULL |
+---------------------+-------+-------------+--------------------+--------------------+------+----------+-----------+
15 rows in set (0.00 sec)
i think i got it
Posted: Wed Jul 28, 2004 3:19 pm
by jglicken
thanks for your help, you pointed me in the right direction, but your query was based on the actual dst and i need substring(a.dst,4) to strip off the 011 (like the show tables above). again i would not have figured this out if it was not for your help.
jason
Posted: Wed Jul 28, 2004 3:31 pm
by feyd
the join's failing.. it may be because of this:
try
Code: Select all
select a.calldate, a.src, b.destination, a.dst, substring(a.dst,4), b.name, sec_to_time(a.billsec) as billsec, format((a.billsec/60 * b.rate + b.connectCost), 2) totalcost from cdr a left join rates b on a.dst regexp (concat('^', b.destination)) where src='erick' order by 'calldate' desc
i figured it out
Posted: Wed Jul 28, 2004 3:34 pm
by jglicken
we were concating a.dst, not substring(a.dst,4)
Code: Select all
mysql> select a.calldate, a.src, b.destination, a.dst, b.name, sec_to_time(a.billsec) as billsec, format((a.billsec/60 * b.rate + b.connectCost), 2) totalcost from cdr a left join rates b on substring(a.dst,4) regexp (concat('^', b.destination)) where src='erick' and dst like '011%' order by 'calldate' desc;
+---------------------+-------+-------------+--------------------+------------------+----------+-----------+
| calldate | src | destination | dst | name | billsec | totalcost |
+---------------------+-------+-------------+--------------------+------------------+----------+-----------+
| 2004-07-27 10:52:52 | erick | NULL | 0115058885694 | NULL | 00:00:00 | NULL |
| 2004-07-27 10:52:23 | erick | NULL | 0115058885694 | NULL | 00:00:00 | NULL |
| 2004-07-27 10:51:13 | erick | NULL | 0115058885694 | NULL | 00:00:00 | NULL |
| 2004-07-27 10:46:45 | erick | NULL | 0115058885694 | NULL | 00:00:00 | NULL |
| 2004-07-03 13:47:34 | erick | NULL | 011582869237134 | NULL | 00:00:48 | NULL |
| 2004-07-03 13:46:01 | erick | 511 | 0115114229804 | Peru Lima | 00:01:50 | 0.23 |
| 2004-06-30 00:10:42 | erick | NULL | 011582869237134 | NULL | 00:19:16 | NULL |
| 2004-06-29 23:50:15 | erick | NULL | 011582869237134 | NULL | 00:00:51 | NULL |
| 2004-05-09 00:11:40 | erick | NULL | 011582869237134 | NULL | 00:03:18 | NULL |
| 2004-04-17 13:52:56 | erick | NULL | 011582869237134 | NULL | 00:01:44 | NULL |
| 2004-04-17 13:50:20 | erick | NULL | 011582869237134 | NULL | 00:00:00 | NULL |
| 2004-04-17 13:48:21 | erick | 58414 | 011584142869237134 | Venezuela Mobile | 00:00:00 | 0.05 |
| 2004-04-17 13:45:23 | erick | 58414 | 011584142869237134 | Venezuela Mobile | 00:00:00 | 0.05 |
| 2004-04-16 18:51:01 | erick | 58414 | 011584148681837 | Venezuela Mobile | 00:01:16 | 0.30 |
| 2004-04-16 10:23:00 | erick | 511 | 0115114220165 | Peru Lima | 00:00:03 | 0.06 |
+---------------------+-------+-------------+--------------------+------------------+----------+-----------+
15 rows in set (0.00 sec)
again, thank you very much for showing me how to do this it is very helpful
jason
ok, i am very close
Posted: Thu Jul 29, 2004 10:27 am
by jglicken
i am getting multiple matches based on my concat query. is there a way for me to pattern match starting from the right and getting one result per variable based on closest match from the right?
Code: Select all
select a.calldate, a.src, a.dst, b.name, sec_to_time(a.billsec) as billsec, format((a.billsec/60 * b.rate + b.connectCost), 2) totalcost from cdr a left join rates b on substring(a.dst,4) regexp left((concat('^', b.destination)), 8) where src='erick' and dst like '011%' order by 'calldate' desc;
+---------------------+-------+--------------------+----------------------+----------+-----------+
| calldate | src | dst | name | billsec | totalcost |
+---------------------+-------+--------------------+----------------------+----------+-----------+
| 2004-07-27 10:52:52 | erick | 0115058885694 | NICARAGUA | 00:00:00 | 0.05 |
| 2004-07-27 10:52:52 | erick | 0115058885694 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:52:52 | erick | 0115058885694 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:52:23 | erick | 0115058885694 | NICARAGUA | 00:00:00 | 0.05 |
| 2004-07-27 10:52:23 | erick | 0115058885694 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:52:23 | erick | 0115058885694 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:51:13 | erick | 0115058885694 | NICARAGUA | 00:00:00 | 0.05 |
| 2004-07-27 10:51:13 | erick | 0115058885694 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:51:13 | erick | 0115058885694 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:46:45 | erick | 0115058885694 | NICARAGUA | 00:00:00 | 0.05 |
| 2004-07-27 10:46:45 | erick | 0115058885694 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:46:45 | erick | 0115058885694 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-03 13:47:34 | erick | 011582869237134 | VENEZUELA | 00:00:48 | 0.59 |
| 2004-07-03 13:47:34 | erick | 011582869237134 | VENEZUELA ROC | 00:00:48 | 0.59 |
| 2004-07-03 13:46:01 | erick | 0115114229804 | PERU | 00:01:50 | 0.48 |
| 2004-07-03 13:46:01 | erick | 0115114229804 | PERU LIMA | 00:01:50 | 0.48 |
| 2004-07-03 13:46:01 | erick | 0115114229804 | PERU LIMA | 00:01:50 | 0.48 |
| 2004-06-30 00:10:42 | erick | 011582869237134 | VENEZUELA | 00:19:16 | 13.15 |
| 2004-06-30 00:10:42 | erick | 011582869237134 | VENEZUELA ROC | 00:19:16 | 13.15 |
| 2004-06-29 23:50:15 | erick | 011582869237134 | VENEZUELA | 00:00:51 | 0.63 |
| 2004-06-29 23:50:15 | erick | 011582869237134 | VENEZUELA ROC | 00:00:51 | 0.63 |
| 2004-05-09 00:11:40 | erick | 011582869237134 | VENEZUELA | 00:03:18 | 2.29 |
| 2004-05-09 00:11:40 | erick | 011582869237134 | VENEZUELA ROC | 00:03:18 | 2.29 |
| 2004-04-17 13:52:56 | erick | 011582869237134 | VENEZUELA | 00:01:44 | 1.23 |
| 2004-04-17 13:52:56 | erick | 011582869237134 | VENEZUELA ROC | 00:01:44 | 1.23 |
| 2004-04-17 13:50:20 | erick | 011582869237134 | VENEZUELA | 00:00:00 | 0.05 |
| 2004-04-17 13:50:20 | erick | 011582869237134 | VENEZUELA ROC | 00:00:00 | 0.05 |
| 2004-04-17 13:48:21 | erick | 011584142869237134 | VENEZUELA | 00:00:00 | 0.05 |
| 2004-04-17 13:48:21 | erick | 011584142869237134 | VENEZUELA MOB | 00:00:00 | 0.05 |
| 2004-04-17 13:48:21 | erick | 011584142869237134 | VENEZUELA MOB TELCEL | 00:00:00 | 0.05 |
| 2004-04-17 13:45:23 | erick | 011584142869237134 | VENEZUELA | 00:00:00 | 0.05 |
| 2004-04-17 13:45:23 | erick | 011584142869237134 | VENEZUELA MOB | 00:00:00 | 0.05 |
| 2004-04-17 13:45:23 | erick | 011584142869237134 | VENEZUELA MOB TELCEL | 00:00:00 | 0.05 |
| 2004-04-16 18:51:01 | erick | 011584148681837 | VENEZUELA | 00:01:16 | 0.91 |
| 2004-04-16 18:51:01 | erick | 011584148681837 | VENEZUELA MOB | 00:01:16 | 0.91 |
| 2004-04-16 18:51:01 | erick | 011584148681837 | VENEZUELA MOB TELCEL | 00:01:16 | 0.91 |
| 2004-04-16 10:23:00 | erick | 0115114220165 | PERU | 00:00:03 | 0.06 |
| 2004-04-16 10:23:00 | erick | 0115114220165 | PERU LIMA | 00:00:03 | 0.06 |
| 2004-04-16 10:23:00 | erick | 0115114220165 | PERU LIMA | 00:00:03 | 0.06 |
+---------------------+-------+--------------------+----------------------+----------+-----------+
39 rows in set (0.00 sec)
i should get back 15 rows.
thanks,
Jason
Posted: Thu Jul 29, 2004 10:41 am
by feyd
could you post some data exports so I can build a local copy to fiddle with?
Posted: Thu Jul 29, 2004 10:48 am
by jglicken
Code: Select all
mysql> select calldate, src, dst, billsec from cdr where src='erick' and dst like '011%'
-> ;
+---------------------+-------+--------------------+---------+
| calldate | src | dst | billsec |
+---------------------+-------+--------------------+---------+
| 2004-04-16 10:23:00 | erick | 0115114220165 | 3 |
| 2004-04-16 18:51:01 | erick | 011584148681837 | 76 |
| 2004-04-17 13:45:23 | erick | 011584142869237134 | 0 |
| 2004-04-17 13:48:21 | erick | 011584142869237134 | 0 |
| 2004-04-17 13:50:20 | erick | 011582869237134 | 0 |
| 2004-04-17 13:52:56 | erick | 011582869237134 | 104 |
| 2004-05-09 00:11:40 | erick | 011582869237134 | 198 |
| 2004-06-29 23:50:15 | erick | 011582869237134 | 51 |
| 2004-06-30 00:10:42 | erick | 011582869237134 | 1156 |
| 2004-07-03 13:46:01 | erick | 0115114229804 | 110 |
| 2004-07-03 13:47:34 | erick | 011582869237134 | 48 |
| 2004-07-27 10:46:45 | erick | 0115058885694 | 0 |
| 2004-07-27 10:51:13 | erick | 0115058885694 | 0 |
| 2004-07-27 10:52:23 | erick | 0115058885694 | 0 |
| 2004-07-27 10:52:52 | erick | 0115058885694 | 0 |
+---------------------+-------+--------------------+---------+
15 rows in set (0.07 sec)
above are pertinant rows from table cdr
Code: Select all
mysql> select * from rates where name like 'venezuela%';
+-------------+------------------------+------+-------------+
| destination | name | rate | connectCost |
+-------------+------------------------+------+-------------+
| 58 | VENEZUELA | 0.68 | 0.05 |
| 58251 | VENEZUELA BARQUISIMETO | 0.68 | 0.05 |
| 58212 | VENEZUELA CARACAS | 0.68 | 0.05 |
| 58261 | VENEZUELA MARACAIBO | 0.68 | 0.05 |
| 584 | VENEZUELA MOB | 0.68 | 0.05 |
| 5812 | VENEZUELA MOB | 0.68 | 0.05 |
| 5814 | VENEZUELA MOB | 0.68 | 0.05 |
| 5815 | VENEZUELA MOB | 0.68 | 0.05 |
| 5816 | VENEZUELA MOB | 0.68 | 0.05 |
| 5817 | VENEZUELA MOB | 0.68 | 0.05 |
| 5818 | VENEZUELA MOB | 0.68 | 0.05 |
| 5823 | VENEZUELA MOB | 0.68 | 0.05 |
| 58415 | VENEZUELA MOB | 0.68 | 0.05 |
| 58417 | VENEZUELA MOB DIGICEL | 0.68 | 0.05 |
| 58412 | VENEZUELA MOB DIGITEL | 0.68 | 0.05 |
| 58418 | VENEZUELA MOB INFONET | 0.68 | 0.05 |
| 58416 | VENEZUELA MOB MOVILNET | 0.68 | 0.05 |
| 58414 | VENEZUELA MOB TELCEL | 0.68 | 0.05 |
| 582 | VENEZUELA ROC | 0.68 | 0.05 |
| 58241 | VENEZUELA VALENCIA | 0.68 | 0.05 |
+-------------+------------------------+------+-------------+
20 rows in set (0.03 sec)
above are from table rates
do you need some more info?
just let me know
i appreciate all your help.
thanks
jason
Posted: Thu Jul 29, 2004 11:59 am
by jglicken
Code: Select all
select a.calldate, a.src, a.dst, b.name, sec_to_time(a.billsec) as billsec, format((a.billsec/60 * b.rate + b.connectCost), 2) totalcost from cdr a left join rates b on substring(a.dst,4) regexp (concat('<?/d+^', b.destination)) where src='erick' and dst like '011%' order by 'calldate' desc;
+---------------------+-------+--------------------+------+----------+-----------+
| calldate | src | dst | name | billsec | totalcost |
+---------------------+-------+--------------------+------+----------+-----------+
| 2004-07-27 10:52:52 | erick | 0115058885694 | NULL | 00:00:00 | NULL |
| 2004-07-27 10:52:23 | erick | 0115058885694 | NULL | 00:00:00 | NULL |
| 2004-07-27 10:51:13 | erick | 0115058885694 | NULL | 00:00:00 | NULL |
| 2004-07-27 10:46:45 | erick | 0115058885694 | NULL | 00:00:00 | NULL |
| 2004-07-03 13:47:34 | erick | 011582869237134 | NULL | 00:00:48 | NULL |
| 2004-07-03 13:46:01 | erick | 0115114229804 | NULL | 00:01:50 | NULL |
| 2004-06-30 00:10:42 | erick | 011582869237134 | NULL | 00:19:16 | NULL |
| 2004-06-29 23:50:15 | erick | 011582869237134 | NULL | 00:00:51 | NULL |
| 2004-05-09 00:11:40 | erick | 011582869237134 | NULL | 00:03:18 | NULL |
| 2004-04-17 13:52:56 | erick | 011582869237134 | NULL | 00:01:44 | NULL |
| 2004-04-17 13:50:20 | erick | 011582869237134 | NULL | 00:00:00 | NULL |
| 2004-04-17 13:48:21 | erick | 011584142869237134 | NULL | 00:00:00 | NULL |
| 2004-04-17 13:45:23 | erick | 011584142869237134 | NULL | 00:00:00 | NULL |
| 2004-04-16 18:51:01 | erick | 011584148681837 | NULL | 00:01:16 | NULL |
| 2004-04-16 10:23:00 | erick | 0115114220165 | NULL | 00:00:03 | NULL |
+---------------------+-------+--------------------+------+----------+-----------+
15 rows in set (0.00 sec)
i think i am closer, but now i get NULL for name and totalcost?
i added '<?/d+^' to my regexp and get the correct number of results, but missing the 2 fields i need?
thanks
jason
Posted: Thu Jul 29, 2004 12:49 pm
by feyd
it didn't join..
the problem I'm finding is because some destinations match several of the same records you're looking at, it's getting included.
this seems to work with the data you posted:
Code: Select all
SELECT DISTINCTROW b.destination, a.calldate, a.src, a.dst, b.name, sec_to_time( a.billsec ) AS billsec, format( a.billsec /60 * b.rate + b.connectCost, 2 ) totalcost
FROM cdr a
INNER JOIN rates b ON a.dst
REGEXP concat( '^', '011', b.destination )
LEFT JOIN rates c ON b.destination
REGEXP concat( '^', c.destination ) AND b.destination != c.destination
WHERE src = 'erick' AND c.destination IS NOT NULL
ORDER BY `calldate` DESC , b.destination DESC
outputs
Code: Select all
+-------------+---------------------+-------+--------------------+----------------------+----------+-----------+
| destination | calldate | src | dst | name | billsec | totalcost |
+-------------+---------------------+-------+--------------------+----------------------+----------+-----------+
| 582 | 2004-07-03 13:47:34 | erick | 011582869237134 | VENEZUELA ROC | 00:00:48 | 0.59 |
| 582 | 2004-06-30 00:10:42 | erick | 011582869237134 | VENEZUELA ROC | 00:19:16 | 13.15 |
| 582 | 2004-06-29 23:50:15 | erick | 011582869237134 | VENEZUELA ROC | 00:00:51 | 0.63 |
| 582 | 2004-05-09 00:11:40 | erick | 011582869237134 | VENEZUELA ROC | 00:03:18 | 2.29 |
| 582 | 2004-04-17 13:52:56 | erick | 011582869237134 | VENEZUELA ROC | 00:01:44 | 1.23 |
| 582 | 2004-04-17 13:48:21 | erick | 011582869237134 | VENEZUELA ROC | 00:00:00 | 0.05 |
| 58414 | 2004-04-17 13:45:23 | erick | 011584142869237134 | VENEZUELA MOB TELCEL | 00:00:00 | 0.05 |
| 584 | 2004-04-17 13:45:23 | erick | 011584142869237134 | VENEZUELA MOB | 00:00:00 | 0.05 |
| 58414 | 2004-04-16 18:51:01 | erick | 011584148681837 | VENEZUELA MOB TELCEL | 00:01:16 | 0.91 |
| 584 | 2004-04-16 18:51:01 | erick | 011584148681837 | VENEZUELA MOB | 00:01:16 | 0.91 |
+-------------+---------------------+-------+--------------------+----------------------+----------+-----------+
10 rows in set (0.00 sec)
note that there are 2 extra rows in the results that you'll have to process out, because they matched multiple destinations..
I added b.destination only to the select to show you what it's finding..
Posted: Thu Jul 29, 2004 1:30 pm
by jglicken
this is really good! but is their a way to do a once-only type match from right-to-left with mysql? so that once match is found starting from right it stops looking?
Posted: Fri Jul 30, 2004 9:09 am
by jglicken
actually, after looking over the results, the distinctrow will not work, because people call the same number more than once and this feature only uses one instance of each dst?
Posted: Fri Jul 30, 2004 10:59 am
by feyd
they may call the same number more than once, but, each of the call times will be different. So they are distinct rows.
Posted: Fri Jul 30, 2004 11:01 am
by jglicken
I should get back only 15 results, but it does not seem to do the distinctrow based on calldate?
Code: Select all
mysql> select distinctrow a.calldate, a.src, a.dst, b.destination, b.name, sec_to_time(a.billsec) as billsec, format((a.billsec/60 * b.rate + b.connectCost), 2) totalcost from cdr a left join rates b on substring(a.dst,4) regexp (concat('^', b.destination)) where src='erick' and dst like '011%' order by 'calldate' desc;
+---------------------+-------+--------------------+-------------+----------------------+----------+-----------+
| calldate | src | dst | destination | name | billsec | totalcost |
+---------------------+-------+--------------------+-------------+----------------------+----------+-----------+
| 2004-07-27 10:52:52 | erick | 0115058885694 | 505 | NICARAGUA | 00:00:00 | 0.05 |
| 2004-07-27 10:52:52 | erick | 0115058885694 | 5058 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:52:52 | erick | 0115058885694 | 50588 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:52:23 | erick | 0115058885694 | 505 | NICARAGUA | 00:00:00 | 0.05 |
| 2004-07-27 10:52:23 | erick | 0115058885694 | 5058 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:52:23 | erick | 0115058885694 | 50588 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:51:13 | erick | 0115058885694 | 505 | NICARAGUA | 00:00:00 | 0.05 |
| 2004-07-27 10:51:13 | erick | 0115058885694 | 5058 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:51:13 | erick | 0115058885694 | 50588 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:46:45 | erick | 0115058885694 | 505 | NICARAGUA | 00:00:00 | 0.05 |
| 2004-07-27 10:46:45 | erick | 0115058885694 | 5058 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-27 10:46:45 | erick | 0115058885694 | 50588 | NICARAGUA MOB | 00:00:00 | 0.05 |
| 2004-07-03 13:47:34 | erick | 011582869237134 | 58 | VENEZUELA | 00:00:48 | 0.59 |
| 2004-07-03 13:47:34 | erick | 011582869237134 | 582 | VENEZUELA ROC | 00:00:48 | 0.59 |
| 2004-07-03 13:46:01 | erick | 0115114229804 | 51 | PERU | 00:01:50 | 0.48 |
| 2004-07-03 13:46:01 | erick | 0115114229804 | 5114 | PERU LIMA | 00:01:50 | 0.48 |
| 2004-07-03 13:46:01 | erick | 0115114229804 | 51142 | PERU LIMA | 00:01:50 | 0.48 |
| 2004-06-30 00:10:42 | erick | 011582869237134 | 58 | VENEZUELA | 00:19:16 | 13.15 |
| 2004-06-30 00:10:42 | erick | 011582869237134 | 582 | VENEZUELA ROC | 00:19:16 | 13.15 |
| 2004-06-29 23:50:15 | erick | 011582869237134 | 58 | VENEZUELA | 00:00:51 | 0.63 |
| 2004-06-29 23:50:15 | erick | 011582869237134 | 582 | VENEZUELA ROC | 00:00:51 | 0.63 |
| 2004-05-09 00:11:40 | erick | 011582869237134 | 58 | VENEZUELA | 00:03:18 | 2.29 |
| 2004-05-09 00:11:40 | erick | 011582869237134 | 582 | VENEZUELA ROC | 00:03:18 | 2.29 |
| 2004-04-17 13:52:56 | erick | 011582869237134 | 58 | VENEZUELA | 00:01:44 | 1.23 |
| 2004-04-17 13:52:56 | erick | 011582869237134 | 582 | VENEZUELA ROC | 00:01:44 | 1.23 |
| 2004-04-17 13:50:20 | erick | 011582869237134 | 58 | VENEZUELA | 00:00:00 | 0.05 |
| 2004-04-17 13:50:20 | erick | 011582869237134 | 582 | VENEZUELA ROC | 00:00:00 | 0.05 |
| 2004-04-17 13:48:21 | erick | 011584142869237134 | 58 | VENEZUELA | 00:00:00 | 0.05 |
| 2004-04-17 13:48:21 | erick | 011584142869237134 | 584 | VENEZUELA MOB | 00:00:00 | 0.05 |
| 2004-04-17 13:48:21 | erick | 011584142869237134 | 58414 | VENEZUELA MOB TELCEL | 00:00:00 | 0.05 |
| 2004-04-17 13:45:23 | erick | 011584142869237134 | 58 | VENEZUELA | 00:00:00 | 0.05 |
| 2004-04-17 13:45:23 | erick | 011584142869237134 | 584 | VENEZUELA MOB | 00:00:00 | 0.05 |
| 2004-04-17 13:45:23 | erick | 011584142869237134 | 58414 | VENEZUELA MOB TELCEL | 00:00:00 | 0.05 |
| 2004-04-16 18:51:01 | erick | 011584148681837 | 58 | VENEZUELA | 00:01:16 | 0.91 |
| 2004-04-16 18:51:01 | erick | 011584148681837 | 584 | VENEZUELA MOB | 00:01:16 | 0.91 |
| 2004-04-16 18:51:01 | erick | 011584148681837 | 58414 | VENEZUELA MOB TELCEL | 00:01:16 | 0.91 |
| 2004-04-16 10:23:00 | erick | 0115114220165 | 51 | PERU | 00:00:03 | 0.06 |
| 2004-04-16 10:23:00 | erick | 0115114220165 | 5114 | PERU LIMA | 00:00:03 | 0.06 |
| 2004-04-16 10:23:00 | erick | 0115114220165 | 51142 | PERU LIMA | 00:00:03 | 0.06 |
+---------------------+-------+--------------------+-------------+----------------------+----------+-----------+
39 rows in set (2.34 sec)
Posted: Fri Jul 30, 2004 11:19 am
by feyd
only exact duplicate rows are removed.. you don't have that as you have destination in there, and name changes as well.
Posted: Fri Jul 30, 2004 12:15 pm
by jglicken
do you have any suggestions?