Home     Practical Lawyer     Latest Judgments     Case-Law     Legal Articles     SCC Calendar     Contact Us     About Us     Press Releases
EBC Webstore
Subscriptions on EBC Webstore >>
My Wishlist | My Account | Cart  Cart  
  Home » Webstore » New Books
 Subjects
 Administrative Law
   Bias And Malafides
   Essential Commodities
   General
   Government Servants
   National Security
   Public Utilities
   Suspension
   Tribunals
 Biographies
   General
 Business
   Air Law
   Arbitration
   Banking Law
   Commercial Drafting
   Company Law
   Consumer Protection
   Corporate Law
   Engineering Contracts
   Finance
   Foreign Exchange
   General
   Immigration
   Import-Export
   Insolvency
   Insurance Law
   International Trade
   Labour Laws
   Management
   Marine
   Mercantile Law
   Negotiable Instruments
   Partnership
   Professionals
   Property Law
   Securities
   Taxation
   Transport
 Civil Litigation
   Civil Procedure
   Compensation
   Court Work
   Disputed Documents
   Drafting and Conveyancing
   Equity
   General
   Practice
   Specific Relief
   Stamp Act
   Torts
 Co-operative Societies
   Charitable Endowments
   Co-Operative Societies
 Constitutional
   Constitutional Law
   Election
   Equality
   Freedom Of Information
   Interpretation Of Statutes
   Local Government
   Media
   Media and Entertainment
   Preamble
   Precedents
   Writs
 Criminal Law
   Accident Compensation
   Arms and Explosives
   Crimes and Criminology
   Criminal Law And Procedure
   Evidence
   General
   Penal Code
 Dictionaries
   Dictionaries
 Digests
   Supreme Court Digest Series
   Supreme Court Yearly Digest
 Environment
   Environment Law
 Family and Health Law
   Medico- Legal
   Disability
   Children
   Medical Jurisprudence
   Health and Medical
   General
   Tourism
   Family Law
   Women and Law
 General Interest
   Biography
   Business, Finance and Law
   History
   Reference
   Religion and Spirituality
   Scientific, Technical and Medical
   Society, Politics and Philosophy
 Intellectual Property
   Cinemas
   Computer Programmes
   Cyber Laws
   General
   Videos
 International Law
   Singapore Law
   General
   Human Rights
   International Institutions
   International Trade
 Law Students Series
   Entrance Exams
   Social Sciences
 Legal History
   History
 Legal Systems
   Education and Research
   English
   Judgments
   Nations
   Thought Provoking Books
 Legal Theory
   Jurisprudence
 Other books
   Hindi books
 Social Offences
   Sexual Offences
   General
 Statutes/Bareacts
   Statutes/Bareacts
   U.P. Statutes/Bareacts
 Trusts
   Public Trusts
   Trusts
New Books
-

select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and to_days(now()) - to_days(p.products_date_added) < 31 order by pd.products_name limit -12, 12

[TEP STOP]