• mail us help@24marketresearch.com
  • Int'l (+1)-646-781-7170
  • UK(Toll free) +44-800-088-5734

TOP CATEGORY: Chemicals & Materials | Life Sciences | Banking & Finance | ICT Media

Global L-Theanine Market Professional Survey Report 2018

Global L-Theanine Market Professional Survey Report 2018

  • Category:Chemicals and Materials
  • Published on : 04 July 2018
  • Pages :107
  • Formats:
  • Report Code:24MRES-2901789
Click for best price

Best Price: $2800

This report studies the global L-Theanine market status and forecast, categorizes the global L-Theanine market size (value & volume) by manufacturers, type, application, and region. This report focuses on the top manufacturers in North America, Europe, Japan, China, India, Southeast Asia and other regions (Central & South America, and Middle East & Africa).

The global L-Theanine market is valued at million US$ in 2017 and will reach million US$ by the end of 2025, growing at a CAGR of during 2018-2025.

The major manufacturers covered in this report
Taiyo Kagaku
Blue California
Infre
ZheJiang TianRui Chemical
Qu Zhou Joy Chemical
Sichuan Tongsheng Amino acid
Hongya Yaxing Biotechnology
FarmaSino Pharmaceuticals
Hangzhou Qinyuan Natural Plant High-tech
Wuxi Southern Yangtze University Biotech

Geographically, this report studies the top producers and consumers, focuses on product capacity, production, value, consumption, market share and growth opportunity in these key regions, covering
North America
Europe
China
Japan
India
Southeast Asia
Other regions (Central & South America, Middle East & Africa)

We can also provide the customized separate regional or country-level reports, for the following regions:
North America
United States
Canada
Mexico
Asia-Pacific
China
India
Japan
South Korea
Australia
Indonesia
Singapore
Rest of Asia-Pacific
Europe
Germany
France
UK
Italy
Spain
Russia
Rest of Europe
Central & South America
Brazil
Argentina
Rest of South America
Middle East & Africa
Saudi Arabia
Turkey
Rest of Middle East & Africa

On the basis of product, this report displays the production, revenue, price, market share and growth rate of each type, primarily split into
Tea Extracts
Chemical Synthesis
Microbial Fermentation

By Application, the market can be split into
Food & Beverage
Health Care Product
Pharmaceutical Industry

The study objectives of this report are:
To analyze and study the global L-Theanine capacity, production, value, consumption, status (2013-2017) and forecast (2018-2025);
Focuses on the key L-Theanine manufacturers, to study the capacity, production, value, market share and development plans in future.
Focuses on the global key manufacturers, to define, describe and analyze the market competition landscape, SWOT analysis.
To define, describe and forecast the market by type, application and region.
To analyze the global and key regions market potential and advantage, opportunity and challenge, restraints and risks.
To identify significant trends and factors driving or inhibiting the market growth.
To analyze the opportunities in the market for stakeholders by identifying the high growth segments.
To strategically analyze each submarket with respect to individual growth trend and their contribution to the market.
To analyze competitive developments such as expansions, agreements, new product launches, and acquisitions in the market.
To strategically profile the key players and comprehensively analyze their growth strategies.

In this study, the years considered to estimate the market size of L-Theanine are as follows:
History Year: 2013-2017
Base Year: 2017
Estimated Year: 2018
Forecast Year 2018 to 2025

For the data information by region, company, type and application, 2017 is considered as the base year. Whenever data information was unavailable for the base year, the prior year has been considered.

Key Stakeholders
L-Theanine Manufacturers
L-Theanine Distributors/Traders/Wholesalers
L-Theanine Subcomponent Manufacturers
Industry Association
Downstream Vendors

Available Customizations
With the given market data, QYResearch offers customizations according to the company's specific needs. The following customization options are available for the report:
Regional and country-level analysis of the L-Theanine market, by end-use.
Detailed analysis and profiles of additional market players.

TABLE OF CONTENTS

Table of Contents

