API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 4th, 2016
124
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 54.57 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3011', '6');
  2. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3011', '9');
  3. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3012', '1');
  4. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3012', '5');
  5. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3012', '2');
  6. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3013', '9');
  7. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3013', '10');
  8. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3014', '5');
  9. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3015', '1');
  10. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3014', '2');
  11. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3015', '6');
  12. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3016', '7');
  13. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3014', '8');
  14. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3015', '7');
  15. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3016', '8');
  16. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3016', '9');
  17. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3018', '5');
  18. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3018', '2');
  19. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3019', '9');
  20. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3019', '4');
  21. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_aftesiprofesionale` (`Shfrytezuesi`, `Aftesia_Profesionale`) VALUES ('3020', '7');
  22.  
  23. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3011', '1');
  24. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3011', '2');
  25. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3012', '1');
  26. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3012', '2');
  27. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3013', '1');
  28. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3013', '2');
  29. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3013', '3');
  30. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3013', '11');
  31. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3014', '1');
  32. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3014', '2');
  33. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3014', '3');
  34. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3014', '11');
  35. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3015', '1');
  36. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3015', '2');
  37. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3015', '3');
  38. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3015', '8');
  39. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3016', '1');
  40. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3016', '2');
  41. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3016', '3');
  42. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3016', '8');
  43. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3017', '1');
  44. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3017', '2');
  45. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3017', '14');
  46. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3018', '1');
  47. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3018', '2');
  48. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3018', '3');
  49. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3018', '14');
  50. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3019', '5');
  51. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3019', '1');
  52. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3019', '2');
  53. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3019', '3');
  54. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3019', '11');
  55. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3020', '11');
  56. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3020', '1');
  57. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3020', '2');
  58. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3020', '3');
  59. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3014', '4');
  60. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3015', '6');
  61. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3017', '7');
  62. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3018', '6');
  63. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_gjuhe` (`Shfrytezuesi`, `Gjuha`) VALUES ('3020', '7');
  64.  
  65.  
  66. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `I_Diplomuar`) VALUES ('200', '3011', '1', '1', '1', '2014-09-01', '0');
  67. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `I_Diplomuar`) VALUES ('201', '3012', '1', '1', '32', '2014-09-01', '0');
  68. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('202', '3013', '14', '3', '2', '1984-07-28', '1990-06-22', '1');
  69. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('203', '3013', '4', '2', '2', '1980-08-22', '1984-06-15', '1');
  70. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('204', '3013', '1', '1', '2', '1977-08-22', '1980-06-14', '1');
  71. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('205', '3014', '1', '1', '3', '1981-08-25', '1984-09-15', '1');
  72. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('206', '3014', '4', '2', '3', '1985-09-10', '1987-06-12', '1');
  73. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('207', '3014', '11', '3', '3', '1987-09-01', '1995-06-13', '1');
  74. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('208', '3015', '1', '1', '5', '1993-09-01', '1999-06-01', '1');
  75. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('209', '3015', '4', '2', '5', '2000-09-01', '2004-06-11', '1');
  76. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `I_Diplomuar`) VALUES ('208', '3015', '15', '3', '5', '2012-09-01', '0');
  77. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('209', '3016', '1', '1', '4', '1995-08-22', '1998-06-23', '1');
  78. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('210', '3016', '13', '2', '4', '1999-09-10', '2002-06-11', '1');
  79. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('211', '3017', '5', '1', '1', '2005-09-10', '2008-06-01', '1');
  80. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('212', '3017', '4', '2', '1', '2008-09-10', '2010-06-10', '1');
  81. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `I_Diplomuar`) VALUES ('213', '3017', '16', '3', '1', '2013-10-01', '0');
  82. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('214', '3018', '4', '1', '6', '2001-10-10', '2004-06-10', '1');
  83. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('215', '3018', '12', '2', '6', '2005-10-12', '2007-06-20', '1');
  84. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('216', '3018', '15', '3', '6', '2007-09-20', '2015-06-10', '1');
  85. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('217', '3019', '9', '1', '15', '1987-09-15', '1990-06-14', '1');
  86. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('218', '3019', '12', '2', '15', '1990-09-10', '1993-06-14', '1');
  87. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('219', '3019', '14', '3', '15', '1995-10-10', '2001-01-10', '1');
  88. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('220', '3020', '10', '1', '16', '1980-10-15', '1983-06-15', '1');
  89. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('221', '3020', '12', '2', '16', '1984-10-10', '1986-06-10', '1');
  90. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_edukimi_larte` (`ShEdulID`, `Shfrytezuesi`, `Institucioni`, `Niveli_i_Edukimit`, `Fusha_e_Studimit`, `Viti_Fillimit`, `Viti_Mbarimit`, `I_Diplomuar`) VALUES ('222', '3020', '16', '3', '16', '1987-09-01', '1995-06-01', '1');
  91.  
  92.  
  93. INSERT INTO kerkesat (`KerkesaID`, `Drejtuesi`, `Pranuesi`, `Koha_Kerkese`, `Pergjigja_ndaj_kerkeses`, `Koha_Pergjigjes`)
  94. VALUES
  95. ('200', '3011', '3012',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  96. ('201', '3011', '3013',DATE_SUB(NOW(), INTERVAL 40 DAY), '1',DATE_SUB(NOW(), INTERVAL 28 DAY)),
  97. ('202', '3011', '3014',DATE_SUB(NOW(), INTERVAL 42 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  98. ('203', '3011', '3015',DATE_SUB(NOW(), INTERVAL 32 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  99. ('204', '3011', '3016',DATE_SUB(NOW(), INTERVAL 31 DAY), '1',DATE_SUB(NOW(), INTERVAL 27 DAY)),
  100. ('205', '3011', '3017',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  101. ('206', '3011', '3018',DATE_SUB(NOW(), INTERVAL 34 DAY), '1',DATE_SUB(NOW(), INTERVAL 20 DAY)),
  102. ('207', '3011', '3019',DATE_SUB(NOW(), INTERVAL 35 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  103. ('208', '3011', '3020',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  104. ('209', '3012', '3013',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 20 DAY)),
  105. ('210', '3012', '3014',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  106. ('211', '3012', '3015',DATE_SUB(NOW(), INTERVAL 37 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  107. ('212', '3012', '3016',DATE_SUB(NOW(), INTERVAL 44 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  108. ('213', '3012', '3017',DATE_SUB(NOW(), INTERVAL 39 DAY), '1',DATE_SUB(NOW(), INTERVAL 13 DAY)),
  109. ('214', '3012', '3018',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  110. ('215', '3012', '3019',DATE_SUB(NOW(), INTERVAL 38 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  111. ('216', '3012', '3020',DATE_SUB(NOW(), INTERVAL 37 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  112. ('217', '3013', '3014',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  113. ('218', '3013', '3015',DATE_SUB(NOW(), INTERVAL 55 DAY), '1',DATE_SUB(NOW(), INTERVAL 29 DAY)),
  114. ('219', '3013', '3016',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  115. ('220', '3013', '3017',DATE_SUB(NOW(), INTERVAL 43 DAY), '1',DATE_SUB(NOW(), INTERVAL 14 DAY)),
  116. ('221', '3013', '3018',DATE_SUB(NOW(), INTERVAL 38 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  117. ('222', '3013', '3019',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  118. ('223', '3013', '3020',DATE_SUB(NOW(), INTERVAL 39 DAY), '1',DATE_SUB(NOW(), INTERVAL 15 DAY)),
  119. ('224', '3014', '3015',DATE_SUB(NOW(), INTERVAL 36 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  120. ('225', '3014', '3016',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  121. ('226', '3014', '3017',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 17 DAY)),
  122. ('227', '3014', '3018',DATE_SUB(NOW(), INTERVAL 37 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  123. ('228', '3014', '3019',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  124. ('229', '3014', '3020',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 18 DAY)),
  125. ('230', '3015', '3016',DATE_SUB(NOW(), INTERVAL 36 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  126. ('231', '3015', '3017',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  127. ('232', '3015', '3018',DATE_SUB(NOW(), INTERVAL 45 DAY), '1',DATE_SUB(NOW(), INTERVAL 28 DAY)),
  128. ('233', '3015', '3019',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  129. ('234', '3015', '3020',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 23 DAY)),
  130. ('235', '3016', '3017',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  131. ('236', '3016', '3018',DATE_SUB(NOW(), INTERVAL 42 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  132. ('237', '3016', '3019',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 24 DAY)),
  133. ('238', '3016', '3020',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  134. ('239', '3017', '3018',DATE_SUB(NOW(), INTERVAL 38 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  135. ('240', '3017', '3019',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 27 DAY)),
  136. ('241', '3017', '3020',DATE_SUB(NOW(), INTERVAL 45 DAY), '1',DATE_SUB(NOW(), INTERVAL 10 DAY)),
  137. ('242', '3018', '3019',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY)),
  138. ('243', '3018', '3020',DATE_SUB(NOW(), INTERVAL 40 DAY), '1',DATE_SUB(NOW(), INTERVAL 19 DAY)),
  139. ('244', '3019', '3020',DATE_SUB(NOW(), INTERVAL 30 DAY), '1',DATE_SUB(NOW(), INTERVAL 25 DAY));
  140.  
  141. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('57', 'Children’s rights');
  142. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('32', 'Civil liberties, freedom of religion');
  143. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('33', 'Courts/judicial administration');
  144. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('34', 'Agriculture, sustainable programs');
  145. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('35', 'Microeconomics ');
  146. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('36', 'International Finance');
  147.  
  148. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('37', 'Pharmacology');
  149. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('38', 'Diabetes');
  150. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('39', 'Nursing care');
  151. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('40', 'Hospitals (general)');
  152. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('41', 'Hospitals (specialty)');
  153. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('42', 'Biomedicine');
  154. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('43', 'Health care, patient services');
  155. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('44', 'Pharmacy/prescriptions');
  156. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('45', 'Public health, obesity');
  157.  
  158. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('46', 'Education, computer/literacy/technology training');
  159. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('47', 'International studies');
  160. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('48', 'Geotechnical');
  161. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('49', 'Infrastructure');
  162. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('50', 'National Defense');
  163. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('51', 'Energy Efficiency');
  164. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('52', 'Sensor Networks');
  165. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('53', 'GIScience and Geoinformatics');
  166. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('54', 'Robotics and Mechatronics');
  167. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('55', 'Simulation');
  168. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`interesimet_ne_profesion` (`InteresimiID`, `Interesimi_ne_profesion`) VALUES ('56', 'Nanotechnology and Nanomaterials');
  169.  
  170.  
  171. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3011', '17');
  172. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3011', '18');
  173. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3011', '19');
  174. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3011', '20');
  175. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3011', '23');
  176. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3013', '52');
  177. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3013', '56');
  178. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3013', '27');
  179. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3013', '28');
  180. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3014', '24');
  181. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3014', '26');
  182. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3014', '55');
  183. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3015', '48');
  184. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3015', '49');
  185. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3015', '6');
  186. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3015', '53');
  187. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3016', '51');
  188. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3016', '47');
  189. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3016', '9');
  190. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3016', '6');
  191. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3017', '17');
  192. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3017', '18');
  193. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3017', '20');
  194. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3017', '22');
  195. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3017', '21');
  196. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3018', '47');
  197. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3018', '11');
  198. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3018', '6');
  199. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3018', '49');
  200. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3019', '52');
  201. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3019', '53');
  202. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3019', '54');
  203. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3019', '55');
  204. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3020', '52');
  205. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3020', '54');
  206. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3020', '53');
  207. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3020', '55');
  208. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_interesim` (`Shfrytezuesi`, `Interesimi_ne_profesion`) VALUES ('3020', '6');
  209.  
  210.  
  211. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`publikimet` (`PubID`, `Publikuesi`, `Titulli`, `Autori_i_pare`, `Vendi_Publikimit`, `Data_Publikimit`, `Linku_Publikimit`, `Abstrakti`, `Permbajtja`, `Dukshmeria`, `Mediumi`) VALUES ('1010', '3014', 'Light Emitting Diodes and the Lighting Revolution:The Emergence of a Solid-State Lighting Industry', '3014', '14', '2016-11-25 14:30:00', 'link.10', 'Emergence of new industries from evolving technologies is critical to the global
  212. economy, yet has been relatively understudied due to the paucity of available data. This study
  213. draws lessons on industry emergence, by analyzing how a solid-state lighting (SSL) industry
  214. grew out of light emitting diode (LED) technologies that evolved for half a century, with
  215. participation by tens of thousands of researchers in universities, national laboratories, and firms.
  216. Using data on publications, patents, and firms combined with business history we trace the
  217. evolution of SSL through a succession of market niches. At times a few researchers with
  218. unorthodox research approaches made breakthroughs that greatly advanced particular technology
  219. trajectories and pushed LED research in unexpected directions. A succession of LED market
  220. niches advanced the technology and provided profits to incentivize continuing research.
  221. Innovating firms developed a thicket of patents and captured substantial profit, but were
  222. embroiled in extensive litigation that was ultimately resolved through cross-licensing. A major
  223. new generation of lighting products is now disrupting the traditional lighting industry. Although
  224. the leading incumbent lighting firms all invested early and heavily in SSL, the industry’s future
  225. leadership is uncertain', 'The light emitting diode (LED), first commercialized in the 1960s, is now poised to
  226. replace most light bulbs with a high-tech alternative known as solid-state lighting (SSL). If SSL
  227. achieves even a little of its expected potential, it will save energy and money compared to
  228. existing light bulbs (incandescent and fluorescent), spur radical approaches to lighting design
  229. and products, and integrate with electronic circuitry to facilitate surprising applications. By
  230. 2013, SSL replacement bulbs are common in stores and have reached a cost low enough to be
  231. attractive to many consumers. Firms with SSL products have been flooding the lighting
  232. industry: light emitting diode producers like Cree making solid-state replacement lights;
  233. entrepreneurial startups like Soraa and BridgeLux creating new solid-state lighting devices; and
  234. firms like Samsung and Sharp with experience in related technologies, now competing directly
  235. with incumbent light bulb makers Philips, Osram-Sylvania, and GE in the newly emerged solidstate
  236. lighting industry.
  237. This study draws lessons from the co-evolution of basic science, industrial technology,
  238. and niche applications that are stepping-stones to a mass market application. Development of
  239. today’s SSL products required a maze of technology evolution, with false starts and unexpected
  240. turns. The many thousands of researchers and organizations who developed these technologies
  241. experimented with poorly understood materials, pioneered manufacturing methods, and
  242. redesigned complementary technologies such as encapsulants, phosphors, driver electronics, heat
  243. sinks, and fixtures to create light-emitting properties they needed. As these players interacted
  244. and competed, they created new uses and markets for their technologies, from the initial red
  245. indicator lights to calculator and watch displays, signs, flashlights, brake lights, traffic lights,
  246. architectural lights, and backlights for mobile devices and televisions. Myriad characteristics
  247. and colors that were developed along the way combine to make today’s efficient white light. ', '1', '11');
  248.  
  249.  
  250. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`publikimet` (`PubID`, `Publikuesi`, `Titulli`, `Autori_i_pare`, `Vendi_Publikimit`, `Data_Publikimit`, `Linku_Publikimit`, `Abstrakti`, `Permbajtja`, `Dukshmeria`, `Mediumi`) VALUES ('1011', '3015', 'A Systematic Review of Research Papers on Construction', '3015', '1', '2016-11-26 13:30:00', 'link.11', 'Despite construction being a major contributor to the national economy of the United States, the
  251. discipline has received inadequate attention from researchers and scholars, except lately. Being a
  252. developing field, research endeavors in this field is constantly evolving. The paper reports the
  253. results of an eleven-year analysis of the IJCER technical papers. Based on content analysis of the
  254. technical papers published in IJCER from 2000 till 2011 utilizing the keywords as the recording
  255. units, this paper identified the major research topics of interest in this discipline. While the paper
  256. provided the scholars and practitioners a baseline understanding of the current research trend, it
  257. also highlighted the under-researched topics in this discipline.
  258. Key Words: Qualitative research, Construction research, Construction education ', 'The construction industry plays a major role in the national economy of the United States (Abudayyah, et al., 2000),
  259. contributing in excess of $570 billion to the national gross domestic product (Census, 2011). In spite of supporting
  260. business of such magnitude, it is one of the least researched disciplines (Abudayyeh, et al., 2004). Traditionally
  261. construction is envisioned as a craft based discipline where “knowledge was gained by doing” (Oglesby, 1990), and
  262. consequently failed to attract adequate attention from the researchers and scholars. Recent shift toward higher
  263. education and research activities in construction has led to the exploration of new technologies, materials, and
  264. methods to improve the processes of construction, as well as improve construction education. However, being a
  265. developing field, research in construction is constantly evolving, and the best actions to take are constantly being
  266. challenged (Abudayyeh, et al., 2004).
  267. The research efforts in construction cover a wide range of topics related to practice and education. The goal of this
  268. paper was to explore the trends of research in construction. With a base-line understanding of the research done so
  269. far, the researchers will be able to efficiently streamline their efforts to explore the less-investigated or novel topics.
  270. This paper has reviewed the research trends in construction practice and education by analyzing the scholarly papers
  271. published in the Associated Schools of Construction’s International Journal of Construction Education and Research
  272. (IJCER) from 2000 to 2011. The IJCER, formerly known as Journal of Construction Education (IJCER replaced
  273. Journal of Construction Education in 2004 that was originally founded in 1996), is one of the premier publications in
  274. the field of construction, and has made significant contributions to construction practice and education. The journal
  275. was published thrice yearly from 2001 to 2004, when it became quarterly.', '1', '21');
  276.  
  277.  
  278.  
  279. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`publikimet` (`PubID`, `Publikuesi`, `Titulli`, `Autori_i_pare`, `Vendi_Publikimit`, `Data_Publikimit`, `Linku_Publikimit`, `Abstrakti`, `Permbajtja`, `Dukshmeria`, `Mediumi`) VALUES ('1012', '3017', 'ARTIFICIAL INTELLIGENCE', '3017', '19', '2016-12-01 16:00:00', 'link.12', 'Artificial Intelligence (AI) is a science and a set of computational technologies that
  280. are inspired by—but typically operate quite differently from—the ways people use
  281. their nervous systems and bodies to sense, learn, reason, and take action. While the
  282. rate of progress in AI has been patchy and unpredictable, there have been significant
  283. advances since the field’s inception sixty years ago. Once a mostly academic area of
  284. study, twenty-first century AI enables a constellation of mainstream technologies that
  285. are having a substantial impact on everyday lives. Computer vision and AI planning,
  286. for example, drive the video games that are now a bigger entertainment industry than
  287. Hollywood. Deep learning, a form of machine learning based on layered representations
  288. of variables referred to as neural networks, has made speech-understanding practical
  289. on our phones and in our kitchens, and its algorithms can be applied widely to an
  290. array of applications that rely on pattern recognition. Natural Language Processing
  291. (NLP) and knowledge representation and reasoning have enabled a machine to beat
  292. the Jeopardy champion and are bringing new power to Web searches. ', 'The frightening, futurist portrayals of Artificial Intelligence that dominate films and
  293. novels, and shape the popular imagination, are fictional. In reality, AI is already
  294. changing our daily lives, almost entirely in ways that improve human health, safety,
  295. and productivity. Unlike in the movies, there is no race of superhuman robots on the
  296. horizon or probably even possible. And while the potential to abuse AI technologies
  297. must be acknowledged and addressed, their greater potential is, among other things,
  298. to make driving safer, help children learn, and extend and enhance people’s lives. In
  299. fact, beneficial AI applications in schools, homes, and hospitals are already growing
  300. at an accelerated pace. Major research universities devote departments to AI studies,
  301. and technology companies such as Apple, Facebook, Google, IBM, and Microsoft
  302. spend heavily to explore AI applications they regard as critical to their futures. Even
  303. Hollywood uses AI technologies to bring its dystopian AI fantasies to the screen.
  304. Innovations relying on computer-based vision, speech recognition, and Natural
  305. Language Processing have driven these changes, as have concurrent scientific and
  306. technological advances in related fields. AI is also changing how people interact with
  307. technology. Many people have already grown accustomed to touching and talking to
  308. their smart phones. People’s future relationships with machines will become ever more
  309. nuanced, fluid, and personalized as AI systems learn to adapt to individual personalities
  310. and goals. These AI applications will help monitor people’s well-being, alert them to
  311. risks ahead, and deliver services when needed or wanted. For example, in a mere
  312. fifteen years in a typical North American city—the time frame and scope of this report—
  313. AI applications are likely to transform transportation toward self-driving vehicles with
  314. on-time pickup and delivery of people and packages. ', '1', '12');
  315.  
  316.  
  317.  
  318.  
  319. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`publikimet` (`PubID`, `Publikuesi`, `Titulli`, `Autori_i_pare`, `Vendi_Publikimit`, `Data_Publikimit`, `Linku_Publikimit`, `Abstrakti`, `Permbajtja`, `Dukshmeria`, `Mediumi`) VALUES ('1013', '3019', 'Real Time Mechatronic Design Process for Research and Education', '3019', '17', '2016-11-28 20:00:00', 'link.13', 'This paper presents the design methodology used in various real time mechatronics projects that
  320. involve data acquisition, real time control and embedded processing. As a design philosophy,
  321. mechatronics serves as an integrating approach to engineering design. A mechatronically
  322. designed product relies heavily on system sensing and component modeling and simulation to
  323. establish the optimal design tradeoffs between electronic and mechanical disciplines when
  324. subject to specific cost and performance constraints. The mechatronic method followed by us
  325. incorporates a language-neutral approach for real time modeling using graphics based visual
  326. simulation programs.
  327. The projects discussed in the paper are Mechatronics Technology Demonstrator using damped
  328. oscillator system, Thrust Control for Rocket Propulsion, Fuel Flow Metering and Control
  329. System, Active Noise Control, Time Delay Heat Blowers. Also discussed is an example of Rapid
  330. Prototyping of Vibration Monitoring System. The ideas and techniques developed during the
  331. interdisciplinary simulation process provide the ideal conditions to raise synergy and provide a
  332. catalytic effect for discovering new and simpler solutions to traditionally complex problems.
  333. Mechatronic products exhibit performance characteristics that were previously difficult to
  334. achieve without this synergistic combination.', 'Starting with the basic system design phase and progressing through the manufacturing phase,
  335. the mechatronic process optimizes the system parameters at each phase to produce a high quality
  336. multi-disciplinary2
  337. integrated product in a short cycle time. The Mechatronics design process is
  338. shown in Figure 2. Mechatronics employs control systems to provide a coherent framework for
  339. component interactions and their analysis. Integration within a mechatronic system is performed
  340. through the combination of hardware components and software, including information
  341. processing. This is known as Hardware-In-The-Loop simulation. Hardware integration results
  342. from designing the mechatronic system as an overall system which includes the sensors,
  343. actuators and embedded computer as well. Software integration is based on control functions
  344. and algorithms to be performed.
  345. The benefits of the mechatronic design approach are greater productivity (shorter development
  346. cycles and faster time to market), higher quality, and lower cost products. They also provide
  347. additional influence through the acquisition of knowledge information from the process. A
  348. mechatronic product can achieve impressive results if it is effectively integrated with the
  349. concurrent engineering management strategy. ', '2', '17');
  350.  
  351.  
  352.  
  353.  
  354.  
  355. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`publikimet` (`PubID`, `Publikuesi`, `Titulli`, `Autori_i_pare`, `Vendi_Publikimit`, `Data_Publikimit`, `Linku_Publikimit`, `Abstrakti`, `Permbajtja`, `Dukshmeria`, `Mediumi`) VALUES ('1014', '3013', 'Home Automation Systems - A Study', '3013', '1', '2016-11-30 15:00:00', 'link.14', 'ABSTRACT
  356. With the increase in consumption of energy and
  357. population, there is a grave need to conserve energy in every
  358. way possible. The inability to access and control the
  359. appliances from remote locations is one of the major reasons
  360. for energy loss. A web or an android application is used by
  361. the users to give instructions to these systems. This
  362. system can make use of a host of communication methods
  363. such as Wi-Fi, GSM, Bluetooth, ZigBee. Different controlling
  364. devices and configurations can be found in existing systems.
  365. Such systems have been found already in many places for a
  366. wide variety of applications. This paper presents a survey of
  367. all such systems.
  368. General Terms
  369. Embedded Systems, Remote access Systems, Mobile
  370. Applications, Web Applications and Home Automation
  371. System
  372. Keywords
  373. Energy Conservation, Raspberry Pi, Portability, Physically
  374. Challenged, Electrical and Electronic Devices, Home
  375. Automation.', 'The system proposed in [1] provides 3 means to control the
  376. home: the GSM network, the Internet and through speech.
  377. The real time monitoring has been an important feature that
  378. can be used in the home automation systems. As a change in
  379. the status of the devices occurs, the user can be informed in
  380. real time. The user commands are transferred to a server
  381. which is usually done by a PC. The server processes the user
  382. commands and sends them to the relevant units. This can help
  383. control the appliances. GSM is used as a communication medium to help establish connection in places where there
  384. may not be proper internet connectivity. The server uses AT
  385. commands to communicate with the GSM modem. The
  386. mobile interface is developed using J2ME. The server has 4
  387. engines running – the web server, database, main control
  388. program and speech recognition program. The system can be
  389. controlled using SMS. It can send confirmation messages.
  390. Speech processing is done with a dynamic time wrapping
  391. algorithm. The voice activation has been tested and found to
  392. be too impractical. As a more stable alternative, the voice
  393. input can be activated through a wireless unit the user carries
  394. along in the house. Each application node has four parts – the
  395. transmitter, receiver, I/O device and a microcontroller. The
  396. main control program in the server takes status information
  397. from the devices’ transceiver in real time.', '2', '11');
  398.  
  399.  
  400. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`publikimet` (`PubID`, `Publikuesi`, `Titulli`, `Autori_i_pare`, `Vendi_Publikimit`, `Data_Publikimit`, `Linku_Publikimit`, `Abstrakti`, `Permbajtja`, `Dukshmeria`, `Mediumi`) VALUES ('1015', '3017',
  401. 'The Mobile Phone as a Universal Interaction Device –Are There Limits?',
  402. '3017', '19', '2016-12-02 15:00:00', 'link.15', 'ABSTRACT
  403. This paper reviews the often cited use of personal mobile
  404. devices, such as mobile phones and PDAs, for interacting
  405. with appliances, such as TVs, light switches, or vending machines.
  406. It argues that mobile devices should not be considered
  407. tools for general appliance control, but rather a means
  408. to assist users in exceptional situations that they do not encounter
  409. on a daily basis. To illustrate this paradigm, a prototype
  410. implementation for mobile phones is presented and
  411. the setup of a user study to verify its value is discussed.',
  412.  
  413. 'Personal mobile devices, such as mobile phones and PDAs,
  414. represent an important building block in many of the systems
  415. discussed in the ubicomp community. Their widespread
  416. use and their characteristics as a general purpose computing
  417. platform make them appear as ideal devices for the implementation
  418. of many applications. Scenarios involving personal
  419. mobile devices range from attaching digital annotations
  420. to physical objects, controlling large public displays,
  421. and interacting with appliances of all sorts.
  422. While it is obvious that personal mobile devices can provide
  423. the technical functionality needed to implement such
  424. novel applications, we believe that from a user-centric perspective,
  425. their use cannot be justified in some of the commonly
  426. cited ubicomp scenarios. In particular, we challenge
  427. the notion of using personal mobile devices for universal
  428. appliance interaction, i.e., controlling technical equipment,
  429. such as vending machines, thermostats, or answering machines,
  430. through mobile phones. In this paper, we discuss
  431. preliminary arguments supporting our claim and try to answer
  432. the question under which circumstances it is appropriate
  433. to use a mobile phone for appliance interaction and
  434. under which it is not. We also present a demonstrator illustrating
  435. our paradigm and discuss the setup of a user study
  436. that we will conduct in order to verify our thesis.', '2', '12');
  437.  
  438.  
  439.  
  440.  
  441. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`bashkautoret` (`B_AutoretID`, `Bashke_Autoret`, `Publikimi`) VALUES ('200', '3016', '1010');
  442. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`bashkautoret` (`B_AutoretID`, `Bashke_Autoret`, `Publikimi`) VALUES ('201', '3017', '1010');
  443. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`bashkautoret` (`B_AutoretID`, `Bashke_Autoret`, `Publikimi`) VALUES ('202', '3018', '1011');
  444. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`bashkautoret` (`B_AutoretID`, `Bashke_Autoret`, `Publikimi`) VALUES ('203', '3014', '1012');
  445. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`bashkautoret` (`B_AutoretID`, `Bashke_Autoret`, `Publikimi`) VALUES ('204', '3020', '1013');
  446.  
  447.  
  448.  
  449. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`citimet` (`CitimiID`, `Cituesi`, `Publikimi`, `Koha_e_Citimit`) VALUES ('20', '3017', '1015', '2016-12-02 20:00:00');
  450. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`citimet` (`CitimiID`, `Cituesi`, `Publikimi`, `Koha_e_Citimit`) VALUES ('21', '3017', '1010', '2016-12-01 13:00:00');
  451. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`citimet` (`CitimiID`, `Cituesi`, `Publikimi`, `Koha_e_Citimit`) VALUES ('22', '3011', '1012', '2016-12-02 16:00:00');
  452. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`citimet` (`CitimiID`, `Cituesi`, `Publikimi`, `Koha_e_Citimit`) VALUES ('23', '3013', '1010', '2016-11-27 14:30:00');
  453. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`citimet` (`CitimiID`, `Cituesi`, `Publikimi`, `Koha_e_Citimit`) VALUES ('24', '3013', '1013', '2016-11-29 20:00:00');
  454. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`citimet` (`CitimiID`, `Cituesi`, `Publikimi`, `Koha_e_Citimit`) VALUES ('25', '3016', '1010', '2016-11-30 14:30:00');
  455. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`citimet` (`CitimiID`, `Cituesi`, `Publikimi`, `Koha_e_Citimit`) VALUES ('26', '3020', '1010', '2016-11-28 14:30:00');
  456. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`citimet` (`CitimiID`, `Cituesi`, `Publikimi`, `Koha_e_Citimit`) VALUES ('27', '3020', '1013', '2016-11-30 20:00:00');
  457.  
  458. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`leximet` (`LeximiID`, `Lexuesi`, `Publikimi`, `Vendi`, `Institucioni`, `Koha_e_Leximit`) VALUES ('20', '3017', '1015', '7', '5', '2016-12-02 20:00:00');
  459. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`leximet` (`LeximiID`, `Lexuesi`, `Publikimi`, `Vendi`, `Institucioni`, `Koha_e_Leximit`) VALUES ('21', '3017', '1010', '7', '5', '2016-12-01 13:00:00');
  460. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`leximet` (`LeximiID`, `Lexuesi`, `Publikimi`, `Vendi`, `Institucioni`, `Koha_e_Leximit`) VALUES ('22', '3011', '1012', '1', '1', '2016-12-02 16:00:00');
  461. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`leximet` (`LeximiID`, `Lexuesi`, `Publikimi`, `Vendi`, `Institucioni`, `Koha_e_Leximit`) VALUES ('23', '3013', '1010', '3', '2', '2016-11-27 14:30:00');
  462. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`leximet` (`LeximiID`, `Lexuesi`, `Publikimi`, `Vendi`, `Institucioni`, `Koha_e_Leximit`) VALUES ('24', '3013', '1013', '3', '2', '2016-11-29 20:00:00');
  463. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`leximet` (`LeximiID`, `Lexuesi`, `Publikimi`, `Vendi`, `Institucioni`, `Koha_e_Leximit`) VALUES ('25', '3016', '1010', '5', '3', '2016-11-30 14:30:00');
  464. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`leximet` (`LeximiID`, `Lexuesi`, `Publikimi`, `Vendi`, `Institucioni`, `Koha_e_Leximit`) VALUES ('26', '3020', '1010', '13', '10', '2016-11-28 14:30:00');
  465. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`leximet` (`LeximiID`, `Lexuesi`, `Publikimi`, `Vendi`, `Institucioni`, `Koha_e_Leximit`) VALUES ('27', '3020', '1013', '13', '10', '2016-11-30 20:00:00');
  466. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`leximet` (`LeximiID`, `Lexuesi`, `Publikimi`, `Vendi`, `Institucioni`, `Koha_e_Leximit`) VALUES ('28', '3011', '1015', '1', '1', '2016-12-01 15:00:00');
  467. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`leximet` (`LeximiID`, `Lexuesi`, `Publikimi`, `Vendi`, `Institucioni`, `Koha_e_Leximit`) VALUES ('29', '3011', '1010', '1', '1', '2016-12-01 17:00:00');
  468. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`leximet` (`LeximiID`, `Lexuesi`, `Publikimi`, `Vendi`, `Institucioni`, `Koha_e_Leximit`) VALUES ('31', '3011', '1014', '1', '1', '2016-12-03 20:00:00');
  469.  
  470.  
  471.  
  472. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`vendet_punes` (`Vendi_PunesID`, `Postuesi`, `Lloji_Punes`, `Vendi`, `Pershkrimi`, `Data_Shpalljes`, `Data_Mbarimit`) VALUES ('20', '3013', '7', '3', 'Kerkojme nje inxhinier te elektro-teknikes me interesim ne fushen e automatikes qe te sjell pervojen e tij ne nje projekt qe e ka inicuar fakulteti yne!', '2016-11-20 11:00:00', '2016-12-05 12:00:00');
  473. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`vendet_punes` (`Vendi_PunesID`, `Postuesi`, `Lloji_Punes`, `Vendi`, `Pershkrimi`, `Data_Shpalljes`, `Data_Mbarimit`) VALUES ('21', '3017', '21', '7', 'Si profesoreshe shume vjeqare ne fushen e teknologjise se informacionit kerkoj nje asistent/e qe se bashku te punojme ne nje projekt te perbashket te dedikuar per universitetin e Londres', '2016-12-01 12:00:00', '2016-12-21 14:00:00');
  474. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`vendet_punes` (`Vendi_PunesID`, `Postuesi`, `Lloji_Punes`, `Vendi`, `Pershkrimi`, `Data_Shpalljes`, `Data_Mbarimit`) VALUES ('22', '3019', '26', '9', 'Бараме предавач за да ни помогне во организацијата на предмети. Кандидатите треба да имаат д-р или да докторски студии', '2016-12-01 16:00:00', '2016-12-30 18:30:00');
  475. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`vendet_punes` (`Vendi_PunesID`, `Postuesi`, `Lloji_Punes`, `Vendi`, `Pershkrimi`, `Data_Shpalljes`, `Data_Mbarimit`) VALUES ('23', '3020', '6', '13', 'Tehnička traže praktična iskustva u tom području, da nam pomogne s praktičnim alatima organizacije o projektu', '2016-11-25 10:00:00', '2016-12-03 14:30:00');
  476. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`vendet_punes` (`Vendi_PunesID`, `Postuesi`, `Lloji_Punes`, `Vendi`, `Pershkrimi`, `Data_Shpalljes`, `Data_Mbarimit`) VALUES ('24', '3016', '11', '5', 'Kerkojme nje zhvillues te software-it, aplikanti duhet te kete pervoje 3 vjeqare ne ndonjeeren nga fushat e teknologjise se informacionit', '2016-12-01 19:30:00', '2016-12-30 17:00:00');
  477.  
  478.  
  479. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_vendepune` (`Shfrytezuesi`, `Vende_Pune`) VALUES ('3011', '24');
  480. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_vendepune` (`Shfrytezuesi`, `Vende_Pune`) VALUES ('3011', '23');
  481. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_vendepune` (`Shfrytezuesi`, `Vende_Pune`) VALUES ('3016', '20');
  482. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_vendepune` (`Shfrytezuesi`, `Vende_Pune`) VALUES ('3016', '21');
  483. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_vendepune` (`Shfrytezuesi`, `Vende_Pune`) VALUES ('3014', '21');
  484. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_vendepune` (`Shfrytezuesi`, `Vende_Pune`) VALUES ('3020', '23');
  485. INSERT INTO `bd_per_menaxhimin_e_rrjeteve_sociale`.`shfrytezues_vendepune` (`Shfrytezuesi`, `Vende_Pune`) VALUES ('3013', '23');
  486.  
  487.  
  488. UPDATE `bd_per_menaxhimin_e_rrjeteve_sociale`.`vendet_punes` SET `Vendi`='1', `Data_Shpalljes`=' 2016-12-01 16:00:00', `Data_Mbarimit`='2016-12-25 12:00:00' WHERE `Vendi_PunesID`='20';
  489. UPDATE `bd_per_menaxhimin_e_rrjeteve_sociale`.`vendet_punes` SET `Data_Shpalljes`='2016-11-20 11:00:00' WHERE `Vendi_PunesID`='22';
  490. UPDATE `bd_per_menaxhimin_e_rrjeteve_sociale`.`vendet_punes` SET `Vendi`='1' WHERE `Vendi_PunesID`='24';
  491. UPDATE `bd_per_menaxhimin_e_rrjeteve_sociale`.`vendet_punes` SET `Vendi`='1' WHERE `Vendi_PunesID`='21';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!