RELATED
CLASSIFICATION INDEX
conveyor belts, machinery self-stick labels, adhesive tapes, sheets endless belts ink ribbons Electrical tape Conductive tapes Electronic tapes Special tapes conveyor belt production conveyor belt installation Eikettek, ribbon Ribbon Labels, Ribbon Decorative Tapes Road gap strip THERE BAND tapes Tapes Labeling Tapes Applicators and conveyor belts Narrow strip, cut Aluminum strips, sheets, rods, tubes and profiles Copper, brass bands, plates, rods, tubes Tesa Tape Tesa Packaging Tapes Hand-strap machine |
|
|
Home > Detailed search > Tapes |
|
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 "Tapes" ) 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 = "29663" )
group by c.eredeti_id
order by p.pozicio is null, p.pozicio, c.hirdmeret desc
limit 150 | |
