druk: select c.categories_id, c.categories_image, cd.categories_link, cd.categories_name, cd.dane_szukaj, IF ((cd.dane_szukaj) REGEXP ('[-/\_ ]dt to 412s b412 3k[-/\_ ]'),1000,0) + IF ((cd.dane_szukaj) REGEXP ('[-/\_ ]dt[-/\_ ]to[-/\_ ]412[-/\_ ]s[-/\_ ]b[-/\_ ]412[-/\_ ]3[-/\_ ]k[-/\_ ]'),500,0) + IF ((cd.dane_szukaj) REGEXP ('[-/\_ ]dt to 412s b412 3k'),250,0) + IF ((cd.dane_szukaj) REGEXP ('[-/\_ ]dt[-/\_ ]to[-/\_ ]412[-/\_ ]s[-/\_ ]b[-/\_ ]412[-/\_ ]3[-/\_ ]k'),150,0) + IF ((cd.categories_name_short) REGEXP ('dt to 412s b412 3k'),300,0) + IF ((cd.dane_szukaj) REGEXP ('dt to 412s b412 3k'),150,0) + IF ((cd.dane_szukaj) REGEXP ('dt[-/\_ ]to[-/\_ ]412[-/\_ ]s[-/\_ ]b[-/\_ ]412[-/\_ ]3[-/\_ ]k'),100,0) + ROUND(c.popularnosc/10) + IF ((cd.dane_szukaj) REGEXP ('dt'),114,0) + IF ((cd.dane_szukaj) REGEXP ('to'),114,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]412[a-z \-/\]$'),42,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]412'),42,0) + IF ((cd.dane_szukaj) REGEXP ('412'),171,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]412s[a-z \-/\]$'),42,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]412s'),42,0) + IF ((cd.dane_szukaj) REGEXP ('412s'),171,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]b412[a-z \-/\]$'),42,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]b412'),42,0) + IF ((cd.dane_szukaj) REGEXP ('b412'),171,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]3k[a-z \-/\]$'),14,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]3k'),14,0) + IF ((cd.dane_szukaj) REGEXP ('3k'),57,0) + 600 as wynik from categories as c LEFT JOIN categories_description as cd on cd.categories_id = c.categories_id where c.categories_status = '1' and c.id_seria > 0 and ((c.categories_id like "2%")) and ( (cd.dane_szukaj) REGEXP ('dt[-/\\_ ]to[-/\\_ ]412[-/\\_ ]s[-/\\_ ]b[-/\\_ ]412[-/\\_ ]3[-/\\_ ]k') or (cd.dane_szukaj) REGEXP ('dt') or (cd.dane_szukaj) REGEXP ('to') or (cd.dane_szukaj) REGEXP ('412') or (cd.dane_szukaj) REGEXP ('412s') or (cd.dane_szukaj) REGEXP ('b412') or (cd.dane_szukaj) REGEXP ('3k') ) group by c.categories_id having wynik > 999 order by wynik desc, c.popularnosc desc LIMIT 100

