<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
<title>Comments on snippet: '(Player - Player Agent) Images'</title>
<link>http://snipplr.com</link>
<description>Snipplr comments feed'</description>
<language>en-us</language>
<pubDate>Thu, 23 May 2013 22:45:21 GMT</pubDate>
<item>
<title>karthi said on 2/28/12</title>
<link>http://snipplr.com/view/63503/player--player-agent-images/</link>
<description><![CDATA[ SELECT comp_owner_id,user_images,
    IF(comp_owner_id !=0,(SELECT comp_name from player_agent_list WHERE user_id = comp_owner_id),comp_name) 
    as Company_Name,
    IF(comp_Country !=0,(SELECT country_name from country WHERE country_id = comp_Country),
    (SELECT country_name from country WHERE country_id =
    (SELECT Country from player_agent_list WHERE user_id = comp_owner_id)) )
    as Country_Name,
    IF(comp_State !=0,(SELECT state_name from state WHERE state_id = comp_State),
    (SELECT state_name from state WHERE state_id =
    (SELECT State from player_agent_list WHERE user_id = comp_owner_id)) ) 
    as State_Name,
    IF(comp_City !=0,(SELECT city_name from city WHERE city_id = comp_City),
    (SELECT city_name from city WHERE city_id = 
    (SELECT City from player_agent_list WHERE user_id = comp_owner_id)) )  
    as City_Name
    FROM 
    (
    SELECT asub.*,pr.type,
    CASE
    WHEN pr.type='player' THEN (SELECT image FROM football_player_list WHERE user_id = pr.id)
    WHEN pr.type='player_agent' THEN (SELECT image FROM player_agent_list WHERE user_id = pr.id)
    ELSE '-' END as user_images,
    CASE 
    WHEN pr.type='player_agent' THEN  (SELECT COALESCE(owner_id,(SELECT owner_id FROM player_agent_list 
    WHERE user_id = owner_id)) from player_agent_list WHERE user_id = pr.id )  
    ELSE '-' END as comp_owner_id,
    CASE 
    WHEN pr.type='player_agent' THEN  (SELECT COALESCE(Country,(SELECT Country FROM player_agent_list 
    WHERE user_id = owner_id)) from player_agent_list WHERE user_id = pr.id )
    ELSE '-' END as comp_Country,
    CASE 
    WHEN pr.type='player_agent' THEN  (SELECT COALESCE(State,(SELECT State FROM player_agent_list 
    WHERE user_id = owner_id)) from player_agent_list WHERE user_id = pr.id )  
    ELSE '-' END as comp_State,
    CASE 
    WHEN pr.type='player_agent' THEN  (SELECT COALESCE(City,(SELECT City FROM player_agent_list 
    WHERE user_id = owner_id)) from player_agent_list WHERE user_id = pr.id )  
    ELSE '-' END as comp_City,
    CASE 
    WHEN pr.type='player_agent' THEN (SELECT comp_name from player_agent_list WHERE user_id = pr.id ) 
    ELSE '-' END as comp_name
        
    FROM `agent_subscribe` as asub INNER JOIN profile as pr ON asub.member_id = pr.id  WHERE player_id = 1
    ) 
   as derived_res ]]></description>
<pubDate>Tue, 28 Feb 2012 18:36:06 GMT</pubDate>
<guid>http://snipplr.com/view/63503/player--player-agent-images/</guid>
</item>
</channel>
</rss>