select n.nid, c.field_vr_node_id_value as provider, if(t.tid=12, c.field_vc_res_ad_zoneid_value, if(t.tid=13,c.field_vc_bus_ad_zoneid_value, 0)) as zoneid, c.field_vr_num_reviews_value as num, c.field_vr_review_rating_value as avg, n.title as title from node n, content_type_voip_provider c, term_node t where c.nid = n.nid and c.vid = n.vid and t.nid = n.nid and t.vid = n.vid and n.nid = 10 limit 1
|
![]() |
![]() |
![]() |
||||||||||||||||||
|
||||||||||||||||||||
|