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
			Videovacatures v
		WHERE
			video_deleted = 0
		LIMIT 3
		

---

SELECT * FROM Config WHERE config_name = "active_poll"

---

SELECT * FROM PollLog WHERE polllog_ip = "84.241.128.100" AND polllog_poll_id = "1"
					AND
					   DATEDIFF(NOW(), polllog_moment) <= 1 
					

---

SELECT 	*  FROM Poll WHERE poll_id = "1"

---

SELECT 	*  FROM PollField WHERE pollfield_poll_id = "1"

---

                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

---