Александр

$result = $db->query('SELECT p.id, p.name, c.name, p.price, p.code FROM product as p, category_id as c WHERE c.id = p.category_id');
...

$result = $db->query('SELECT p.id, p.name, c.name, p.price, p.code FROM product as p LEFT JOIN category as c ON p.category_id = c.id');
...

$productsList[$i]['p.category_id'] = $row['c.category_id'];

<Files *.* >
    ForceType application/octet-stream
    Header add Content-Disposition "attachment"
</Files>

type
  TfrmModal = class(TForm)
  private
    procedure WMSYSCOMMAND(var Msg: TWMSYSCOMMAND); message WM_SYSCOMMAND;
  end;

...

procedure TfrmModal.WMSYSCOMMAND(var Msg: TWMSYSCOMMAND);
begin
  case (Msg.CmdType and $FFF0) of
    SC_MINIMIZE:
    begin
      Msg.Result := 0;
      EnableWindow(Application.Handle, True);
      Application.Minimize;
    end;

    else inherited;
  end;
end;

private: // of TForm1 class
  void __fastcall WMSysCommand(TMessage &Msg); 

BEGIN_MESSAGE_MAP 
    MESSAGE_HANDLER(WM_SYSCOMMAND, TMessage, WMSysCommand) 
END_MESSAGE_MAP(TForm)

void __fastcall TForm1::WMSysCommand(TMessage &Msg)
{
    unsigned int const sys_code = Msg.WParam & 0xFFF0;
    switch (sys_code)
    {
        case SC_MINIMIZE:
        {
            Msg.Result = 0;
            EnableWindow(Application.Handle, True);
            Application.Minimize();
            return;
        }
    }
    TForm::Dispatch(&Msg);
}

SELECT * FROM `table` WHERE '2016-11-22' BETWEEN `date_in` AND `date_out`