Global L-Theanine Market Professional Survey Report 2018
1 Industry Overview of L-Theanine
1.1 Definition and Specifications of L-Theanine
1.1.1 Definition of L-Theanine
1.1.2 Specifications of L-Theanine
1.2 Classification of L-Theanine
1.2.1 Tea Extracts
1.2.2 Chemical Synthesis
1.2.3 Microbial Fermentation
1.3 Applications of L-Theanine
1.3.1 Food & Beverage
1.3.2 Health Care Product
1.3.3 Pharmaceutical Industry
1.4 Market Segment by Regions
1.4.1 North America
1.4.2 Europe
1.4.3 China
1.4.4 Japan
1.4.5 Southeast Asia
1.4.6 India

2 Manufacturing Cost Structure Analysis of L-Theanine
2.1 Raw Material and Suppliers
2.2 Manufacturing Cost Structure Analysis of L-Theanine
2.3 Manufacturing Process Analysis of L-Theanine
2.4 Industry Chain Structure of L-Theanine

3 Technical Data and Manufacturing Plants Analysis of L-Theanine
3.1 Capacity and Commercial Production Date of Global L-Theanine Major Manufacturers in 2017
3.2 Manufacturing Plants Distribution of Global L-Theanine Major Manufacturers in 2017
3.3 R&D Status and Technology Source of Global L-Theanine Major Manufacturers in 2017
3.4 Raw Materials Sources Analysis of Global L-Theanine Major Manufacturers in 2017

4 Global L-Theanine Overall Market Overview
4.1 2013-2018E Overall Market Analysis
4.2 Capacity Analysis
4.2.1 2013-2018E Global L-Theanine Capacity and Growth Rate Analysis
4.2.2 2017 L-Theanine Capacity Analysis (Company Segment)
4.3 Sales Analysis
4.3.1 2013-2018E Global L-Theanine Sales and Growth Rate Analysis
4.3.2 2017 L-Theanine Sales Analysis (Company Segment)
4.4 Sales Price Analysis
4.4.1 2013-2018E Global L-Theanine Sales Price
4.4.2 2017 L-Theanine Sales Price Analysis (Company Segment)

5 L-Theanine Regional Market Analysis
5.1 North America L-Theanine Market Analysis
5.1.1 North America L-Theanine Market Overview
5.1.2 North America 2013-2018E L-Theanine Local Supply, Import, Export, Local Consumption Analysis
5.1.3 North America 2013-2018E L-Theanine Sales Price Analysis
5.1.4 North America 2017 L-Theanine Market Share Analysis
5.2 Europe L-Theanine Market Analysis
5.2.1 Europe L-Theanine Market Overview
5.2.2 Europe 2013-2018E L-Theanine Local Supply, Import, Export, Local Consumption Analysis
5.2.3 Europe 2013-2018E L-Theanine Sales Price Analysis
5.2.4 Europe 2017 L-Theanine Market Share Analysis
5.3 China L-Theanine Market Analysis
5.3.1 China L-Theanine Market Overview
5.3.2 China 2013-2018E L-Theanine Local Supply, Import, Export, Local Consumption Analysis
5.3.3 China 2013-2018E L-Theanine Sales Price Analysis
5.3.4 China 2017 L-Theanine Market Share Analysis
5.4 Japan L-Theanine Market Analysis
5.4.1 Japan L-Theanine Market Overview
5.4.2 Japan 2013-2018E L-Theanine Local Supply, Import, Export, Local Consumption Analysis
5.4.3 Japan 2013-2018E L-Theanine Sales Price Analysis
5.4.4 Japan 2017 L-Theanine Market Share Analysis
5.5 Southeast Asia L-Theanine Market Analysis
5.5.1 Southeast Asia L-Theanine Market Overview
5.5.2 Southeast Asia 2013-2018E L-Theanine Local Supply, Import, Export, Local Consumption Analysis
5.5.3 Southeast Asia 2013-2018E L-Theanine Sales Price Analysis
5.5.4 Southeast Asia 2017 L-Theanine Market Share Analysis
5.6 India L-Theanine Market Analysis
5.6.1 India L-Theanine Market Overview
5.6.2 India 2013-2018E L-Theanine Local Supply, Import, Export, Local Consumption Analysis
5.6.3 India 2013-2018E L-Theanine Sales Price Analysis
5.6.4 India 2017 L-Theanine Market Share Analysis

