aka: Mobile Operation Godzilla Expert Robot Aero-type (M.O.G.E.R.A.)
In The Mysterians, Moguera is a robot used by the Mysterians to assist in destroying humanity to make them bend to their will and supply them with a sufficient amount of land and women. It attacked a small village with its eye beams, and proved immune to machinegun fire, flamethrowers, and mortar rounds. It was destroyed when the bridge it was standing on collapsed due to the military dynamiting it.
A new robot was created by the U.N. Godzilla Countermeasures Center, after the defeat of the new Super MechaGodzilla, to defend against and combat Godzilla. MOGERA project was supervised by Russian robotics expert Professor Alexander Mamiroff and inherited its name from the alien robot invader Moguera of the 1967 film, The Mysterians. Spacegodzilla sent him to space after a short fight.
Returning to Earth, MOGERA was repaired and, after a brief skirmish with Godzilla, joined the King of the Monsters in the final battle against Spacegodzilla where he probably perished in the huge explosion that ensued.
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_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 cpg14x_pictures AS p LEFT JOIN cpg14x_users AS u ON p.owner_id = u.user_id LEFT JOIN cpg14x_albums AS a ON p.aid = a.aid LEFT JOIN cpg14x_categories AS c ON a.category = c.cid WHERE 1 AND p.approved='YES' ORDER BY rand(144269) LIMIT 9