Urbanjobs.nl

• CV plaatsen
• Login

• Home
• |
• CV plaatsen
• |
• Helpdesk
• |
• Sollicitatietips

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
                    Tekst
                WHERE
                    tekst_titel = "contact"
            

---

                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

---