SQLITE3

sqlite.md

sqlite db/development.sqlite

.databases
.tables

.schema
.schema table_name

.header on
.header off

.mode line
.mode list
.mode column

.width 12 6

      SELECT
        "products"."id",
        "products"."product_params_set_type",

        "product_params0_sets"."size_x",
        "product_params0_sets"."size_y",
        "product_params0_sets"."size_z",

        "product_params1_sets"."processor_type"

      FROM
        "products"

      LEFT OUTER JOIN
        "product_params0_sets"
        ON
          "products"."product_params_set_type" = "ProductParams0Set"
          AND
          "products"."product_params_set_id" = "product_params0_sets"."id"

      LEFT OUTER JOIN
        "product_params1_sets"
        ON
          "products"."product_params_set_type" = "ProductParams1Set"
          AND
          "products"."product_params_set_id" = "product_params1_sets"."id"

      WHERE
        "product_params1_sets"."processor_type" = 'A7'
        OR
        "product_params0_sets"."size_x" = '1'
      ;

.read FILE_WITH_SQL;