6 Global 2013-2018E L-Theanine Segment Market Analysis (by Type)
6.1 Global 2013-2018E L-Theanine Sales by Type
6.2 Different Types of L-Theanine Product Interview Price Analysis
6.3 Different Types of L-Theanine Product Driving Factors Analysis
6.3.1 Tea Extracts Growth Driving Factor Analysis
6.3.2 Chemical Synthesis Growth Driving Factor Analysis
6.3.3 Microbial Fermentation Growth Driving Factor Analysis

7 Global 2013-2018E L-Theanine Segment Market Analysis (by Application)
7.1 Global 2013-2018E L-Theanine Consumption by Application
7.2 Different Application of L-Theanine Product Interview Price Analysis
7.3 Different Application of L-Theanine Product Driving Factors Analysis
7.3.1 Food & Beverage of L-Theanine Growth Driving Factor Analysis
7.3.2 Health Care Product of L-Theanine Growth Driving Factor Analysis
7.3.3 Pharmaceutical Industry of L-Theanine Growth Driving Factor Analysis

8 Major Manufacturers Analysis of L-Theanine
8.1 Taiyo Kagaku
8.1.1 Company Profile
8.1.2 Product Picture and Specifications
8.1.2.1 Product A
8.1.2.2 Product B
8.1.3 Taiyo Kagaku 2017 L-Theanine Sales, Ex-factory Price, Revenue, Gross Margin Analysis
8.1.4 Taiyo Kagaku 2017 L-Theanine Business Region Distribution Analysis
8.2 Blue California
8.2.1 Company Profile
8.2.2 Product Picture and Specifications
8.2.2.1 Product A
8.2.2.2 Product B
8.2.3 Blue California 2017 L-Theanine Sales, Ex-factory Price, Revenue, Gross Margin Analysis
8.2.4 Blue California 2017 L-Theanine Business Region Distribution Analysis
8.3 Infre
8.3.1 Company Profile
8.3.2 Product Picture and Specifications
8.3.2.1 Product A
8.3.2.2 Product B
8.3.3 Infre 2017 L-Theanine Sales, Ex-factory Price, Revenue, Gross Margin Analysis
8.3.4 Infre 2017 L-Theanine Business Region Distribution Analysis
8.4 ZheJiang TianRui Chemical
8.4.1 Company Profile
8.4.2 Product Picture and Specifications
8.4.2.1 Product A
8.4.2.2 Product B
8.4.3 ZheJiang TianRui Chemical 2017 L-Theanine Sales, Ex-factory Price, Revenue, Gross Margin Analysis
8.4.4 ZheJiang TianRui Chemical 2017 L-Theanine Business Region Distribution Analysis
8.5 Qu Zhou Joy Chemical
8.5.1 Company Profile
8.5.2 Product Picture and Specifications
8.5.2.1 Product A
8.5.2.2 Product B
8.5.3 Qu Zhou Joy Chemical 2017 L-Theanine Sales, Ex-factory Price, Revenue, Gross Margin Analysis
8.5.4 Qu Zhou Joy Chemical 2017 L-Theanine Business Region Distribution Analysis
8.6 Sichuan Tongsheng Amino acid
8.6.1 Company Profile
8.6.2 Product Picture and Specifications
8.6.2.1 Product A
8.6.2.2 Product B
8.6.3 Sichuan Tongsheng Amino acid 2017 L-Theanine Sales, Ex-factory Price, Revenue, Gross Margin Analysis
8.6.4 Sichuan Tongsheng Amino acid 2017 L-Theanine Business Region Distribution Analysis
8.7 Hongya Yaxing Biotechnology
8.7.1 Company Profile
8.7.2 Product Picture and Specifications
8.7.2.1 Product A
8.7.2.2 Product B
8.7.3 Hongya Yaxing Biotechnology 2017 L-Theanine Sales, Ex-factory Price, Revenue, Gross Margin Analysis
8.7.4 Hongya Yaxing Biotechnology 2017 L-Theanine Business Region Distribution Analysis
8.8 FarmaSino Pharmaceuticals
8.8.1 Company Profile
8.8.2 Product Picture and Specifications
8.8.2.1 Product A
8.8.2.2 Product B
8.8.3 FarmaSino Pharmaceuticals 2017 L-Theanine Sales, Ex-factory Price, Revenue, Gross Margin Analysis
8.8.4 FarmaSino Pharmaceuticals 2017 L-Theanine Business Region Distribution Analysis
8.9 Hangzhou Qinyuan Natural Plant High-tech
8.9.1 Company Profile
8.9.2 Product Picture and Specifications
8.9.2.1 Product A
8.9.2.2 Product B
8.9.3 Hangzhou Qinyuan Natural Plant High-tech 2017 L-Theanine Sales, Ex-factory Price, Revenue, Gross Margin Analysis
8.9.4 Hangzhou Qinyuan Natural Plant High-tech 2017 L-Theanine Business Region Distribution Analysis
8.10 Wuxi Southern Yangtze University Biotech
8.10.1 Company Profile
8.10.2 Product Picture and Specifications
8.10.2.1 Product A
8.10.2.2 Product B
8.10.3 Wuxi Southern Yangtze University Biotech 2017 L-Theanine Sales, Ex-factory Price, Revenue, Gross Margin Analysis
8.10.4 Wuxi Southern Yangtze University Biotech 2017 L-Theanine Business Region Distribution Analysis

