1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
SELECT website_mime.id_mime, mime.mime_name, x509.x509_path, x509.x509_version, <a href="ftp://ftp.ftgp_simultaneousdownload/" target="_blank">ftp.ftgp_simultaneousdownload</a>, <a href="ftp://ftp.ftp_maxfilesize/" target="_blank">ftp.ftp_maxfilesize</a>,
<a href="ftp://ftp.ftp_minfilesize/" target="_blank">ftp.ftp_minfilesize</a>, proxy.proxy_bypasslocal, proxy.proxy_defaultcredential, proxy.proxy_username, proxy.proxy_password,
proxy.proxy_domain, proxy.proxy_name, credential.credential_password, credential.credential_username
FROM website_mime INNER JOIN
mime ON website_mime.id_mime = mime.id_mime INNER JOIN
website_x509 ON website_mime.id_website = website_x509.id_website INNER JOIN
x509 ON website_x509.id_x509 = x509.id_x509 INNER JOIN
website ON website_mime.id_website = website.id_website AND website_x509.id_website = website.id_website INNER JOIN
ftp ON website.id_ftp = <a href="ftp://ftp.id_ftp/" target="_blank">ftp.id_ftp</a> INNER JOIN
proxy ON website.id_proxy = proxy.id_proxy INNER JOIN
credential ON website.id_credential = credential.id_credential
WHERE website.id_website = 1 |
Partager