SELECT current_plan_package,business_name,
business_id,
big_description,
small_description,
address1,
address2,
building_name,
area, city,
nearest_busstop,
state,
country,
zipcode, seo_url FROM bd_business_description WHERE mirror='0' AND status='1' AND city='Ikoyi' AND state='Lagos' AND country='Nigeria' AND business_id IN( SELECT business_id FROM bd_business_category WHERE category_id IN (SELECT CategoryID FROM bd_category WHERE Name='Legal Services') ) ORDER BY current_plan_package DESC
A legal institution that offers legal and law services which include
Arbitration such as resolution, negotiation and mediation of commercial/company disputes.
Litigation includes civil and commercial litigation for law suit, legal case, legal prosecution, trial, etc.
Intellectual Property such as registered designs, unlawful competitions, copyright counterfeiting, parallel importation franchising, intellectual property business, etc.
Commercial law such as legal advices on international and domestic corporations, banks, financial institutions, building, engineering, financial services, information technology, manufacturing, mining, energy, pharmaceuticals, transport, etc.
Aviation includes provision of legal advice and assistance on the laws and regulations governing the airline transport industry such as residence permits, immigration matters, regularization formalities for expatriate, etc.
Telecommunication such as telecommunication law advisory services on regulatory authority, licensing, competition policy, tariffs regulations, quality service, interconnection issues, infrastructure sharing, scarce resources management, universal service, and penalties, sanctions, etc.