SELECT pa_ContactID,t_ContactName FROM Profiles as P inner join Categories_ContactsCategories as CC on (CC.pi_contactID=pa_ContactID) inner join Categories on (pa_CategoryID=pi_CategoryID) where P.b_Deleted=0 and P.b_Completed=1 and b_featured=0 and ( (t_picsFolder='place' and b_Status=1) OR (t_picsFolder!='place') ) and ( (t_picsFolder='event' and pa_ContactID in (select pi_ContactID FROM Profiles_Events WHERE pi_ContactID=pa_ContactID and ((d_EndDate='0000-00-00') Or (d_EndDate ='2014-04-21' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-21')) and NotImportant=0)) OR (t_picsFolder!='event') ) and ( (t_picsFolder='movie' and 1 in (select b_PlayingNow FROM Profiles_Movies WHERE pi_MovieID=pa_ContactID))OR (t_picsFolder!='movie') ) and ((pi_ParentID in (382)) or (pi_ParentID in (select pa_CategoryID from Categories where pi_ParentID in (382)))) and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by `b_featured` DESC,t_ContactName asc
Guide to Loans: Home, Car and Personal Loans from Bands in Lebanon :: Beirut.com :: Beirut City Guide
 

3ish 3a Kayfak Loan for Private Sector's Employees at Lebanese Swiss Bank

3ish 3a Kayfak loan from LSB is the easiest way to finance your dreams.

 

3ish 3a Kayfak Loan for Public Sector's Employees at Lebanese Swiss Bank

3ish 3a Kayfak loan from LSB is the easiest way to finance your dreams.

 

Ameen at Credit Libanais

Our Bank has been a pioneer in offering micro-financing. This activity is in line with our long-term belief that micro-enterprises, like multinationals, are essential to the prosperity and development...

 

Ameen Loan (Micro Credits) at Fransabank

Credit offered by Ameen Company SAL enables individuals with limited income to benefit from micro to medium sized loans.

 

Army Housing Loan at Byblos Bank

Byblos Bank appreciates the many sacrifices that members of Lebanon's security forces make in order to help keep the rest of us safe. The Army Housing Loan is their way of saying "thank you".

 

Auto Finance

Do you want to drive the car of your dreams? Do you need a hassle-free and Sharia compliant auto finance tool? Do you seek flexible payment plans at a competitive profit rate? The Lebanese Islamic ...

 

B You Loan at Bank of Beirut

If you are looking to renovate your home or treat yourself to a holiday, the Personal Loan from Bank of Beirut is your hassle-free access to the venture of your interest. With an easy application and ...

 

Basic Personal Loan at Byblos Bank

Your best plans are often the ones you want to carry out straight away. Byblos Bank Personal Loan takes away the frustration of waiting to realize most purposes. With cash in your hand you are in a...

 

BDL Housing Loan at Lebanese Swiss Bank

In collaboration with Banque Du Liban (BDL), Lebanese Swiss Bank offers a housing program.

 

BDL Special Housing Loan at Credit Libanais

Home sweet home Your dream home doesn't have to be a dream anymore. Credit Libanais offers you the opportunity to buy a primary residence with preferential interest rate, no fees and no...