WHEN `adresa` LIKE "%shtepi-per-shitje-afer-unazes-madhe-ne-tirane%" THEN 0 ELSE 1
END, adresa ASC, CASE WHEN `ArtTitull_gj1` LIKE "%shtepi-per-shitje-afer-unazes-madhe-ne-tirane%" THEN 0 ELSE 1
END, ArtTitull_gj1 ASC, CASE WHEN `Keywords_gj1` LIKE "%shtepi-per-shitje-afer-unazes-madhe-ne-tirane%" THEN 0 ELSE 1
END, Keywords_gj1 ASC
Shtepi-per-shitje-afer-unazes-madhe-ne-tirane Agjensi imobiliare Tirane
