-- Perkthimet SQ/EN per badge-t dhe besueshmerine e bizneseve.
-- Importoje ne phpMyAdmin dhe pastaj pastro cache.
SET NAMES utf8mb4;
START TRANSACTION;
UPDATE `translates` SET `value`='Verified Business' WHERE `key`='Verified Business' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Verified Business', 'Verified Business', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Verified Business' AND `lang`='en');
UPDATE `translates` SET `value`='Biznes i Verifikuar' WHERE `key`='Verified Business' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Verified Business', 'Biznes i Verifikuar', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Verified Business' AND `lang`='sq');
UPDATE `translates` SET `value`='The ownership or business details have been verified by Pesyje.' WHERE `key`='The ownership or business details have been verified by Pesyje.' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'The ownership or business details have been verified by Pesyje.', 'The ownership or business details have been verified by Pesyje.', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='The ownership or business details have been verified by Pesyje.' AND `lang`='en');
UPDATE `translates` SET `value`='Pronesia ose te dhenat e biznesit jane verifikuar nga Pesyje.' WHERE `key`='The ownership or business details have been verified by Pesyje.' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'The ownership or business details have been verified by Pesyje.', 'Pronesia ose te dhenat e biznesit jane verifikuar nga Pesyje.', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='The ownership or business details have been verified by Pesyje.' AND `lang`='sq');
UPDATE `translates` SET `value`='Claimed Business' WHERE `key`='Claimed Business' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Claimed Business', 'Claimed Business', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Claimed Business' AND `lang`='en');
UPDATE `translates` SET `value`='Profil i Menaxhuar' WHERE `key`='Claimed Business' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Claimed Business', 'Profil i Menaxhuar', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Claimed Business' AND `lang`='sq');
UPDATE `translates` SET `value`='The business profile is managed by its owner or authorized representative.' WHERE `key`='The business profile is managed by its owner or authorized representative.' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'The business profile is managed by its owner or authorized representative.', 'The business profile is managed by its owner or authorized representative.', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='The business profile is managed by its owner or authorized representative.' AND `lang`='en');
UPDATE `translates` SET `value`='Profili i biznesit menaxhohet nga pronari ose perfaqesuesi i autorizuar.' WHERE `key`='The business profile is managed by its owner or authorized representative.' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'The business profile is managed by its owner or authorized representative.', 'Profili i biznesit menaxhohet nga pronari ose perfaqesuesi i autorizuar.', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='The business profile is managed by its owner or authorized representative.' AND `lang`='sq');
UPDATE `translates` SET `value`='Top Rated' WHERE `key`='Top Rated' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Top Rated', 'Top Rated', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Top Rated' AND `lang`='en');
UPDATE `translates` SET `value`='Me Vleresim te Larte' WHERE `key`='Top Rated' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Top Rated', 'Me Vleresim te Larte', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Top Rated' AND `lang`='sq');
UPDATE `translates` SET `value`='This business has a high customer rating based on published reviews.' WHERE `key`='This business has a high customer rating based on published reviews.' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'This business has a high customer rating based on published reviews.', 'This business has a high customer rating based on published reviews.', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='This business has a high customer rating based on published reviews.' AND `lang`='en');
UPDATE `translates` SET `value`='Ky biznes ka vleresim te larte nga klientet bazuar ne vleresimet e publikuara.' WHERE `key`='This business has a high customer rating based on published reviews.' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'This business has a high customer rating based on published reviews.', 'Ky biznes ka vleresim te larte nga klientet bazuar ne vleresimet e publikuara.', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='This business has a high customer rating based on published reviews.' AND `lang`='sq');
UPDATE `translates` SET `value`='Customer Favorite' WHERE `key`='Customer Favorite' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Customer Favorite', 'Customer Favorite', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Customer Favorite' AND `lang`='en');
UPDATE `translates` SET `value`='I Preferuar nga Klientet' WHERE `key`='Customer Favorite' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Customer Favorite', 'I Preferuar nga Klientet', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Customer Favorite' AND `lang`='sq');
UPDATE `translates` SET `value`='Customers consistently give this business excellent ratings.' WHERE `key`='Customers consistently give this business excellent ratings.' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Customers consistently give this business excellent ratings.', 'Customers consistently give this business excellent ratings.', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Customers consistently give this business excellent ratings.' AND `lang`='en');
UPDATE `translates` SET `value`='Klientet i japin vazhdimisht ketij biznesi vleresime te shkelqyera.' WHERE `key`='Customers consistently give this business excellent ratings.' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Customers consistently give this business excellent ratings.', 'Klientet i japin vazhdimisht ketij biznesi vleresime te shkelqyera.', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Customers consistently give this business excellent ratings.' AND `lang`='sq');
UPDATE `translates` SET `value`='Trending' WHERE `key`='Trending' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Trending', 'Trending', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Trending' AND `lang`='en');
UPDATE `translates` SET `value`='Ne Tendence' WHERE `key`='Trending' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Trending', 'Ne Tendence', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Trending' AND `lang`='sq');
UPDATE `translates` SET `value`='This business is currently receiving increased interest on Pesyje.' WHERE `key`='This business is currently receiving increased interest on Pesyje.' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'This business is currently receiving increased interest on Pesyje.', 'This business is currently receiving increased interest on Pesyje.', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='This business is currently receiving increased interest on Pesyje.' AND `lang`='en');
UPDATE `translates` SET `value`='Ky biznes po terheq aktualisht me shume interes ne Pesyje.' WHERE `key`='This business is currently receiving increased interest on Pesyje.' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'This business is currently receiving increased interest on Pesyje.', 'Ky biznes po terheq aktualisht me shume interes ne Pesyje.', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='This business is currently receiving increased interest on Pesyje.' AND `lang`='sq');
UPDATE `translates` SET `value`='Featured Business' WHERE `key`='Featured Business' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Featured Business', 'Featured Business', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Featured Business' AND `lang`='en');
UPDATE `translates` SET `value`='Biznes i Perzgjedhur' WHERE `key`='Featured Business' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Featured Business', 'Biznes i Perzgjedhur', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Featured Business' AND `lang`='sq');
UPDATE `translates` SET `value`='This business is currently featured on Pesyje.' WHERE `key`='This business is currently featured on Pesyje.' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'This business is currently featured on Pesyje.', 'This business is currently featured on Pesyje.', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='This business is currently featured on Pesyje.' AND `lang`='en');
UPDATE `translates` SET `value`='Ky biznes eshte aktualisht i perzgjedhur ne Pesyje.' WHERE `key`='This business is currently featured on Pesyje.' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'This business is currently featured on Pesyje.', 'Ky biznes eshte aktualisht i perzgjedhur ne Pesyje.', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='This business is currently featured on Pesyje.' AND `lang`='sq');
UPDATE `translates` SET `value`='Popular Business' WHERE `key`='Popular Business' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Popular Business', 'Popular Business', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Popular Business' AND `lang`='en');
UPDATE `translates` SET `value`='Biznes Popullor' WHERE `key`='Popular Business' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Popular Business', 'Biznes Popullor', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Popular Business' AND `lang`='sq');
UPDATE `translates` SET `value`='This business has received at least 50 published reviews.' WHERE `key`='This business has received at least 50 published reviews.' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'This business has received at least 50 published reviews.', 'This business has received at least 50 published reviews.', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='This business has received at least 50 published reviews.' AND `lang`='en');
UPDATE `translates` SET `value`='Ky biznes ka marre te pakten 50 vleresime te publikuara.' WHERE `key`='This business has received at least 50 published reviews.' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'This business has received at least 50 published reviews.', 'Ky biznes ka marre te pakten 50 vleresime te publikuara.', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='This business has received at least 50 published reviews.' AND `lang`='sq');
UPDATE `translates` SET `value`='Rich in Customer Photos' WHERE `key`='Rich in Customer Photos' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Rich in Customer Photos', 'Rich in Customer Photos', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Rich in Customer Photos' AND `lang`='en');
UPDATE `translates` SET `value`='Me Shume Foto nga Klientet' WHERE `key`='Rich in Customer Photos' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Rich in Customer Photos', 'Me Shume Foto nga Klientet', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Rich in Customer Photos' AND `lang`='sq');
UPDATE `translates` SET `value`='Customers have shared many photos with their reviews.' WHERE `key`='Customers have shared many photos with their reviews.' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Customers have shared many photos with their reviews.', 'Customers have shared many photos with their reviews.', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Customers have shared many photos with their reviews.' AND `lang`='en');
UPDATE `translates` SET `value`='Klientet kane ndare shume foto bashke me vleresimet e tyre.' WHERE `key`='Customers have shared many photos with their reviews.' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Customers have shared many photos with their reviews.', 'Klientet kane ndare shume foto bashke me vleresimet e tyre.', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Customers have shared many photos with their reviews.' AND `lang`='sq');
UPDATE `translates` SET `value`='Business Trust' WHERE `key`='Business Trust' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Business Trust', 'Business Trust', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Business Trust' AND `lang`='en');
UPDATE `translates` SET `value`='Besueshmeria e Biznesit' WHERE `key`='Business Trust' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Business Trust', 'Besueshmeria e Biznesit', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Business Trust' AND `lang`='sq');
UPDATE `translates` SET `value`='A summary of the signals that help customers evaluate this business.' WHERE `key`='A summary of the signals that help customers evaluate this business.' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'A summary of the signals that help customers evaluate this business.', 'A summary of the signals that help customers evaluate this business.', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='A summary of the signals that help customers evaluate this business.' AND `lang`='en');
UPDATE `translates` SET `value`='Nje permbledhje e sinjaleve qe i ndihmojne klientet ta vleresojne kete biznes.' WHERE `key`='A summary of the signals that help customers evaluate this business.' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'A summary of the signals that help customers evaluate this business.', 'Nje permbledhje e sinjaleve qe i ndihmojne klientet ta vleresojne kete biznes.', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='A summary of the signals that help customers evaluate this business.' AND `lang`='sq');
UPDATE `translates` SET `value`='Profile managed by the business' WHERE `key`='Profile managed by the business' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Profile managed by the business', 'Profile managed by the business', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Profile managed by the business' AND `lang`='en');
UPDATE `translates` SET `value`='Profili menaxhohet nga biznesi' WHERE `key`='Profile managed by the business' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT 'Profile managed by the business', 'Profili menaxhohet nga biznesi', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Profile managed by the business' AND `lang`='sq');
UPDATE `translates` SET `value`=':rating/5 from :count reviews' WHERE `key`=':rating/5 from :count reviews' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT ':rating/5 from :count reviews', ':rating/5 from :count reviews', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`=':rating/5 from :count reviews' AND `lang`='en');
UPDATE `translates` SET `value`=':rating/5 nga :count vleresime' WHERE `key`=':rating/5 from :count reviews' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT ':rating/5 from :count reviews', ':rating/5 nga :count vleresime', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`=':rating/5 from :count reviews' AND `lang`='sq');
UPDATE `translates` SET `value`=':count customer photos' WHERE `key`=':count customer photos' AND `lang`='en';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT ':count customer photos', ':count customer photos', 'dynamic', 'en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`=':count customer photos' AND `lang`='en');
UPDATE `translates` SET `value`=':count foto nga klientet' WHERE `key`=':count customer photos' AND `lang`='sq';
INSERT INTO `translates` (`key`, `value`, `type`, `lang`) SELECT ':count customer photos', ':count foto nga klientet', 'dynamic', 'sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`=':count customer photos' AND `lang`='sq');
COMMIT;