Advertisement
Rukes

Untitled

Sep 11th, 2021
992
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO `treti-cilova` (`id`, `pozic`, `profese`, `profese_kod`, `profese_nazev`, `spolecnost`, `spolecnost_ico`, `smennost`, `vzdelani`, `uvazek`, `mzda_min`, `mzda_max`, `datum_od`, `datum_do`, `zmena`, `poznamka`, `kontakt_jmeno`, `kontakt_prijmeni`, `kontakt_tel`, `kontakt_email`, `okres_kod`, `okres`, `pracoviste`, `prio`, `manual`)
  2. SELECT `z_jsonu`.`id`, `z_jsonu`.`pozic`, `z_jsonu`.`profese`, `z_jsonu`.`profese_kod`, `z_jsonu`.`profese_nazev`, `z_jsonu`.`spolecnost`, `z_jsonu`.`spolecnost_ico`, `z_jsonu`.`smennost`, `vzdelani`.`text`, `z_jsonu`.`uvazek`, `z_jsonu`.`mzda_min`, `z_jsonu`.`mzda_max`, `z_jsonu`.`datum_od`, `z_jsonu`.`datum_do`, `z_jsonu`.`zmena`, `z_jsonu`.`poznamka`, `z_jsonu`.`kontakt_jmeno`, `z_jsonu`.`kontakt_prijmeni`, `z_jsonu`.`kontakt_tel`, `z_jsonu`.`kontakt_email`, `z_jsonu`.`okres_kod`, `z_jsonu`.`okres`, `z_jsonu`.`pracoviste`, `z_jsonu`.`prio`, `z_jsonu`.`manual` FROM `z_jsonu`
  3. INNER JOIN `vzdelani` ON `z_jsonu`.`vzdelani` = `vzdelani`.`kod`
  4. LIMIT 100
Advertisement
RAW Paste Data Copied
Advertisement