9 Development Trend of Analysis of L-Theanine Market
9.1 Global L-Theanine Market Trend Analysis
9.1.1 Global 2018-2025 L-Theanine Market Size (Volume and Value) Forecast
9.1.2 Global 2018-2025 L-Theanine Sales Price Forecast
9.2 L-Theanine Regional Market Trend
9.2.1 North America 2018-2025 L-Theanine Consumption Forecast
9.2.2 Europe 2018-2025 L-Theanine Consumption Forecast
9.2.3 China 2018-2025 L-Theanine Consumption Forecast
9.2.4 Japan 2018-2025 L-Theanine Consumption Forecast
9.2.5 Southeast Asia 2018-2025 L-Theanine Consumption Forecast
9.2.6 India 2018-2025 L-Theanine Consumption Forecast
9.3 L-Theanine Market Trend (Product Type)
9.4 L-Theanine Market Trend (Application)

10 L-Theanine Marketing Type Analysis
10.1 L-Theanine Regional Marketing Type Analysis
10.2 L-Theanine International Trade Type Analysis
10.3 Traders or Distributors with Contact Information of L-Theanine by Region
10.4 L-Theanine Supply Chain Analysis

11 Consumers Analysis of L-Theanine
11.1 Consumer 1 Analysis
11.2 Consumer 2 Analysis
11.3 Consumer 3 Analysis
11.4 Consumer 4 Analysis

12 Conclusion of the Global L-Theanine Market Professional Survey Report 2017
Methodology
Analyst Introduction
Data Source

LIST OF TABLES & FIGURES

