2024.11.24 Sunday Emma
 
FAST SEARCH DETAILED SEARCH Search of certificate of incorporation EUROPEAN LEVEL SEARCH OUR PRODUCTS USEFUL INFORMATION ABOUT US JOB CONTACT  

RELATED
CLASSIFICATION INDEX

Steel wire data security Front door manufacturing rehabilitation centres Salvage Yard car breakers car alarms Lake Balaton Shore of Lake Balaton Lake Balaton hotels Belgian cuisine Stamp immediately concrete concrete additives concrete units , reinforced concrete concrete impregnating shopping centres Security Door Security doors security Analysis security reviews safety report Security service Security services security services security technology Safety review Safety measurements Security advice Safety tests Safety potatoes Truck cooling improving Bystronic Converse family benefits, family credit infant care centres 1-50 tons Crane rehab centres wire cable manufacture, wire cables Coating electronics electronic goods and spares, servicing electronic engineers and servicing Create and send an electronic tax returns Food safety demolition Fashion Lift Elevator Elevator repair elevators Elevator surface preparation, -treatment, -covering Metal-free crowns photoprotection, protective layer preparation Yarn wool, haberdashery willow growing spinning/plaiting industry French cuisine Grains milling industry Grain fumigation Grain trade gastronomy car and commercial vehicle washes industrial cloths plaster casts tyres, tyre repair, retreading childrens' homes Pharmaceutical care concerts Folding door profit vehicles Welding sheet cold foods website design property valuations School home charity Truck Truck service Truck refrigeration units Truck Repair Rescue truck Rescue truck Trucks to improve trucks, truck service stations Gate Phone door entry systems Add Entry Phones christmas decorations cardboard boxes chipboard military goods wire meshing Exhibitions management Klöpli nylon curtain condensers ready-made-clothes trade Conference Conference Organization Conferences conference centres conference management conference technology Contact lens Contact lens care Contact lens fluid Contact lens fitting skips, skip transport control Kitchen Kitchen Equipment kitchen appliances and furniture Kitchen furniture Kitchen Equipment Kitchen machine Kitchen Faucets Wood kitchen Kitchen worksheet Kitchen stoves Kitchen counter Kitchen Tips tinned food Kordon wicker-work cultural centres Accounting Diósd Bookkeeper Diósd Central heating fireplaces central vacuuming Residential home air conditioning Limonium Longines Hungarian cuisine Hungarian cuisine Hungarian cuisine microelectronics plastic processing jobcentres day care centres International cuisine Exam Center document security Organ building Organ Repair Organs card and paper policarbonates canvases, awnings Professional cosmetics Psychiatric care public relations walkie-talkie servicing and accessories promotional balloons Banquet Rent online copper- and bronzeworkers, copper wares tents and awnings wire cable Beauty beauty salons silicons tampon manufacture social work Poorhouse software installation Tanning Salons home entertainment, electronics tampon manufacture trailers, -parts teflon telephones, telephone service providers telephone networks, exchanges pulmonary clinics zinc plating, zinc plated goods financial estimates money handling financial protection Security fence Security systems reinforced steel fitting reinforced steel cutting Wax on canvas videophones, -conferences exam centres Barcode Label Barcode Printer bar codes and identification technology Barcode Printers Bar code tools Cash bar code systems to petrol stations Cash registers with bar code Barcode asset Barcode towhooks Xenon Pianos Piano transportation Safeguarding Reservation Property and fire protection Lift installation Installation of lifts Lifts to improve Operation of elevators Maintenance of lifts Lift remote control Liquid sealant Restaurant Taksony Taksony restaurant Wholesale Kitchen Equipment Fire alarm device announcer Security service working Szolnok lifts Kitchen Products Kitchen cabinet 7-28 tons Crane 7 ton crane 8 ton crane 13 ton crane 16 ton crane 20 tonne crane 28 ton crane Canned fish Grain pest Boiron Truck Rental Contact lens specialist Truck Odor Professional event organizing Conferences Tire Trucks Batch Control Analysis Online booking Electrical cables Electronic Tools Non-destructive material testing machine Property specialist Property textbooks Barcode Slovak Koruna Rent-a-car non-stop Confectioning cable machinery Respiration balloon bending of reinforcing steel for the season high season multifunctional glasses Truck Wash Liquid Soap Shampoo Patterned canvas White linen Raw canvas Iron on canvas Chintz Non-Stop Quick 0-24/7 cake shop Balatonföldvár Cocktail bar Balatonföldvár conga night live music Balatonföldvár Online kaputervező sectional garage door Order on-line car Online car rental Online car rental vehicle hire scooter shop taxi Törökbálint taxi Diósd taxi Sóskúti air-conditioned cars for hire Outdoor Monitor Container shipment electronic software Electronic measuring instruments breakdown after cleaning üregkamrás polycarbonate cellular polycarbonate polycarbonate chamber légkamrás polycarbonate Multiclear üregkamrás polycarbonate sheets Multiclear polkarbonát disc Multiclear polycarbonate sheets Outdoor polycarbonate solid polycarbonate argon cylinder cutting safety review of welding machines coated electrodes Welding line Beauty salon Solymár truck transportation sheeted truck transport Airport location car phone Car Electronics központizárak Central locks Cable hold Scania trucks to improve Electronic Components Ergonomic advice used in large machines new large machines Mongolian-type restaurant Mongolian Restaurant Mongolian-type dishes Accordion doors 7 ton crane Betonfeszítő wires Hotel Mosonmagyaróvár Professional Skin Care Professional development cosmetics Safety equipment crepe canvas canvas sheet Chamber Stellaplast betonvédő Complete lifts IKO concrete nails Hydra System Options Halonbank Halon Disposal Positioning Devices industrial grain powder Galvanic coatings preparation Tampon plating Installation kitchen equipment DON online theater tickets Coating Bronze sculptures Separated components Studio kitchen Education, demonstration tools Decorative coating Mechatronics Skoda Auto farm frites frozen potatoes construction and demolition debris transport Contact Center FŐTÁV Contact Center Military Clothing Military Equipment Jacket concrete delivery concrete production Concrete production Concrete Mixing Framing immediately logistics centers Kitchen worktops comparative assessment of market the review of assets Balaton waterfront Balatoni flat Balaton apartman Balaton apartman lithium-ionic Screwdrivers Breakdown-rescue trucks from abroad Online Photo Picture framing online Bridal bouquets Liquid sealant refractory concrete acid-resistant concrete assembly of electronic and precision equipment medical center Cserkeszőlő synchronous ring bearing tower Mobile phone to pay Buying a mobile phone Online ticket setting, polishing and surface finishing discs Diamond discs and diamond abrasives flexililis steel container homes container houses e-store management system electronic production patient identification Automatic person identification barcode printers barcode readers Security ID Card Biometric identification Non-profit Safety films Security window Security Bags Stikit Discs Hookit discs Bristle Discs Structural adhesives for construction Gluconates Personal Care Industrial Applications Congress International congresses Electronic tapes Safety covers Seam Forklift batteries 8 ton crane Budapest lift repairs lift installation in Budapest Lift Maintenance Installation of security doors Omron blood pressure Fire-retardant coatings Wood coatings Industrial coatings Szeged Transport path accordion doors Dexion shelving Salg Gondolas Phone register Transitions Julian Beauman Celine Dion Cooper Vision Johnson & Johnson Sauflon Contact lens ophthalmic testing identification technique SONEL Zebra Barcode Printers Symbol bar code readers Metrologic bar code readers electronic signature e ad electronic signature verification services unsolicited electronic ads related to official control identity management fat break-down Hungarian Language Lessons NDT Training Chronos Towing Equipment Traction data Defense management Military nursing weddings full management corporate management presentations Konica Konica-Minolta Epson pontbevilágítók Clinical Monitoring One to one lesson Hungarian lessons Read double-sided adhesive Philips patient monitors Philips monitoring systems Aurion Frankonia measuring chambers Raymond Weil Vacheron Constantin Conflicts kitchen utensils polycarbonate glasses electric kitchen machines kitchen products historical reconstruction planning gastronomic products Custom Built Lifts balance sheets authentication kitchen textiles Service Station 2-ton hoist 12-tonne lifting 20 ton hoist 4 ton hoist 2.5-tonne lifting tentacled 3 tonnes of lifting tentacled Truck hoist Synchronous lifting TOWER CRANES tower crane Monor mechanic Monor Car Peugeot Monor Car Monor Peugeot Monor Trucks padlókonvektorok Fan coil convectors built padlókonvektor convector wet environment Pearson VUE Outdoor concrete elements Abrasion-resistant coatings Efficiency Mini MBA Conflict resolution training Rational SCC Catering equipment Used catering equipment Complete kitchen Convection oven restorative dentistry Bioresonance endodontics ózonfogászat surgery csontátültetés Keratoconus treatment synchronous generator excitation voltage electronics excitation voltage and electronics residential home lakóotthonos care of persons with disabilities Manito kapuvasalat Residences Albertirsa Bridge Residential home Albertirsa Grove Residential Home Csobánka Special Employer Home Albertirsa point vízlevezetés Hauraton Drainfix Bloc Demolition work Jackhammer Building demolition work To obtain the title deed Ergonomics What's new book Children book news What new book for young people Repair and insulating concretes Refractory bricks, shapes, concrete DAF truck parts Iveco truck parts MAN truck parts Mercedes-Benz truck parts Renault Truck Parts Volvo Truck Parts Truck opener vehicle dismantler truck body parts used truck parts Online textbook sales schizophrenic patients családgondozása Community psychiatric care Buy tickets online Central heating annual balcony biennial balcony substation instrumentation kondenzgazdálkodás Energy reconstruction reconstruction, electricity hydrogeochemical reconstruction Edit Website Electronics advice blow molding Conference Center Company events Book management Seminars conducted Press conferences conducted Cultural Banquet consecutive interpretation Conference interpretation Simultaneous Classical Concert Thin zsugorcsövek electron irradiation Fleet monitoring Fleet tracking Container sales Special containers for sale TONDACH tile Cartridge pens Concrete Cleaning Online shoe catalog Discount battery Battery discount Budapest Second Hand Liquid Soap Systems Liquid soap cartridges Liquid Soap Refill Non-Woven Wipes Toy trains Substation Condensate Condensing flue gas heat recovery Jewelry shop Lambda probe test Central locking installed Installation of wireless phones Intervertebral disc herniation gymnastics Point tickets Microspon mushrooms Print Commercial property Complex security systems Security Audit Donaldson Degrémont technology Converse shoes Converse shoes Photo gifts immediately Car translator disk Standard vehicle disc translator Mounting Kitchen drop cloth Gas condensing appliances Selective tinning Selective circuits, tinned String spinning-mill Nylon strings String plucked strings production Christmas Gift Ideas Security guarding Oxygen Special polycarbonate sheets Dibond Alucobond Collision repair trucks Used trucks Truck body húzatás Hajdú Truck Service Truck service Debrecen Non-stop taxi Non-stop taxi Freewheel STRONGBELT Mormon religion Plasterboard Accessories Plasterboard page Plasterboard screws and plugs Plasterboard tools Anchor plate Coating and coated sheets Family-friendly hotels in Mosonmagyaróvár Restaurant Mosonmagyaróvár Cornelia intercom Kronenberg elevator Comelit intercom For a long time photoluminescent safety signs Security systems guide Safety signs Reinforced concrete beam Certificate of incorporation Computer configurations Cutting steel construction, demolition Electronic local government Ferencvaros Samsonite Destruction-free material testing Kitchen Storage Rack Stainless kitchen shelves Potatoes abrasive machines Universal kitchen Desktop electronic balance Truck terminals Development of automatic identification systems Handheld Barcode scanners Barcode Printers Bon-bon boxes Silicon Baking Silicon Foam bag Wilton Products Teflon film oven Teflon film Makrolon Dibond polycarbonate sheets Quinn, polycarbonate sheets Lexan polycarbonate sheets Makrolon polycarbonate sheets Alucobond polycarbonate sheets Dibond polycarbonate sheets Multipanel polycarbonate sheets Integrated telephone design Leased line services CCTV Video Center Telephone cut Modern telephone Electronic communication Silicone Baking Silicone Foam bag Christmas Decorations Plastic kitchen products 24-hour service, leaving Electronic equipment repair Tailor-made security service Repair of electronic equipment Electric gate and intercom installation Metrology Conference publications Metrology Conferences Metrology congress Gym Gym Budaörs Cold Products Wedding cake Security locks CHAMPIONS Copy keys CHAMPIONS keys GLI Ottone Consecutive interpreting department Flanges & Components Deposition Materials Technical Teflon film Monitoring Services Monitorszervíz Windscreen replacement immediately Graduate bond immediately Thesis bond immediately Industrial floor Permanent grave care Temporary grave care Maintenance-free battery Bystronic laser cutting systems Bystronic water jet cutting systems Bystronic CNC press brake Bystronic scissors Flat lenses convector Matrimonial property Grain logistics site Complex logistics Online Stock Information Cereal rental Container depózás Warehousing Cross-docking Outdoor storage Galvanic production Ink Ink toner Senior citizens' home Elderly home Elderly home Tire condition monitoring Installation of earth-moving tires Drótpántos tire assembly Acélpántos tire assembly Tires fleet management Cold preparation of products Public Safety Debrecen Cirkonvázas porcelain crowns Zircon porcelain frame bridges Fired porcelain metal crowns Flame welding equipment, safety review Bioactive liquid mold Chips Condensate treatment Canned vegetables Canned fruit Military Knives Kitchen Knives Without breakdown of insulation Without breakdown Waterproofing Caraway oil Pepper extract Home and office telephone Telephone, fax, answering devices Bone and cartilage trainers Convector Honeywell Potato Shin guards Concrete milling Concrete insertion Concrete cutting Concrete roppantás Production of reinforced concrete structures COOPER VISION contact lenses Disposable contact lenses Discount Contact Lenses János Bolyai Military Technical Faculty Spot welding machines Gas Balatonlelle Fitters Balatonlelle Central mechanic Balatonlelle Central heating installation Balatonlelle Water mechanic Balatonlelle Plumbing Balatonlelle Exhibition pavilions construction Electronic graphic training Elevator Car lift Load lift Elevator modernization Divorce 24-hour telephone assistance Juggling training Juggler Silicone band Seamless opener Professional LED Lighting Electronics device locates Straw and basket weaving Concerts Central heating installation Mixer Machine Pumps Phone Aquaplus Concrete Drilling Vision Omron Koi carp Balatonboglári hotels Balatonboglári restaurant Ergonomic office chairs Seasonal opening hours Health Center Monor and its environs Balatongyörök Ministry of Defence Immediate incorporation Electronic incorporation Change banknotes withdrawn Xenon kits for the subsequent incorporation Competition and EU harmonization Balaton hotels Lake Balaton private beach Kitchen Kitchen Preparation Spoiled paint removal Phone Tower Gawin kitchen FRONIUS welding Proxxon Tools Anchor reservoir Karvázy Botondné Ophthalmic nursing Shopping Centre Wholesale electronics Coal and bronze brushes Security Sticker Limonium material Limonium cuttings Limonium seedlings Health Gardening Dentist Hungary Anxiety Hyaluron Electric level gauge Flow computer Slim Lens Liquid Soap Liquid Soaps Security entrance door 16 locks the front door Deckchairs on canvas Transportation 7 tons Crane 4 tonnes Security Cylinders Electronic locks and motor Asphalt and concrete mixing equipment Mixers KONICA MINOLTA official Brand KONICA MINOLTA official dealer KONICA MINOLTA Color Copiers KONICA MINOLTA Laser Printers KONICA MINOLTA official service center KONICA MINOLTA service center Electronic level gauge Ytong Coupon Holders Funeral Domony Burial Domony Legrand entryphones Cultural Centre XIII. district Faithful to the original prints on canvas painting Icons Canvas Picture Paintings at affordable prices AQUA-CONTRA falszárító System Children's assistant training Childcare training Hand-assisted breathing balloons Cosmetic bottles Bottles, jars Production Bronze sculptures Rejuvenation Facial Rejuvenation Nasenoperation Schönheitsoperationen Liposuktion Breast Correction Electronic component manufacturing Medical electrical equipment assembly FIRST AID NON-STOP Surgery Lip Augmentation Electronic filing Erd Tombstone Breathalyzer Safety tests Canon Canon SLR Camera Autogas Safety Course Waste tire collection Utilization of waste tires Barcode reader Szeged Nonprofit Environmental Ltd. Telemontázs Bt Cardin Electronics CANON Renovation Books Telephone and electronic customer care assistant training Telephone PBX Analog and digital telephone equipment Cordless DECT Phones Conference folders FALCON Decorative board One-to-one training Concord Language School Barcode Warehouse Pongrátz Pongrátz Trailer Parts Pongrátz Trailer Tarpaulins long frame Ericsson Studio Pulmonary surgery Home care services Burning the National Center for Handicapped Children Medical Sinks ĎURČEK Contact protractors Secure glasses Concrete Vibrator Wall slotting Bridgestone Occupational safety expert Safe operation of lifting Old windows and doors broken down Residual fuel oil, gasoline breakdown RÉPONSE treatments Central heating furnace chambers connected Student telephone Juggling Games Heat center and network Asynchronous motors OEM, Component Controls Congress Hall MV capacitors Power Capacitors Advanced Capacitors EPCOS, ICAR Power factor correction capacitors E-tax and contribution Identifying the goods Production of corrugated board Orion Garden and park maintenance EUROTRAK Ekontrol Electrical and electronic measurement instruments Safety Tester Console Stand Concrete Screed Fiber reinforced fibrin AND POLICIES Lightweight materials Mirela PE family Base concrete LCD Monitor Concept design Comparative cost analysis Design consultation Safety film Slot tools Dexion Nora Fire Safety Drill-down crown Wall slotting Dot Lasers Core bit Core bit distribution Plane cut in asphalt and concrete space HR Consulting Programmable engine management Programmable electronic ignition Engine management Conference furniture Demonstration instruments Projection Screen Potato cake Monitor pre-production work for glasses Xenon lamp Winter tires Xenon kits Unique kitchen Kitchen Equipment Kitchen Drivers and demolition tools Tools Plasterboard Silicone facade Silicone Paints Silicon Acrylics Waterproofing mortars, floor Poured industrial floor coatings Automatic water balloon Drilling in concrete walls Reinforced concrete, brick walls, floors Concrete cutting ventilation bores Cutting of concrete walls Hook Mounted Non-Stop Animal Hospital Falkartonok, size lightboxes Industrial plants, factories security fence construction Orchard cordon fences and building systems Online services Strong Security Ltd. Online ordering perfume Card Security Cylinder NC On-Line Simulator Security Cylinder DOM-called Security Ltd. Electronic ballast TFT Monitor Poker chips Security labels Personalized Case Management Forms Diamond Drilling in concrete technology Pannon perlite Perlite concrete NORDSON Dispensing Dog-fancier hotels in Mosonmagyaróvár Family-friendly hotels in Mosonmagyaróvár Condensing flue gas heat utilization HK container family Concrete tile Ultrasonic fat break-down Elevator design Service-hoist Online flower delivery Metrologic scanners Industrial fan, container Cordon tape Occupational Safety signs Safety signs Nursing home Biatorbágy Concrete Renovation Structural Concrete Repair CCCTV monitoring and intercom Defense concept Plastic parts tamponing Retirement home Old home Nursing home Care homes for elderly people Elderly Care Conference room, Romhány Retreaded truck tires Truck health check Truck wash Kecskemét Tire repair and installation Production of retreaded truck tires Carbon Monoxide Alarm Convectors Containerized waste A children's unit Budapest air-conditioned wine cellar Business Decisions Assessment Centre Developer Center Concrete beauty Rational Honeywell gas valves Honeywell automation FÉG convectors Balaton hotels Concrete track slabs superstructure Asphalt and concrete production, recycling Specialist property Bondzsi glass and Trade Bt Towbars supply, installation Vehicle testing up to 3.5 tonnes Construma Tank coating Heat-resistant coatings Licensed drinking water and food coatings Ozone in dentistry Authentication certificate of incorporation Bronze bars, bushes Hormonal treatment of skin diseases Konglobált acne treatment Lonsdale Finish Thompson Hycontrol | Milton Roy Milton roy europe Water level sensor probes Balaton Restaurant Restaurant Balatonlelle Pizzeria Balatonlelle Pier restaurant Balatonlelle Park-garden care Domestic appliance service in Miskolc Yarn Wholesale Cotton Yarn Industrial yarn Yarn Trade Passenger car production Production of car hoist Manufacture of office and living containers Manufacture of lift shafts Safety glass Steel security door Security Door Installation Security doors Security Door trade Hörmann sectional garage door Jonathermál Spa Italian-Hungarian cuisine Gabbia retaining walls Manufacture of blow molding Furniture production front 3D door- Acrylic fronts Acer ICONIA. Cavitation fat break-down Potato Frozen potatoes Frozen French fries Frozen carp Distance Learning Center in Budapest Concrete Grinder Recruitment for security guards Shot concrete Monitoring Plans Canned fruit and vegetable export Canned vegetables PBX Digital door entry systems Carbon Monoxide Detectors Safeguarding Vac Security screens Video Camera Security Systems Tyre Crushers Khaki Soldiers Martial Telephone Calling Xenon lights, sets Meta vehicle security systems Security and gate automation wholesale Kingstone insulation Plasterboard and accessories Elevators, escalators and stage equipment Lift periodic testing Elevator installation E-ticket Identification Equipment Safety belts Throat Microphone Security Seals Speakerphone Trunked radio telephone GSM Phone Line Extension Engine Safety Controls Safety latches and door contacts Security Locks Safety light curtains Security Gate Systems Security Camera Systems Monitoring relays Safety Relays Configurable control systems security Programmable safety and control systems UV Security Engraving Digital door entry systems Security Győr Fire and security systems Alarm Center Sonya Sonya Cosmetics Intercom Installation Security Seal Safety bag Security Labels Safety cleaning Contact lenses test Confetti Italian Kitchens Kitchen installation Car Electronics Installation Central locking abalakemelő Age Security Seals Budapest Car Electronics Order Concrete Concrete deliveries Concrete Pumping Concrete Technology Consulting Waterproof concrete Concrete containing antifreeze Concrete Sales Concrete Mixer Canned jars Platon drainage system Safety Cables Wireless Phone Weddings, events, transportation of persons conducting Video conferencing Musicals, musical evenings, concerts XVII district Zirconium crowns and bridges Periodontics Transzteletonikus ECG Chocolates Special sweets Macaron motherboards Diabetijkus bonbon Electrical heating cartridge Digital Piano Piano Woodwind, Brass, Saxophone, Harmonica Lift Troubleshooting Elevator modernization Maintenance Lifts Elevator maintenance Elevator Parts Hydraulic lift Lift Truck Maintenance Centering ring Phone alarm Kkivonuló Action Service License plate reader and identification system Fire and security Balaton real estate Lake property for sale Balaton site Villa Kati Vonyarcvashegy Apartment Vonyarcvashegy Balaton holiday accommodation, apartments Restaurant Vonyarcvashegy Silicone tubes Silicone Hoses Silicone tape Silicone Rubber Sheet Gaskets Silicone thermal curtains Silicone products Injection molded parts and extruded silicone forms Silicone foam products Silicone gaskets Pilkington Foreign Language Training Center Software and microelectronic topography protection Online ordering plants Balcony flowers Circular knitting yarn Polyester Yarn Mixed-fiber yarn Knitting Yarn Polyester Yarn Viscose yarn Dentist, Sopron Used auto parts Personally, Property Protection and Private Detectives Association, Antique Central Norton pump Acid-resistant concrete Plastic coating Cocoa Concerts Castle Concert Instant Cash Coating compounds Fondant Holding 13th district Container Equipment Safety Valve Safety glass Dental glass will be truncated Christmas tree ornaments Christmas ornament GSM PANNON Destructive Pipe Teflon bearings Tattoo Shop VODAFONE



Horn Magyarország

Detailed search


Got error 28 from storage engine
select c.eredeti_id ceg_id, c.cegnev, c.irsz, c.utca, c.email,c.web, c.tel_korzet, c.tel_szam, c.tel2_korzet, c.tel2_szam, c.fax_korzet, c.fax_szam, c.mobil_korzet, c.mobil_szam, c.fax2_korzet, c.fax2_szam, c.mobil2_korzet, c.mobil2_szam, c.webaruhaz, c.blog, c.kiemelt, c.kulcsszo, c.ajanlatURL, c.web2, c.email2, c.skype, c.logo, v.megnev varos_nev, c.egyk k_id , c.eredeti_id vi_id , p.pozicio from ceg c left join varos v on c.varos_id = v.varos_id left join megye m on v.megye_id = m.megye_id left join k_ceg_cimszo k on c.eredeti_id = k.ceg_id left join cimszo sz on sz.eredeti_id = k.cimszo_id left join pozicio p on p.partner=c.eredeti_id and (0 or p.fogalom like "Online Stock Information" ) and now()>=p.tol and now()<=ig where k.cimszo_id=sz.eredeti_id and c.eredeti_id=k.ceg_id and ( sz.eredeti_id = "28840" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150