In tree format, the logical structure looks like as below:
Vishal Group||-------Vishal Group1| |----------------Vishal Group1.1|
|--------------------------Vishal Group1.1.1||-------Vishal Group2|
|----------------Vishal Group2.1| |--------------------------Vishal
Group2.1.1||-------Vishal Group3| |-------Vishal Group4|
|----------------Vishal Group4.1
I tried self join but couldn't get above result when I specify the above
mentioned condition.
Actually, the requirement is, I need to visit the lowest root for every group
(groups which falls under 'Vishal Group1' because he is the base group.) if
that group is not used in specific table then I would delete that record from
respective table.
Please help.
Thanks In Advance.
With Best Regards.
Vishal
On Friday, 2 October 2015 10:06 AM, "Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
Hi All,
There is some change in my previous SQL. Please consider below SQLs.
CREATE TABLE MYGROUP ( PK_GROUP GUID DEFAULT 'newid()' NOT NULL, DESCRIPTION
Varchar(255), LINKED_TO_GROUP GUID, PRIMARY KEY (PK_GROUP));
COMMIT;
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{11111111-111-1111-1111-111111111111} ', 'My Items', NULL);
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{CD1E33D1-1666-49B9-83BE-067687E4DDD6}', 'Vishal Group',
'{11111111-111-1111-1111-111111111111}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{4B42E7A5-B14C-451B-ACF5-83DD8A983A58}', 'Vishal Group1',
'{CD1E33D1-1666-49B9-83BE-067687E4DDD6}');INSERT INTO MYGROUP (PK_GROUP,
DESCRIPTION, LINKED_TO_GROUP) VALUES ('{A87E921D-0468-497D-92C5-19AB63751EE8}',
'Vishal Group1.1', '{4B42E7A5-B14C-451B-ACF5-83DD8A983A58}');INSERT INTO
MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{0FDC729A-8FCC-4D23-8619-436A459835DD}', 'Vishal Group1.1.1',
'{A87E921D-0468-497D-92C5-19AB63751EE8}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{2E15A2A9-7E40-422E-A5D6-C3F6C63F8591}', 'Vishal Group2',
'{CD1E33D1-1666-49B9-83BE-067687E4DDD6}');INSERT INTO MYGROUP (PK_GROUP,
DESCRIPTION, LINKED_TO_GROUP) VALUES ('{5EAC9866-F406-4BBD-B7B3-5CEEC3877C9B}',
'Vishal Group2.1', '{2E15A2A9-7E40-422E-A5D6-C3F6C63F8591}');INSERT INTO
MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{A326E6E3-030E-493B-AA0E-DC5D90DB080F}', 'Vishal Group2.1.1',
'{5EAC9866-F406-4BBD-B7B3-5CEEC3877C9B}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{3CF1FE37-EEC0-4E79-A3C5-DB78F6A9BC05}', 'Vishal Group3',
'{CD1E33D1-1666-49B9-83BE-067687E4DDD6}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{1EC302C8-0AB3-4F67-B47A-CC43401DF4ED}', 'Vishal Group4',
'{CD1E33D1-1666-49B9-83BE-067687E4DDD6}');INSERT INTO MYGROUP (PK_GROUP,
DESCRIPTION, LINKED_TO_GROUP) VALUES ('{2EB81764-04FA-4DDA-9AAB-A607BDC2756D}',
'Vishal Group4.1', '{1EC302C8-0AB3-4F67-B47A-CC43401DF4ED}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{7D939081-13F0-404C-9F2F-5222C628FDCC}', 'Sample BOMs',
'{11111111-111-1111-1111-111111111111}');INSERT INTO MYGROUP (PK_GROUP,
DESCRIPTION, LINKED_TO_GROUP) VALUES ('{C77D2255-AC47-461D-BEE5-7F3154C23AF1}',
'Test1', '{11111111-111-1111-1111-111111111111}');INSERT INTO MYGROUP
(PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{D054539A-BBBA-4E3F-9746-1522FF8A1E89}', 'Test2',
'{11111111-111-1111-1111-111111111111}');INSERT INTO MYGROUP (PK_GROUP,
DESCRIPTION, LINKED_TO_GROUP) VALUES ('{71B4751C-7096-4FB9-8D71-6BB19A3D9ED9}',
'Trailer Assy', '{11111111-111-1111-1111-111111111111}');INSERT INTO MYGROUP
(PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{F702BABB-73B0-4A49-B442-1C7C8A126335}', 'WIP',
'{11111111-111-1111-1111-111111111111}');INSERT INTO MYGROUP (PK_GROUP,
DESCRIPTION, LINKED_TO_GROUP) VALUES ('{FC74D59A-94E3-4209-BCEA-1B7606EA62F1}',
'mmmmmm', '{11111111-111-1111-1111-111111111111}');INSERT INTO MYGROUP
(PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{6E4354F9-B298-4737-9C18-51B4ACAC0734}', 'test1',
'{11111111-111-1111-1111-111111111111}');INSERT INTO MYGROUP (PK_GROUP,
DESCRIPTION, LINKED_TO_GROUP) VALUES ('{42A48EE0-D4EE-4828-BC11-D7F0D1FE5BEC}',
'test1', '{11111111-111-1111-1111-111111111111}');INSERT INTO MYGROUP
(PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{28AFE8E1-1221-4F94-BAE3-37EA6B360494}', 'test_2',
'{11111111-111-1111-1111-111111111111}');
COMMIT;------------------------------------------------------------------------------------------------------------------
After executing above SQLs, you would see below table data.
| PK_GROUP | DESCRIPTION | LINKED_TO_GROUP |
| {11111111-111-1111-1111-111111111111} | My Items | [null] |
| {CD1E33D1-1666-49B9-83BE-067687E4DDD6} | Vishal Group |
{11111111-111-1111-1111-111111111111} |
| {4B42E7A5-B14C-451B-ACF5-83DD8A983A58} | Vishal Group1 |
{CD1E33D1-1666-49B9-83BE-067687E4DDD6} |
| {A87E921D-0468-497D-92C5-19AB63751EE8} | Vishal Group1.1 |
{4B42E7A5-B14C-451B-ACF5-83DD8A983A58} |
| {0FDC729A-8FCC-4D23-8619-436A459835DD} | Vishal Group1.1.1 |
{A87E921D-0468-497D-92C5-19AB63751EE8} |
| {2E15A2A9-7E40-422E-A5D6-C3F6C63F8591} | Vishal Group2 |
{CD1E33D1-1666-49B9-83BE-067687E4DDD6} |
| {5EAC9866-F406-4BBD-B7B3-5CEEC3877C9B} | Vishal Group2.1 |
{2E15A2A9-7E40-422E-A5D6-C3F6C63F8591} |
| {A326E6E3-030E-493B-AA0E-DC5D90DB080F} | Vishal Group2.1.1 |
{5EAC9866-F406-4BBD-B7B3-5CEEC3877C9B} |
| {3CF1FE37-EEC0-4E79-A3C5-DB78F6A9BC05} | Vishal Group3 |
{CD1E33D1-1666-49B9-83BE-067687E4DDD6} |
| {1EC302C8-0AB3-4F67-B47A-CC43401DF4ED} | Vishal Group4 |
{CD1E33D1-1666-49B9-83BE-067687E4DDD6} |
| {2EB81764-04FA-4DDA-9AAB-A607BDC2756D} | Vishal Group4.1 |
{1EC302C8-0AB3-4F67-B47A-CC43401DF4ED} |
| {7D939081-13F0-404C-9F2F-5222C628FDCC} | Sample BOMs |
{11111111-111-1111-1111-111111111111} |
| {C77D2255-AC47-461D-BEE5-7F3154C23AF1} | Test1 |
{11111111-111-1111-1111-111111111111} |
| {D054539A-BBBA-4E3F-9746-1522FF8A1E89} | Test2 |
{11111111-111-1111-1111-111111111111} |
| {71B4751C-7096-4FB9-8D71-6BB19A3D9ED9} | Trailer Assy |
{11111111-111-1111-1111-111111111111} |
| {F702BABB-73B0-4A49-B442-1C7C8A126335} | WIP |
{11111111-111-1111-1111-111111111111} |
| {FC74D59A-94E3-4209-BCEA-1B7606EA62F1} | mmmmmm |
{11111111-111-1111-1111-111111111111} |
| {6E4354F9-B298-4737-9C18-51B4ACAC0734} | test1 |
{11111111-111-1111-1111-111111111111} |
| {42A48EE0-D4EE-4828-BC11-D7F0D1FE5BEC} | test1 |
{11111111-111-1111-1111-111111111111} |
| {28AFE8E1-1221-4F94-BAE3-37EA6B360494} | test_2 |
{11111111-111-1111-1111-111111111111} |
I need to get below data only, when I provide "Vishal Group1" value in
'Description' column, as a condition in SQL.
| PK_GROUP | DESCRIPTION | LINKED_TO_GROUP |
| {CD1E33D1-1666-49B9-83BE-067687E4DDD6} | Vishal Group |
{11111111-111-1111-1111-111111111111} |
| {4B42E7A5-B14C-451B-ACF5-83DD8A983A58} | Vishal Group1 |
{CD1E33D1-1666-49B9-83BE-067687E4DDD6} |
| {A87E921D-0468-497D-92C5-19AB63751EE8} | Vishal Group1.1 |
{4B42E7A5-B14C-451B-ACF5-83DD8A983A58} |
| {0FDC729A-8FCC-4D23-8619-436A459835DD} | Vishal Group1.1.1 |
{A87E921D-0468-497D-92C5-19AB63751EE8} |
| {2E15A2A9-7E40-422E-A5D6-C3F6C63F8591} | Vishal Group2 |
{CD1E33D1-1666-49B9-83BE-067687E4DDD6} |
| {5EAC9866-F406-4BBD-B7B3-5CEEC3877C9B} | Vishal Group2.1 |
{2E15A2A9-7E40-422E-A5D6-C3F6C63F8591} |
| {A326E6E3-030E-493B-AA0E-DC5D90DB080F} | Vishal Group2.1.1 |
{5EAC9866-F406-4BBD-B7B3-5CEEC3877C9B} |
| {3CF1FE37-EEC0-4E79-A3C5-DB78F6A9BC05} | Vishal Group3 |
{CD1E33D1-1666-49B9-83BE-067687E4DDD6} |
| {1EC302C8-0AB3-4F67-B47A-CC43401DF4ED} | Vishal Group4 |
{CD1E33D1-1666-49B9-83BE-067687E4DDD6} |
| {2EB81764-04FA-4DDA-9AAB-A607BDC2756D} | Vishal Group4.1 |
{1EC302C8-0AB3-4F67-B47A-CC43401DF4ED} |
In tree format, the logical structure looks like as below:
Vishal Group||-------Vishal Group1| |----------------Vishal Group1.1|
|--------------------------Vishal Group1.1.1||-------Vishal Group2|
|----------------Vishal Group2.1| |--------------------------Vishal
Group2.1.1||-------Vishal Group3| |-------Vishal Group4|
|----------------Vishal Group4.1
I tried self join but couldn't get above result when I specify the above
mentioned condition.
Actually, the requirement is, I need to visit the lowest root for every group
(groups which falls under 'Vishal Group1' because he is the base group.) if
that group is not used in specific table then I would delete that record from
respective table.
Please help.
Thanks In Advance.
With Best Regards.
Vishal
On Thursday, 1 October 2015 6:29 PM, "Vishal Tiwari
vishuals...@yahoo.co.in [firebird-support]" <firebird-support@yahoogroups.com>
wrote:
Hi All,
I have attached a table DDL and Insert record script in "Table Script.txt"
text file. And also attached a snap of how data looks in the table in the file
"Entire Table Data.png"
I need to get all the details for the main group called "Vishal Group1", please
refer "Expected Result.png". In "Expected Result.png" I have shown a tree
structure and the expected data as a result of SQL.
I tried with self join (generally we do for MGR and Employee columns), but so
success.
How do I get the result only for all groups which comes under "Vishal Group1".
please refer "Expected Result.png".
Thanks in advance.
With Best Regards.
Vishal
----------
CREATE TABLE MYGROUP
(
PK_GROUP GUID DEFAULT 'newid()' NOT NULL,
DESCRIPTION Varchar(255),
LINKED_TO_GROUP GUID,
PRIMARY KEY (PK_GROUP)
);
COMMIT;
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{11111111-111-1111-1111-111111111111} ', 'My Items', NULL);
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{CD1E33D1-1666-49B9-83BE-067687E4DDD6}', 'Vishal Group1', Null);
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{4B42E7A5-B14C-451B-ACF5-83DD8A983A58}', 'Vishal Group1.1',
'{CD1E33D1-1666-49B9-83BE-067687E4DDD6}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{A87E921D-0468-497D-92C5-19AB63751EE8}', 'Vishal Group1.1.1',
'{4B42E7A5-B14C-451B-ACF5-83DD8A983A58}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{2E15A2A9-7E40-422E-A5D6-C3F6C63F8591}', 'Vishal Group2.1',
'{CD1E33D1-1666-49B9-83BE-067687E4DDD6}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{5EAC9866-F406-4BBD-B7B3-5CEEC3877C9B}', 'Vishal Group2.1.1',
'{2E15A2A9-7E40-422E-A5D6-C3F6C63F8591}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{A326E6E3-030E-493B-AA0E-DC5D90DB080F}', 'Vishal Group2.1.1.1',
'{5EAC9866-F406-4BBD-B7B3-5CEEC3877C9B}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{3CF1FE37-EEC0-4E79-A3C5-DB78F6A9BC05}', 'Vishal Group3',
'{CD1E33D1-1666-49B9-83BE-067687E4DDD6}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{1EC302C8-0AB3-4F67-B47A-CC43401DF4ED}', 'Vishal Group4',
'{CD1E33D1-1666-49B9-83BE-067687E4DDD6}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{2EB81764-04FA-4DDA-9AAB-A607BDC2756D}', 'Vishal Group4.1',
'{1EC302C8-0AB3-4F67-B47A-CC43401DF4ED}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{7D939081-13F0-404C-9F2F-5222C628FDCC}', 'Sample BOMs',
'{11111111-111-1111-1111-111111111111}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{C77D2255-AC47-461D-BEE5-7F3154C23AF1}', 'Test1',
'{11111111-111-1111-1111-111111111111}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{D054539A-BBBA-4E3F-9746-1522FF8A1E89}', 'Test2',
'{11111111-111-1111-1111-111111111111}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{71B4751C-7096-4FB9-8D71-6BB19A3D9ED9}', 'Trailer Assy',
'{11111111-111-1111-1111-111111111111}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{F702BABB-73B0-4A49-B442-1C7C8A126335}', 'WIP',
'{11111111-111-1111-1111-111111111111}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{FC74D59A-94E3-4209-BCEA-1B7606EA62F1}', 'mmmmmm',
'{11111111-111-1111-1111-111111111111}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{6E4354F9-B298-4737-9C18-51B4ACAC0734}', 'test1',
'{11111111-111-1111-1111-111111111111}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{42A48EE0-D4EE-4828-BC11-D7F0D1FE5BEC}', 'test1',
'{11111111-111-1111-1111-111111111111}');
INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES
('{28AFE8E1-1221-4F94-BAE3-37EA6B360494}', 'test_2',
'{11111111-111-1111-1111-111111111111}');
COMMIT;
[Non-text portions of this message have been removed]
#yiv4965396348 -- #yiv4965396348ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4965396348
#yiv4965396348ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4965396348
#yiv4965396348ygrp-mkp #yiv4965396348hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4965396348 #yiv4965396348ygrp-mkp #yiv4965396348ads
{margin-bottom:10px;}#yiv4965396348 #yiv4965396348ygrp-mkp .yiv4965396348ad
{padding:0 0;}#yiv4965396348 #yiv4965396348ygrp-mkp .yiv4965396348ad p
{margin:0;}#yiv4965396348 #yiv4965396348ygrp-mkp .yiv4965396348ad a
{color:#0000ff;text-decoration:none;}#yiv4965396348 #yiv4965396348ygrp-sponsor
#yiv4965396348ygrp-lc {font-family:Arial;}#yiv4965396348
#yiv4965396348ygrp-sponsor #yiv4965396348ygrp-lc #yiv4965396348hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4965396348
#yiv4965396348ygrp-sponsor #yiv4965396348ygrp-lc .yiv4965396348ad
{margin-bottom:10px;padding:0 0;}#yiv4965396348 #yiv4965396348actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4965396348
#yiv4965396348activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4965396348
#yiv4965396348activity span {font-weight:700;}#yiv4965396348
#yiv4965396348activity span:first-child
{text-transform:uppercase;}#yiv4965396348 #yiv4965396348activity span a
{color:#5085b6;text-decoration:none;}#yiv4965396348 #yiv4965396348activity span
span {color:#ff7900;}#yiv4965396348 #yiv4965396348activity span
.yiv4965396348underline {text-decoration:underline;}#yiv4965396348
.yiv4965396348attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4965396348 .yiv4965396348attach div a
{text-decoration:none;}#yiv4965396348 .yiv4965396348attach img
{border:none;padding-right:5px;}#yiv4965396348 .yiv4965396348attach label
{display:block;margin-bottom:5px;}#yiv4965396348 .yiv4965396348attach label a
{text-decoration:none;}#yiv4965396348 blockquote {margin:0 0 0
4px;}#yiv4965396348 .yiv4965396348bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4965396348
.yiv4965396348bold a {text-decoration:none;}#yiv4965396348 dd.yiv4965396348last
p a {font-family:Verdana;font-weight:700;}#yiv4965396348 dd.yiv4965396348last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4965396348
dd.yiv4965396348last p span.yiv4965396348yshortcuts
{margin-right:0;}#yiv4965396348 div.yiv4965396348attach-table div div a
{text-decoration:none;}#yiv4965396348 div.yiv4965396348attach-table
{width:400px;}#yiv4965396348 div.yiv4965396348file-title a, #yiv4965396348
div.yiv4965396348file-title a:active, #yiv4965396348
div.yiv4965396348file-title a:hover, #yiv4965396348 div.yiv4965396348file-title
a:visited {text-decoration:none;}#yiv4965396348 div.yiv4965396348photo-title a,
#yiv4965396348 div.yiv4965396348photo-title a:active, #yiv4965396348
div.yiv4965396348photo-title a:hover, #yiv4965396348
div.yiv4965396348photo-title a:visited {text-decoration:none;}#yiv4965396348
div#yiv4965396348ygrp-mlmsg #yiv4965396348ygrp-msg p a
span.yiv4965396348yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4965396348
.yiv4965396348green {color:#628c2a;}#yiv4965396348 .yiv4965396348MsoNormal
{margin:0 0 0 0;}#yiv4965396348 o {font-size:0;}#yiv4965396348
#yiv4965396348photos div {float:left;width:72px;}#yiv4965396348
#yiv4965396348photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4965396348
#yiv4965396348photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4965396348
#yiv4965396348reco-category {font-size:77%;}#yiv4965396348
#yiv4965396348reco-desc {font-size:77%;}#yiv4965396348 .yiv4965396348replbq
{margin:4px;}#yiv4965396348 #yiv4965396348ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4965396348 #yiv4965396348ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4965396348
#yiv4965396348ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4965396348
#yiv4965396348ygrp-mlmsg select, #yiv4965396348 input, #yiv4965396348 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4965396348
#yiv4965396348ygrp-mlmsg pre, #yiv4965396348 code {font:115%
monospace;}#yiv4965396348 #yiv4965396348ygrp-mlmsg *
{line-height:1.22em;}#yiv4965396348 #yiv4965396348ygrp-mlmsg #yiv4965396348logo
{padding-bottom:10px;}#yiv4965396348 #yiv4965396348ygrp-msg p a
{font-family:Verdana;}#yiv4965396348 #yiv4965396348ygrp-msg
p#yiv4965396348attach-count span {color:#1E66AE;font-weight:700;}#yiv4965396348
#yiv4965396348ygrp-reco #yiv4965396348reco-head
{color:#ff7900;font-weight:700;}#yiv4965396348 #yiv4965396348ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4965396348 #yiv4965396348ygrp-sponsor
#yiv4965396348ov li a {font-size:130%;text-decoration:none;}#yiv4965396348
#yiv4965396348ygrp-sponsor #yiv4965396348ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4965396348
#yiv4965396348ygrp-sponsor #yiv4965396348ov ul {margin:0;padding:0 0 0
8px;}#yiv4965396348 #yiv4965396348ygrp-text
{font-family:Georgia;}#yiv4965396348 #yiv4965396348ygrp-text p {margin:0 0 1em
0;}#yiv4965396348 #yiv4965396348ygrp-text tt {font-size:120%;}#yiv4965396348
#yiv4965396348ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4965396348