List of Tables and Figures
Figure Picture of L-Theanine
Table Product Specifications of L-Theanine
Table Classification of L-Theanine
Figure Global Production Market Share of L-Theanine by Type in 2017
Figure Tea Extracts Picture
Table Major Manufacturers of Tea Extracts
Figure Chemical Synthesis Picture
Table Major Manufacturers of Chemical Synthesis
Figure Microbial Fermentation Picture
Table Major Manufacturers of Microbial Fermentation
Table Applications of L-Theanine
Figure Global Consumption Volume Market Share of L-Theanine by Application in 2017
Figure Food & Beverage Examples
Table Major Consumers in Food & Beverage
Figure Health Care Product Examples
Table Major Consumers in Health Care Product
Figure Pharmaceutical Industry Examples
Table Major Consumers in Pharmaceutical Industry
Figure Market Share of L-Theanine by Regions
Figure North America L-Theanine Market Size (Million USD) (2013-2025)
Figure Europe L-Theanine Market Size (Million USD) (2013-2025)
Figure China L-Theanine Market Size (Million USD) (2013-2025)
Figure Japan L-Theanine Market Size (Million USD) (2013-2025)
Figure Southeast Asia L-Theanine Market Size (Million USD) (2013-2025)
Figure India L-Theanine Market Size (Million USD) (2013-2025)
Table L-Theanine Raw Material and Suppliers
Table Manufacturing Cost Structure Analysis of L-Theanine in 2017
Figure Manufacturing Process Analysis of L-Theanine
Figure Industry Chain Structure of L-Theanine
Table Capacity and Commercial Production Date of Global L-Theanine Major Manufacturers in 2017
Table Manufacturing Plants Distribution of Global L-Theanine Major Manufacturers in 2017
Table R&D Status and Technology Source of Global L-Theanine Major Manufacturers in 2017
Table Raw Materials Sources Analysis of Global L-Theanine Major Manufacturers in 2017
Table Global Capacity, Sales , Price, Cost, Sales Revenue (M USD) and Gross Margin of L-Theanine 2013-2018E
Figure Global 2013-2018E L-Theanine Market Size (Volume) and Growth Rate
Figure Global 2013-2018E L-Theanine Market Size (Value) and Growth Rate
Table 2013-2018E Global L-Theanine Capacity and Growth Rate
Table 2017 Global L-Theanine Capacity (K MT) List (Company Segment)
Table 2013-2018E Global L-Theanine Sales (K MT) and Growth Rate
Table 2017 Global L-Theanine Sales (K MT) List (Company Segment)
Table 2013-2018E Global L-Theanine Sales Price (USD/MT)
Table 2017 Global L-Theanine Sales Price (USD/MT) List (Company Segment)
Figure North America Capacity Overview
Table North America Supply, Import, Export and Consumption (K MT) of L-Theanine 2013-2018E
Figure North America 2013-2018E L-Theanine Sales Price (USD/MT)
Figure North America 2017 L-Theanine Sales Market Share
Figure Europe Capacity Overview
Table Europe Supply, Import, Export and Consumption (K MT) of L-Theanine 2013-2018E
Figure Europe 2013-2018E L-Theanine Sales Price (USD/MT)
Figure Europe 2017 L-Theanine Sales Market Share
Figure China Capacity Overview
Table China Supply, Import, Export and Consumption (K MT) of L-Theanine 2013-2018E
Figure China 2013-2018E L-Theanine Sales Price (USD/MT)
Figure China 2017 L-Theanine Sales Market Share
Figure Japan Capacity Overview
Table Japan Supply, Import, Export and Consumption (K MT) of L-Theanine 2013-2018E
Figure Japan 2013-2018E L-Theanine Sales Price (USD/MT)
Figure Japan 2017 L-Theanine Sales Market Share
Figure Southeast Asia Capacity Overview
Table Southeast Asia Supply, Import, Export and Consumption (K MT) of L-Theanine 2013-2018E
Figure Southeast Asia 2013-2018E L-Theanine Sales Price (USD/MT)
Figure Southeast Asia 2017 L-Theanine Sales Market Share
Figure India Capacity Overview
Table India Supply, Import, Export and Consumption (K MT) of L-Theanine 2013-2018E
Figure India 2013-2018E L-Theanine Sales Price (USD/MT)
Figure India 2017 L-Theanine Sales Market Share
Table Global 2013-2018E L-Theanine Sales (K MT) by Type
Table Different Types L-Theanine Product Interview Price
Table Global 2013-2018E L-Theanine Sales (K MT) by Application
Table Different Application L-Theanine Product Interview Price
Table Taiyo Kagaku Information List
Table Product Overview
Table 2017 Taiyo Kagaku L-Theanine Revenue (Million USD), Sales (K MT), Ex-factory Price (USD/MT)
Figure 2017 Taiyo Kagaku L-Theanine Business Region Distribution
Table Blue California Information List
Table Product Overview
Table 2017 Blue California L-Theanine Revenue (Million USD), Sales (K MT), Ex-factory Price (USD/MT)
Figure 2017 Blue California L-Theanine Business Region Distribution
Table Infre Information List
Table Product Overview
Table 2017 Infre L-Theanine Revenue (Million USD), Sales (K MT), Ex-factory Price (USD/MT)
Figure 2017 Infre L-Theanine Business Region Distribution
Table ZheJiang TianRui Chemical Information List
Table Product Overview
Table 2017 ZheJiang TianRui Chemical L-Theanine Revenue (Million USD), Sales (K MT), Ex-factory Price (USD/MT)
Figure 2017 ZheJiang TianRui Chemical L-Theanine Business Region Distribution
Table Qu Zhou Joy Chemical Information List
Table Product Overview
Table 2017 Qu Zhou Joy Chemical L-Theanine Revenue (Million USD), Sales (K MT), Ex-factory Price (USD/MT)
Figure 2017 Qu Zhou Joy Chemical L-Theanine Business Region Distribution
Table Sichuan Tongsheng Amino acid Information List
Table Product Overview
Table 2017 Sichuan Tongsheng Amino acid L-Theanine Revenue (Million USD), Sales (K MT), Ex-factory Price (USD/MT)
Figure 2017 Sichuan Tongsheng Amino acid L-Theanine Business Region Distribution
Table Hongya Yaxing Biotechnology Information List
Table Product Overview
Table 2017 Hongya Yaxing Biotechnology L-Theanine Revenue (Million USD), Sales (K MT), Ex-factory Price (USD/MT)
Figure 2017 Hongya Yaxing Biotechnology L-Theanine Business Region Distribution
Table FarmaSino Pharmaceuticals Information List
Table Product Overview
Table 2017 FarmaSino Pharmaceuticals L-Theanine Revenue (Million USD), Sales (K MT), Ex-factory Price (USD/MT)
Figure 2017 FarmaSino Pharmaceuticals L-Theanine Business Region Distribution
Table Hangzhou Qinyuan Natural Plant High-tech Information List
Table Product Overview
Table 2017 Hangzhou Qinyuan Natural Plant High-tech L-Theanine Revenue (Million USD), Sales (K MT), Ex-factory Price (USD/MT)
Figure 2017 Hangzhou Qinyuan Natural Plant High-tech L-Theanine Business Region Distribution
Table Wuxi Southern Yangtze University Biotech Information List
Table Product Overview
Table 2017 Wuxi Southern Yangtze University Biotech L-Theanine Revenue (Million USD), Sales (K MT), Ex-factory Price (USD/MT)
Figure 2017 Wuxi Southern Yangtze University Biotech L-Theanine Business Region Distribution
Figure Global 2018-2025 L-Theanine Market Size (K MT) and Growth Rate Forecast
Figure Global 2018-2025 L-Theanine Market Size (Million USD) and Growth Rate Forecast
Figure Global 2018-2025 L-Theanine Sales Price (USD/MT) Forecast
Figure North America 2018-2025 L-Theanine Consumption Volume (K MT) and Growth Rate Forecast
Figure China 2018-2025 L-Theanine Consumption Volume (K MT) and Growth Rate Forecast
Figure Europe 2018-2025 L-Theanine Consumption Volume (K MT) and Growth Rate Forecast
Figure Southeast Asia 2018-2025 L-Theanine Consumption Volume (K MT) and Growth Rate Forecast
Figure Japan 2018-2025 L-Theanine Consumption Volume (K MT) and Growth Rate Forecast
Figure India 2018-2025 L-Theanine Consumption Volume (K MT) and Growth Rate Forecast
Table Global Sales Volume (K MT) of L-Theanine by Type 2018-2025
Table Global Consumption Volume (K MT) of L-Theanine by Application 2018-2025
Table Traders or Distributors with Contact Information of L-Theanine by Region

