PMI 09/07/09
by L@urent on déc.16, 2009, under Aviation photo trips @, PMI - Palma de Mallorca, Spain
A morning spent on the roof of the car park, close to the small but pleasant pub.
Two military aircraft first ;
E25-61/54-22 Casa 101 EdA
D.3B-3 Casa 212 SAR EdA
SELECT p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, p.user1 as pUser1, p.user2 as pUser2, p.user3 as pUser3, p.user4 as pUser4, c.cid as cCid, c.name as cName, c.description as cDescription, c.pos as cPos, c.parent as cParent, c.thumb as cThumb, u.user_lastvisit AS uUser_lastvisit,u.user_regdate AS uUser_regdate,u.user_email AS uUser_email,u.user_profile1 AS uUser_profile1,u.user_profile2 AS uUser_profile2,u.user_profile3 AS uUser_profile3,u.user_profile4 AS uUser_profile4,u.user_profile5 AS uUser_profile5,u.user_profile6 AS uUser_profile6, a.aid AS aAid, a.title AS aTitle, a.description AS aDescription, a.visibility as aVisibility, a.pos as aPos, a.category as aCategory, a.thumb as aThumb, a.keyword as aKeyword FROM copper_pictures AS p LEFT JOIN copper_albums AS a ON p.aid = a.aid LEFT JOIN copper_categories AS c ON a.category = c.cid, copper_users AS u WHERE p.pid = 1273 AND ((a.visibility = 0 OR a.visibility IS NULL) AND (a.alb_password IS NULL OR a.alb_password = “”)) AND p.approved=’YES’
Then, some civvies …
D-ABAA B737-7Q6 Air Berlin New c/s (@)
D-ABAF B737-86J(WL) Air Berlin Old c/s
D-ABAS B737-86J(WL) Air Berlin Old c/s
SELECT p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, p.user1 as pUser1, p.user2 as pUser2, p.user3 as pUser3, p.user4 as pUser4, c.cid as cCid, c.name as cName, c.description as cDescription, c.pos as cPos, c.parent as cParent, c.thumb as cThumb, u.user_lastvisit AS uUser_lastvisit,u.user_regdate AS uUser_regdate,u.user_email AS uUser_email,u.user_profile1 AS uUser_profile1,u.user_profile2 AS uUser_profile2,u.user_profile3 AS uUser_profile3,u.user_profile4 AS uUser_profile4,u.user_profile5 AS uUser_profile5,u.user_profile6 AS uUser_profile6, a.aid AS aAid, a.title AS aTitle, a.description AS aDescription, a.visibility as aVisibility, a.pos as aPos, a.category as aCategory, a.thumb as aThumb, a.keyword as aKeyword FROM copper_pictures AS p LEFT JOIN copper_albums AS a ON p.aid = a.aid LEFT JOIN copper_categories AS c ON a.category = c.cid, copper_users AS u WHERE p.pid = 1268 AND ((a.visibility = 0 OR a.visibility IS NULL) AND (a.alb_password IS NULL OR a.alb_password = “”)) AND p.approved=’YES’
D-ABBI B737-86J(WL) Air Berlin Old c/s
D-ABBK B737-8BK(WL) Air Berlin New c/s (@)
D-ABBT B737-76N(WL) Air Berlin New c/s (@)
D-ABBU B737-8Q8 Air Berlin Old c/s
D-ABBY B737-808(WL) Air Berlin New old c/s (”AIR-BERLIN” on tail)
D-ABDU A320-214 Air Berlin New c/s (@)
D-ABGK A319-112 Air Berlin New c/s (@)
D-ABOA B757-330 Thomas Cook (Condor) Condor title, Thomas Cook blue tail
D-ABOE B757-330 Thomas Cook (Condor) Thomas Cook c/s, Condor titles
D-ABUA B767-330(ER)(WL) Thomas Cook (Condor) Thomas Cook c/s, Condor titles
D-AERS A330-322 Air Berlin New c/s (@)
D-AHFM B737-8K5(WL) TUIFly Haribo s/c
D-AICC A320-212 Condor Berlin Thomas Cook c/s, Condor titles
D-AICH A320-212 Condor Berlin Thomas Cook c/s, Condor titles
D-ATUC B737-8K5(WL) TUIFly HapagFly.com titles
EC-HEJ ATR 72-212A Air Nostrum
EC-HXA A320-232 Spanair Lo tienes todo para volar
EC-IIA Dash 8-315 Air Nostrum
EC-KET MD-87 Spanair Star Alliance c/s
EC-KLM Agusta-Westland AW-139 Sociedad de salvamento Sociedad Estatal de Salvamento y Seguridad Marítima
EC-LBC B757-28A Mint Airways
EI-DLO B737-8A(WL) Ryanair
G-BYAL B757-204 Thomson Airways “Thomsonfly.com” titles
G-CEJP B737-8BK(WL) Flyglobespan In Oman Air c/s
G-TOYG B737-36N BMI baby
HA-LOH B737-8Q8 Malev
PH-DXC Dash 8-315Q Air Nostrum
RA-64046 Tu-204 Red Wings
