Sandbox

SELECT 
  SQL_CALC_FOUND_ROWS products.product_id, 
  descr1.product as product, 
  companies.company as company_name, 
  products.product_type, 
  products.parent_product_id, 
  descr1.full_description as full_description 
FROM 
  cscart_products as products 
  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id 
  AND descr1.lang_code = 'en' 
  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id 
  AND prices.lower_limit = 1 
  LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id 
  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id 
  INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A', 'H') 
  AND cscart_categories.storefront_id IN (0, 1) 
WHERE 
  1 
  AND cscart_categories.category_id IN (251) 
  AND companies.status IN ('A') 
  AND (
    products.usergroup_ids = '' 
    OR FIND_IN_SET(0, products.usergroup_ids) 
    OR FIND_IN_SET(1, products.usergroup_ids)
  ) 
  AND products.status IN ('A') 
  AND prices.usergroup_id IN (0, 0, 1) 
  AND products.parent_product_id = 0 
  AND products.company_id IN('1', '2', '3', '4', '5', '6') 
  AND products.product_type != 'D' 
GROUP BY 
  products.product_id 
ORDER BY 
  product asc, 
  products.product_id ASC 
LIMIT 
  0, 24

Query time 0.00191

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "5.25"
    },
    "ordering_operation": {
      "using_filesort": true,
      "grouping_operation": {
        "using_temporary_table": true,
        "using_filesort": false,
        "nested_loop": [
          {
            "table": {
              "table_name": "cscart_categories",
              "access_type": "const",
              "possible_keys": [
                "PRIMARY",
                "c_status",
                "p_category_id"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "category_id"
              ],
              "key_length": "3",
              "ref": [
                "const"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 1,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "0.00",
                "eval_cost": "0.20",
                "prefix_cost": "0.00",
                "data_read_per_join": "2K"
              },
              "used_columns": [
                "category_id",
                "storefront_id",
                "usergroup_ids",
                "status"
              ]
            }
          },
          {
            "table": {
              "table_name": "products_categories",
              "access_type": "ref",
              "possible_keys": [
                "PRIMARY",
                "pt"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "category_id"
              ],
              "key_length": "3",
              "ref": [
                "const"
              ],
              "rows_examined_per_scan": 2,
              "rows_produced_per_join": 2,
              "filtered": "100.00",
              "using_index": true,
              "cost_info": {
                "read_cost": "1.02",
                "eval_cost": "0.40",
                "prefix_cost": "1.42",
                "data_read_per_join": "32"
              },
              "used_columns": [
                "product_id",
                "category_id"
              ]
            }
          },
          {
            "table": {
              "table_name": "products",
              "access_type": "eq_ref",
              "possible_keys": [
                "PRIMARY",
                "status",
                "idx_parent_product_id"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "product_id"
              ],
              "key_length": "3",
              "ref": [
                "atulecarter_atul_demo1.products_categories.product_id"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 0,
              "filtered": "42.58",
              "cost_info": {
                "read_cost": "2.00",
                "eval_cost": "0.17",
                "prefix_cost": "3.82",
                "data_read_per_join": "4K"
              },
              "used_columns": [
                "product_id",
                "product_type",
                "status",
                "company_id",
                "usergroup_ids",
                "parent_product_id"
              ],
              "attached_condition": "((`atulecarter_atul_demo1`.`products`.`parent_product_id` = 0) and ((`atulecarter_atul_demo1`.`products`.`usergroup_ids` = '') or find_in_set(0,`atulecarter_atul_demo1`.`products`.`usergroup_ids`) or find_in_set(1,`atulecarter_atul_demo1`.`products`.`usergroup_ids`)) and (`atulecarter_atul_demo1`.`products`.`status` = 'A') and (`atulecarter_atul_demo1`.`products`.`company_id` in ('1','2','3','4','5','6')) and (`atulecarter_atul_demo1`.`products`.`product_type` <> 'D'))"
            }
          },
          {
            "table": {
              "table_name": "companies",
              "access_type": "eq_ref",
              "possible_keys": [
                "PRIMARY"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "company_id"
              ],
              "key_length": "4",
              "ref": [
                "atulecarter_atul_demo1.products.company_id"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 0,
              "filtered": "16.67",
              "cost_info": {
                "read_cost": "0.85",
                "eval_cost": "0.03",
                "prefix_cost": "4.85",
                "data_read_per_join": "1021"
              },
              "used_columns": [
                "company_id",
                "status",
                "company"
              ],
              "attached_condition": "(`atulecarter_atul_demo1`.`companies`.`status` = 'A')"
            }
          },
          {
            "table": {
              "table_name": "descr1",
              "access_type": "eq_ref",
              "possible_keys": [
                "PRIMARY",
                "product_id"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "product_id",
                "lang_code"
              ],
              "key_length": "9",
              "ref": [
                "atulecarter_atul_demo1.products_categories.product_id",
                "const"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 0,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "0.14",
                "eval_cost": "0.03",
                "prefix_cost": "5.02",
                "data_read_per_join": "663"
              },
              "used_columns": [
                "product_id",
                "lang_code",
                "product",
                "full_description"
              ]
            }
          },
          {
            "table": {
              "table_name": "prices",
              "access_type": "ref",
              "possible_keys": [
                "usergroup",
                "product_id",
                "lower_limit",
                "usergroup_id"
              ],
              "key": "usergroup",
              "used_key_parts": [
                "product_id"
              ],
              "key_length": "3",
              "ref": [
                "atulecarter_atul_demo1.products_categories.product_id"
              ],
              "rows_examined_per_scan": 3,
              "rows_produced_per_join": 0,
              "filtered": "97.36",
              "using_index": true,
              "cost_info": {
                "read_cost": "0.15",
                "eval_cost": "0.08",
                "prefix_cost": "5.25",
                "data_read_per_join": "9"
              },
              "used_columns": [
                "product_id",
                "lower_limit",
                "usergroup_id"
              ],
              "attached_condition": "((`atulecarter_atul_demo1`.`prices`.`lower_limit` = 1) and (`atulecarter_atul_demo1`.`prices`.`usergroup_id` in (0,0,1)))"
            }
          }
        ]
      }
    }
  }
}