all: select DISTINCT p.products_id, ocena_avg, r.ocena_count, p.products_image, p.products_quantity, pd.products_description, p.manufacturers_id, p.manufacturers_id_dedykowany, p.products_model, p.products_availability_id, p.polecany, p.darmowa_wysylka, p.waga, p.pojemnosc, p.wydajnosc, p.kategoria, p.technologia, p.rodzaj, p.typ, p.kolor, p.lplm, p.ilosc, pd.products_link, pd.products_name, p.products_price, p.products_retail_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, s.status, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, CONCAT_WS('/', pf.kategoria, pf.technologia, pf.typ, pf.rodzaj) as kategoria_impression , '0' as wykorzystaj_kupon, pfe.kod_konekt , IF ((pd.products_szukaj) REGEXP ('[-/\_ ]dt to 412s b412 3k[-/\_ ]'),1000,0) + IF ((pd.products_szukaj) REGEXP ('[-/\_ ]dt[-/\_ ]to[-/\_ ]412[-/\_ ]s[-/\_ ]b[-/\_ ]412[-/\_ ]3[-/\_ ]k[-/\_ ]'),500,0) + IF ((pd.products_szukaj) REGEXP ('[-/\_ ]dt to 412s b412 3k'),250,0) + IF ((pd.products_szukaj) REGEXP ('[-/\_ ]dt[-/\_ ]to[-/\_ ]412[-/\_ ]s[-/\_ ]b[-/\_ ]412[-/\_ ]3[-/\_ ]k'),150,0) + IF ((pd.products_szukaj) REGEXP ('dt to 412s b412 3k'),150,0) + IF ((pd.products_szukaj) REGEXP ('dt[-/\_ ]to[-/\_ ]412[-/\_ ]s[-/\_ ]b[-/\_ ]412[-/\_ ]3[-/\_ ]k'),100,0) + ROUND(p.popularnosc/10) + 600+ IF ((pd.products_szukaj) REGEXP ('dt'),114,0) + IF ((pd.products_szukaj) REGEXP ('to'),114,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]412[a-z \-/\]$'),42,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]412'),42,0) + IF ((pd.products_szukaj) REGEXP ('412'),171,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]412s[a-z \-/\]$'),42,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]412s'),42,0) + IF ((pd.products_szukaj) REGEXP ('412s'),171,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]b412[a-z \-/\]$'),42,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]b412'),42,0) + IF ((pd.products_szukaj) REGEXP ('b412'),171,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]3k[a-z \-/\]$'),14,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]3k'),14,0) + IF ((pd.products_szukaj) REGEXP ('3k'),57,0) + IF(p.kategoria = 1 and p.typ=1,55,0) + IF(p.kategoria = 1 and p.typ=2,50,0) + IF(p.kategoria = 1 and p.typ=5,52,0) + IF(p.manufacturers_id = 1,100,0) + IF(p.products_quantity > 1,10,0) as wynik from (((products p LEFT JOIN products_filtrowanie as pf on pf.kategoria_id = p.kategoria and pf.technologia_id = p.technologia and pf.rodzaj_id = p.rodzaj and pf.typ_id = p.typ and pf.lplm = '2' and pf.language_id = '1') left join manufacturers m using(manufacturers_id), products_description pd) left join manufacturers md on p.manufacturers_id_dedykowany = md.manufacturers_id left join specials s on p.products_id = s.products_id left join (select products_id, count(*) as ocena_count, avg(ocena) as ocena_avg from reviews where approved = 1 GROUP BY products_id) r on r.products_id = p.products_id left join (select pfe.products_id, GROUP_CONCAT(kod_konekt) as kod_konekt from products_feature pfe GROUP BY pfe.products_id) as pfe on pfe.products_id = p.products_id ) where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' and ((pd.products_szukaj) REGEXP ('dt[-/\\_ ]to[-/\\_ ]412[-/\\_ ]s[-/\\_ ]b[-/\\_ ]412[-/\\_ ]3[-/\\_ ]k') or (pd.products_szukaj) REGEXP ('dt') or (pd.products_szukaj) REGEXP ('to') or (pd.products_szukaj) REGEXP ('412') or (pd.products_szukaj) REGEXP ('412s') or (pd.products_szukaj) REGEXP ('b412') or (pd.products_szukaj) REGEXP ('3k') ) and p.kategoria in(1) and p.technologia in(2) group by p.products_id having wynik > 570.33333333333 and wynik > 500 order by wynik desc, products_availability_id, p.popularnosc desc, pd.products_name
Array ( [0] => dt [1] => to [2] => 412 [3] => 412s [4] => b412 [5] => 3k ) 1 Dt to 412s toner b412 3k in DrTusz.com store
DrTusz - www.drtusz.com
Language
Polski
English
Information
Opinie o DrTusz.pl - Tusze Tonery Drukarki

DrTusz.pl - dożywotnia gwarancja na zamienniki

DrTusz.pl - zawsze błyskawiczna przesyłka

Newsletter
Contact
Searching: „

DT TO 412S TONER B412 3K

