SELECT * FROM advertisment WHERE active='yes' AND ( catdom_id LIKE '%0196%' OR catdom_id LIKE '%0453%' OR catdom_id LIKE '%0454%' OR catdom_id LIKE '%0455%' OR catdom_id LIKE '%0456%' OR catdom_id LIKE '%0457%')
SELECT * FROM domain_advertisment WHERE catdom_id IN (196, 453, 454, 455, 456, 457) AND advertisment_id IN (4282, 736, 1641, 2300, 2807, 3863, 4230, 4685, 4737, 5723, 6417, 7444, 8366, 9097, 9308, 10032, 10075, 10086, 10099, 10395, 11002, 11100, 11509, 11532, 11842, 11888);

Cyprus Motors Search

Psaltis Auto Spare Parts

phone: +357 / 22-466-786
email: kaimakli[ at ]psaltis.com.cy
website: http://www.psaltis.com.cy/

GCV Truck Parts

phone: +357 / 26-812-444
email: info[ at ]gcvparts.com
website: http://www.gcv-parts.com/

Koufallis Motors

phone: +357 / 25-333-000
email: simos[ at ]koufallis.com
website: http://www.koufallis.com/

Kyoto Spare Parts

phone: +357 / 22-437-000
email: info[ at ]kyotoparts.com
website: http://www.kyotoparts.com/

Kyros Auto

phone: +357 / 22-433-915
email: info[ at ]kyrosauto.com
website: http://www.kyrosauto.com/

Chr. Kapodistrias

phone: +357 / 22-436-101
email: info[ at ]chrkapodistrias.com
website: http://www.chrkapodistrias.com/

KYMCO

phone: +357 / 24-668-444
email: motoland.kymco[ at ]cytanet.com.cy
website: http://www.kymco.com.cy/

S & A Agapiou Trading

ANW Cars Ltd.

phone: +357 / 26-652-661
email: anwcars[ at ]cytanet.com.cy
website: www.anwcars.com

NMA ECU Tuning

phone: +357 / 24-659-984
email: nma.technologies[ at ]yahoo.com
Results 1 - 10 out of 26