Result

product_id	product	company_name	product_type	full_description
130	Casio DR-210TM	CS-Cart	P	<table class="defTBL" style="word-wrap: break-word; color: #555555; font-family: Helvetica, sans-serif; font-size: 12px; line-height: 18px; text-align: left; background-color: #ffffff;" width="79%"> <thead style="word-wrap: break-word;"> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">DR-210TM Technical Specifications</strong></div> </th> </tr> </thead> <tbody style="word-wrap: break-word;"> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Display</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Digits</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">12</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Type</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">Digitron</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Special</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">Large Display</div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Printer</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Speed - lines/second</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">4.4</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Print Color</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">2 Color-Black/Red</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Type</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">Ribbon</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Ink Ribbon</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">RB-02</div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Features</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Decimal Selector</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">Floating or fixed decimal 0,1,2,3,4,6</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Item Counter</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Independent Memory</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Printing Reference Numbers</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Tax Calculation</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Automatic Constants</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Independent Add Register</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Grand Total</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">MU/MD</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Feed</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Right Shift Key</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Round Off</td> <td style="word-wrap: break-word;"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Round Up</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Cut Off</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">ADD Mode</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Cost/Sell/Margin</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Paper</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">2-1/4 inch plain</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/catalog/calculator/black_bullet.gif" border="0" alt="" /></div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Power</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Type</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">AC</div> </td> </tr> <tr style="word-wrap: break-word;"> <th style="word-wrap: break-word;" colspan="2"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;"><strong style="word-wrap: break-word;">Unit Dimensions</strong></div> </th> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Size (inches)  H x W x L</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">4-3/10" x 8-2/5" x 15"</div> </td> </tr> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;" width="61%">Weight oz/lbs</td> <td style="word-wrap: break-word;" width="39%"> <div style="word-wrap: break-word; padding: 0px; margin: 0px;">3.7 lbs</div> </td> </tr> </tbody> </table> <p> <p style="word-wrap: break-word; margin-top: 10px; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; line-height: 1.25em; color: #555555; font-family: Helvetica, sans-serif; font-size: 12px; text-align: left; background-color: #ffffff;">Technical Specifications Subject to Change</p> </p>
128	Casio FX-115ES	CS-Cart	P	<table class="defTBL" style="word-wrap: break-word; color: #555555; font-family: Helvetica, sans-serif; font-size: 12px; line-height: 18px; text-align: left; background-color: #ffffff;" border="0" width="95%"> <tbody style="word-wrap: break-word;"> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Number of Functions</strong></td> <td style="word-wrap: break-word;">279</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Display</strong></td> <td style="word-wrap: break-word;"> </td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">2-Line Digit</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Natural Textbook</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Digits</td> <td style="word-wrap: break-word;">10 + 2</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Memory</strong></td> <td style="word-wrap: break-word;"> </td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Store/Recall</td> <td style="word-wrap: break-word;">Yes/Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Recall & Edit values</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Number of independent memories</td> <td style="word-wrap: break-word;">1</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Number of constant memories</td> <td style="word-wrap: break-word;">6</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Features</strong></td> <td style="word-wrap: break-word;"> </td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Operating system</td> <td style="word-wrap: break-word;">S - V.P.A.M</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Protective hard case</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Clear last entry and clear all</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Review & edit preview entries</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Overhead Model Available</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Fixed decemial capabilities</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Multi-replay</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Plastic Keys</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Mathematics</strong></td> <td style="word-wrap: break-word;"> </td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Metric conversions</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Scientific notation</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Parenthesis/Constant</td> <td style="word-wrap: break-word;">Yes/-</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Pi</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Xth root</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Fraction calculations</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Complex numbers</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">DMS <> DD / P <> R Conversions</td> <td style="word-wrap: break-word;">Yes/Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Trigonometry</strong></td> <td style="word-wrap: break-word;"> </td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Sin, Cos, Tan, & Inverses</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Hyperbolic Functions</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Converts between DEG, RAD, GRAD</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Statistics</strong></td> <td style="word-wrap: break-word;"> </td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">One/two variable</td> <td style="word-wrap: break-word;">Yes/Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Mean, sum, # elements</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Standard Deviation</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Linear Regression</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Log, In, Inverse Log, Exponential</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Store and edit data in memory</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Quadratic, log, exp, power, inverse regression</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">nPr, cPr, x!</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Random number generator</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Calculus</strong></td> <td style="word-wrap: break-word;"> </td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Complex number calculations</td> <td style="word-wrap: break-word;">No</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Numeric integration</td> <td style="word-wrap: break-word;">No</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Numeric differential calculations</td> <td style="word-wrap: break-word;">No</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;">Power/Unit Dimensions</strong></td> <td style="word-wrap: break-word;"> </td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Power</td> <td style="word-wrap: break-word;">Solar Plus w/Battery back-up</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Auto Power Off</td> <td style="word-wrap: break-word;">Yes</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Battery</td> <td style="word-wrap: break-word;">-</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Size (H x W x L) Inches</td> <td style="word-wrap: break-word;">Not available</td> </tr> <tr class="contentTextGray" style="word-wrap: break-word;"> <td style="word-wrap: break-word;">Weight (ounces)</td> <td style="word-wrap: break-word;">Not available</td> </tr> </tbody> </table> <p> </p> <p class="contentTextGray" style="word-wrap: break-word; margin-top: 10px; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; line-height: 1.25em; color: #555555; font-family: Helvetica, sans-serif; font-size: 12px; text-align: left; background-color: #ffffff;">Technical Specifications subject to change</p> <p class="contentTextGray" style="word-wrap: break-word; margin-top: 10px; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; padding-top: 0px; padding-bottom: 0px; line-height: 1.25em; color: #555555; font-family: Helvetica, sans-serif; font-size: 12px; text-align: left; background-color: #ffffff;">The FX-115ES is permitted on AP, SAT and PSAT/NMSQT. Policies are subject to change. Visit<a style="word-wrap: break-word; color: #00349a; text-decoration: underline;" href="http://www.collegeboard.com/" target="_blank">www.collegeboard.com</a>for more information.</p> <p> </p>
126	Casio PRIZM fx-CG10	CS-Cart	P	<p><br /><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/pressreleases/fx-CG10_Prizm_press_2.jpg" alt="PRIZM fx-CG10" align="right" /><strong style="word-wrap: break-word;">High-resolution color LCD with full textbook-style display</strong><br style="word-wrap: break-word;" /><br style="word-wrap: break-word;" />The color LCD offers full textbook-style display with the highest pixel resolution* (82,944 dots) and widest color reproduction* (65,536 colors) of any calculator. PRIZM™ comes with high-resolution fonts up to 18x24 dots (including blank dots), to enable equations and text to be displayed just like they appear in textbooks. The Blanview LCD delivers superior visibility and low power consumption, enabling color display with an estimated run time of 140 hours on four AAA-size alkaline batteries.*<strong style="word-wrap: break-word;"><br style="word-wrap: break-word;" /></strong>As of October 7, 2010, for the pixel resolution and color reproduction of calculators. According to a survey by Casio Computer Co., Ltd.<br style="word-wrap: break-word;" />**Using repetition of the following one-hour sequence: Menu display for 5 minutes, Run-Matrix mode calculation for 5 minutes, flashing cursor in Run-Matrix mode for 50 minutes. Based on default settings for display brightness and auto power off. (Refer to the Specifications for exact settings)  <strong style="word-wrap: break-word;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/pressreleases/fx-CG10_Prizm_press_3.jpg" alt="PRIZM fx-CG10" align="right" /></strong><strong style="word-wrap: break-word;">Picture Plot enables learning from real-life pictures</strong><strong style="word-wrap: break-word;"> </strong><br style="word-wrap: break-word;" /><br style="word-wrap: break-word;" />Picture Plot enables users to create their own graphs over pictures displayed on the color LCD. PRIZM™ comes with 55 types of color pictures that users can create graphs over, such as a picture of the parabola of jets from a water fountain and an image sequence of a clock’s pendulum movement. Users can perform regression calculations from the completed graphs to enhance their understanding of math functions.   <strong style="word-wrap: break-word;">Multitude of functions that leverage the color LCD</strong><br style="word-wrap: break-word;" /><br style="word-wrap: break-word;" />Colors can be added to a multitude of graphing objects including dotted lines, circles, and bars, as well as grid lines on graphs, labels of coordinate axes, and coordinate values displayed during tracing. The Color Link function links the colors used in graphs to the designated values in the spreadsheet screen, to aid the visual comprehension of trends and changes in values. PRIZM™ automatically color-codes brackets when entering equations with multiple brackets, as a visual aid to facilitate the entry of complex equations. </p> <table style="word-wrap: break-word;" align="center"> <tbody style="word-wrap: break-word;"> <tr style="word-wrap: break-word;"> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/pressreleases/fx-CG10_Prizm_press_3.jpg" alt="PRIZM fx-CG10" align="left" /></strong></td> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/pressreleases/fx-CG10_Prizm_press_4.jpg" alt="PRIZM fx-CG10" align="left" /></strong></td> <td style="word-wrap: break-word;"><strong style="word-wrap: break-word;"><img style="word-wrap: break-word; border-style: initial; border-color: initial;" src="http://www.casio.com/resource/images/pressreleases/fx-CG10_Prizm_press_5.jpg" alt="PRIZM fx-CG10" align="left" /></strong></td> </tr> </tbody> </table>