title: How to solve MySQL showing non-existing data?
body: <p>I am using MySQL query to show me the files that have been uploaded and are of type V.</p>
  <p>The files's information is stored in the vector_data table.</p>
  <p>Currently it contains only 1 row.</p>
  <p>Nevertheless, it is showing 3 files as a result.</p>
  <p>Please see the query and tables below.</p>
  <p>The data does not need to be ordered.</p>
  <p>It should show all the files uploaded by the user specified in the query.</p>
  <p>query</p>
  <pre><code>select v.*
       , j.Name ProjectName
       , t.Name as TypeName 
    from vector_data v
       , project j
       , product_type t
   where v.Type = t.ID 
     and t.Type = 'V' 
     and v.Status =  'Finished' 
     and v.Uploader = 'user@gmail.com' 
   order 
      by ProjectName
       , v.FileName
  </code></pre>
  <p>Current output</p>
  <pre><code>| ID |                  Type                  |  EPSG | FileName | Date |  Size |  ChunkCount |  Status  |  UploadFolder |  DownloadPath |  Identifier |
  |----|----------------------------------------|-------|---------------|--------------|--------------|------------|-------------|----------|----------|--------------|
  | 40 | 8 | 4326 | plot_boundary_1.geojson | 06/27/2016 | 74137 | 1 | Finished | &quot;&quot; | /var/www/html/uas_data/uploads/products/2016_Corpus_Christi_Cotton_and_Sorghum///04/12/2016//GeoJSON/plot_boundary_1 | https://test/products/2016_Corpus_Christi_Cotton_and_Sorghum///04/12/2016//GeoJSON/plot_boundary_1/plot_boundary_1.geojson | 74137-plot_boundary1geojson | 100 | 2021-03-22 18:48:44 | user@gmail.com | 2016 Corpus Christi Cotton and Sorghum | GeoJSON |
  | 40 | 8 | 4326 | plot_boundary_1.geojson | 06/27/2016 | 74137 | 1 | Finished | &quot;&quot; | /var/www/html/uas_data/uploads/products/2016_Corpus_Christi_Cotton_and_Sorghum///04/12/2016//GeoJSON/plot_boundary_1 | https://test/products/2016_Corpus_Christi_Cotton_and_Sorghum///04/12/2016//GeoJSON/plot_boundary_1/plot_boundary_1.geojson | 74137-plot_boundary1geojson | 100 | 2021-03-22 18:48:44 | user@gmail.com | 2016 Weslaco Tomato                    | GeoJSON |
  | 40 | 8 | 4326 | plot_boundary_1.geojson | 06/27/2016 | 74137 | 1 | Finished | &quot;&quot; | /var/www/html/uas_data/uploads/products/2016_Corpus_Christi_Cotton_and_Sorghum///04/12/2016//GeoJSON/plot_boundary_1 | https://test/products/2016_Corpus_Christi_Cotton_and_Sorghum///04/12/2016//GeoJSON/plot_boundary_1/plot_boundary_1.geojson | 74137-plot_boundary1geojson | 100 | 2021-03-22 18:48:44 | user@gmail.com | 2019 Amarillo Wheat - Irrigation Land  | GeoJSON |
  </code></pre>
  <p>project</p>
  <pre><code>| ID |                  Name                  |  Crop |  PlantingDate |  HarvestDate |  Description |  CenterLat |  CenterLng  |  MinZoom |  MaxZoom |  DefaultZoom |
  |----|----------------------------------------|-------|---------------|--------------|--------------|------------|-------------|----------|----------|--------------|
  |  1 | 2016 Corpus Christi Cotton and Sorghum |    43 | 04-01-2016    | &quot;&quot;           | &quot;&quot;           |  42.782301 |  -95.560600 |       17 |       25 |           19 |
  |  2 | 2019 Amarillo Wheat - Irrigation Land  |    40 | 11-08-2018    | &quot;&quot;           | &quot;&quot;           |  71.190498 | -122.084000 |       17 |       25 |           19 |
  |  3 | 2016 Weslaco Tomato                    |    44 | 01-01-2016    | &quot;&quot;           | &quot;&quot;           |  26.157201 |  -57.163600 |       17 |       25 |           19 |
  </code></pre>
  <p>product_type</p>
  <pre><code>| ID |          Name         |  Type |
  |----|-----------------------|-------|
  |  1 | RGB Ortho             | R     |
  |  2 | RGB DEM               | R     |
  |  3 | MULTI Ortho           | R     |
  |  4 | NDVI                  | R     |
  |  5 | ExG                   | R     |
  |  6 | Thermal Ortho         | R     |
  |  7 | Canopy Cover Rendered | R     |
  |  8 | GeoJSON               | V     |
  </code></pre>
  <p>vector_data</p>
  <pre><code>| ID |  Type |  EPSG |         FileName        |    Date    |  Size |  ChunkCount |  Status  |  TempFolder |                                                     UploadFolder                                                     |                                                            DownloadPath                                                            |          Identifier         |  Progress |      LastUpdate     |    Uploader    |
  |----|-------|-------|-------------------------|------------|-------|-------------|----------|-------------|----------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------|-----------------------------|-----------|---------------------|----------------|
  | 40 |     8 |  4326 | plot_boundary_1.geojson | 06/27/2016 | 74137 |           1 | Finished | &quot;&quot;          | /var/www/html/uas_data/uploads/products/2016_Corpus_Christi_Cotton_and_Sorghum///04/12/2016//GeoJSON/plot_boundary_1 | https://test/uploads/products/2016_Corpus_Christi_Cotton_and_Sorghum///04/12/2016//GeoJSON/plot_boundary_1/plot_boundary_1.geojson | 74137-plot_boundary1geojson |       100 | 2021-03-22 18:48:44 | user@gmail.com |
  </code></pre>