SELECT * FROM VijeGeografisch.Provincie ORDER BY p_naam ASC
SELECT
*
FROM
CV
WHERE
cv_account_id = 0
AND
cv_deleted = 0
SELECT
*
FROM
Tekst
SELECT
*
FROM
Credit
LEFT JOIN
Vacature
ON
vacature_id = credit_vacature_id
LEFT JOIN
Bedrijf
ON
bedrijf_id = vacature_bedrijf_id
WHERE
1
AND
credit_verlengd = 0 AND
credit_deleted = 0 AND
credit_geactiveerd = 1 AND
credit_isbetaald = 1 AND
credit_verloopdatum IS NOT NULL AND
credit_verloopdatum >= DATE(NOW())
AND credit_geblokkeerd != 1 AND credit_type = "topbaan" AND vacature_aangemaakt = 1 AND vacature_deleted = 0
ORDER BY
credit_id DESC
LIMIT 20