SELECT A FORMAT

USD GBP EURO YEN Single User Price
USD GBP EURO YEN Enterprise Price

---- OR ----

Frequently Asked Questions ?

  • Upto 24 hrs - Working days
  • Upto 48 hrs max - Weekends and public holidays
  • Single User License
    A license granted to one user. Rules or conditions might be applied for e.g. the use of electric files (PDFs) or printings, depending on product.

  • Multi user License
    A license granted to multiple users.

  • Site License
    A license granted to a single business site/establishment.

  • Corporate License, Global License
    A license granted to all employees within organisation access to the product.
  • Online Payments with PayPal and CCavenue
  • Wire Transfer/Bank Transfer
  • Email
  • Hard Copy
check discount
  BENCHMARKS  
Loading Time: Base Classes  0.0098
Controller Execution Time ( Reports Controller / Report Details )  8.3221
Total Execution Time  8.3330
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,210,120 bytes
  POST DATA  
No POST data exists
  URI STRING  
chemicals-and-materials/2901789/global-ltheanine-2018-24
  CLASS/METHOD  
Reports_controller/report_details
  DATABASE:  chemical_common24 (Reports_controller:$db)   QUERIES: 12 (8.2898 seconds)  (Hide)
0.0001   SELECT GET_LOCK('6b4640bb74ede04b65f2a00fcce920d1'300) AS ci_session_lock 
0.0186   SELECT `data`
FROM `24mresearch_ci_sessions`
WHERE `id` = 'f921975e5330191a770dcbb7c95d021c6f2c00c3' 
0.0612   SELECT `24_report`.*, `24_sub_cat_1`.`sc1_name`, `24_sub_cat_1`.`sc1_url`, `24_sub_cat_1`.`sc1_status`, `24_publisher`.`publisher_name`, `24_report_metadata`.*
FROM `24_report`
LEFT JOIN `24_sub_cat_1ON `24_sub_cat_1`.`sc1_id` = `24_report`.`rep_sub_cat_1_id`
LEFT JOIN `24_publisherON `24_publisher`.`publisher_id` = `24_report`.`publisher_id`
LEFT JOIN `24_report_metadataON `24_report_metadata`.`meta_rep_id` = `24_report`.`rep_id`
WHERE `rep_status` = 'Y'
AND `rep_archive_status` = 'N'
AND `rep_date` > '2017-03-31'
AND `24_report`.`rep_id` = '2901789' 
0.0002   SELECT `sc1_id`, `sc1_url`, `sc1_name`
FROM `24_sub_cat_1`
WHERE `sc1_status` = 'Y'
ORDER BY `sc1_idAS
0.0001   SELECT *
FROM `24_report_license`
WHERE `li_rep_id` = '2901789'
AND `li_pub_id` = '1' 
8.2090   SELECT `24_report`.`rep_title`, `24_report`.`rep_id`, `24_report`.`rep_url`, `24_report`.`rep_date`, `24_sub_cat_1`.`sc1_url`, `24_sub_cat_1`.`sc1_name`
FROM `24_report`
LEFT JOIN `24_sub_cat_1ON `24_report`.`rep_sub_cat_1_id`=`24_sub_cat_1`.`sc1_id`
WHERE `rep_status` = 'Y'
AND `rep_archive_status` = 'N'
AND `rep_date` > '2017-03-31'
AND  `rep_titleLIKE '%ltheanine%' ESCAPE '!'
 
LIMIT 4 
0.0002   SELECT FROM 24_report_currency WHERE cur_symbol 'GBP' 
0.0001   SELECT FROM 24_report_currency WHERE cur_symbol 'EUR' 
0.0001   SELECT FROM 24_report_currency WHERE cur_symbol 'JPY' 
0.0001   SELECT FROM 24_report_currency WHERE cur_symbol 'GBP' 
0.0001   SELECT FROM 24_report_currency WHERE cur_symbol 'EUR' 
0.0001   SELECT FROM 24_report_currency WHERE cur_symbol 'JPY' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)