If you cannot find ink or toner for your priner. Click here! ▼
Printers:
Products:
of 283
Category Laser Cartridges
Type Compatible
Class Toner
Color Black
Manufactured by DrTusz
Compatible with Konica - Minolta
Catalog Number DT-TKM-TNP90
Availability Available in 24h
In stock 56 szt.
Yield 20000 pages
Cost per page 1.00 gr/strona
199,99 PLN
(162,59 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Magenta
Manufactured by DrTusz
Compatible with Canon
Catalog Number DT-TC-045HM
Availability Available in 24h
In stock 21 szt.
Yield 2200 pages
Cost per page 9.54 gr/strona
209,99 PLN
(170,72 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Cyan
Manufactured by DrTusz
Compatible with Hewlett-Packard (HP)
Catalog Number DT-TH-201AC
Availability Available in 24h
In stock 310 szt.
Yield 1400 pages
Cost per page 12.50 gr/strona
174,99 PLN
(142,27 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Black
Manufactured by DrTusz
Compatible with Xerox
Catalog Number DT-TX-3435
Availability Available in 24h
In stock 6 szt.
Yield 10000 pages
Cost per page 2.00 gr/strona
199,99 PLN
(162,59 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Magenta
Manufactured by DrTusz
Compatible with Canon
Catalog Number DT-TC-28M
Availability Available in 24h
In stock 31 szt.
Yield 27000 pages
Cost per page 1.00 gr/strona
268,99 PLN
(218,69 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Magenta
Manufactured by DrTusz
Compatible with Canon
Catalog Number DT-TC-51M
Availability Available in 24h
In stock 124 szt.
Yield 60000 pages
Cost per page 1.05 gr/strona
631,99 PLN
(513,81 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Yellow
Manufactured by DrTusz
Compatible with Ricoh
Catalog Number DT-TR-220Y
Availability Available in 24h
In stock 120 szt.
Yield 2000 pages
Cost per page 13.45 gr/strona
268,99 PLN
329,99 PLN
(218,69 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Yellow
Manufactured by DrTusz
Compatible with Ricoh
Catalog Number DT-TR-2800Y
Availability Available in 24h
In stock 203 szt.
Yield 16000 pages
Cost per page 0.50 gr/strona
79,99 PLN
(65,03 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Cyan
Manufactured by DrTusz
Compatible with OKI
Catalog Number DT-TO-C650C
Availability Available in 24h
In stock 30 szt.
Yield 6000 pages
Cost per page 6.43 gr/strona
385,99 PLN
(313,81 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Yellow
Manufactured by DrTusz
Compatible with OKI
Catalog Number DT-TO-C650Y
Availability Available in 24h
In stock 30 szt.
Yield 6000 pages
Cost per page 6.43 gr/strona
385,99 PLN
(313,81 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Cyan
Manufactured by DrTusz
Compatible with Canon
Catalog Number DT-TC-054HC
Availability Available in 24h
In stock 221 szt.
Yield 2300 pages
Cost per page 8.70 gr/strona
199,99 PLN
(162,59 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Black
Manufactured by DrTusz
Compatible with Canon
Catalog Number DT-TC-071
Availability Available in 24h
In stock 17 szt.
Yield 1100 pages
Cost per page 19.09 gr/strona
209,99 PLN
(170,72 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Yellow
Manufactured by DrTusz
Compatible with Canon
Catalog Number DT-TC-718Y
Availability Available in 24h
In stock 86 szt.
Yield 2800 pages
Cost per page 6.25 gr/strona
174,99 PLN
(142,27 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Cyan
Manufactured by DrTusz
Compatible with Ricoh
Catalog Number DT-TR-C3500C
Availability Available in 24h
In stock 130 szt.
Yield 19000 pages
Cost per page 2.11 gr/strona
399,99 PLN
(325,20 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Black
Manufactured by DrTusz
Compatible with Samsung
Catalog Number DT-TS-1052
Availability Available in 24h
In stock 551 szt.
Yield 2500 pages
Cost per page 4.40 gr/strona
109,99 PLN
(89,42 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Cyan
Manufactured by DrTusz
Compatible with Sharp
Catalog Number DT-TSH-36C
Availability Available in 24h
In stock 120 szt.
Yield 15000 pages
Cost per page 1.53 gr/strona
229,99 PLN
(186,98 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Black
Manufactured by DrTusz
Compatible with Ricoh
Catalog Number DT-TR-SP277
Availability Available in 24h
In stock 2 szt.
Yield 2600 pages
Cost per page 7.11 gr/strona
184,99 PLN
(150,40 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Black
Manufactured by DrTusz
Compatible with Toshiba
Catalog Number DT-TT-409E
Availability Available in 24h
In stock 10 szt.
Yield 20000 pages
Cost per page 2.82 gr/strona
564,99 PLN
(459,34 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Black
Manufactured by DrTusz
Compatible with Canon
Catalog Number DT-TC-T08
Availability Available in 24h
In stock 164 szt.
Yield 11000 pages
Cost per page 3.64 gr/strona
399,99 PLN
(325,20 PLN netto)
 
Free Delivery
Category Laser Cartridges
Type Compatible
Class Toner
Color Black
Manufactured by DrTusz
Compatible with Kyocera
Catalog Number DT-TK-5205K
Availability Available in 24h
In stock 19 szt.
Yield 18000 pages
Cost per page 0.81 gr/strona
144,99 PLN
(117,88 PLN netto)
 
Free Delivery
1... 41  42  43  44  45  46  47 ... 283
Similar searches
dt-to-412s toner b412 3kdt-to-412s-toner-b412-3kdt to 412s-toner-b412-3k