--SELECT * FROM oc_setting WHERE store_id = '0' AND `key` LIKE 'einvoice%'
--SELECT * FROM oc_setting WHERE store_id = '0' AND `key` LIKE 'config_trendyol%'
--SELECT * FROM oc_setting WHERE store_id = '0' AND `key` LIKE 'config_trendyol%'
--SELECT * FROM oc_currency
--SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'payment' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '215' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3381') ORDER BY tr1.priority ASC
--SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '215' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3381') ORDER BY tr1.priority ASC
--SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
--SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'
--DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
--SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC
--SELECT `key`, `value`, `serialized` FROM oc_setting WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
--SHOW TABLES LIKE 'oc_blog_setting'
--SELECT * FROM oc_blog_setting
--SELECT DISTINCT * FROM oc_blog_category c LEFT JOIN oc_blog_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_blog_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '11' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
--SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'blog_article_id=112') AS keyword, (SELECT name FROM oc_blog_author at WHERE at.author_id = a.author_id) AS author FROM oc_blog_article a LEFT JOIN oc_blog_article_description ad ON (a.article_id = ad.article_id) LEFT JOIN oc_blog_article_to_store a2s ON (a.article_id = a2s.article_id) WHERE a.article_id = '112' AND ad.language_id = '1' AND a.status = '1' AND a.available <= '2024-11-21 14:13:21' AND a2s.store_id = '0'
--SELECT * FROM oc_blog_article_to_category a2c LEFT JOIN oc_blog_category_description cd ON (a2c.category_id = cd.category_id) LEFT JOIN oc_blog_category c ON (a2c.category_id = c.category_id) LEFT JOIN oc_blog_category_to_store c2s ON (a2c.category_id = c2s.category_id) WHERE a2c.article_id = '112' AND cd.language_id = '1' AND c.status = '1' AND c2s.store_id = '0'
--SELECT COUNT(*) AS total FROM oc_blog_comment c LEFT JOIN oc_blog_article a ON (c.article_id = a.article_id) WHERE a.article_id = '112' AND c.parent_id = '0' AND c.status = '1' AND a.status = '1' AND a.available <= '2024-11-21 14:13:21'
--SELECT COUNT(*) AS total FROM oc_blog_comment WHERE article_id = '112' AND parent_id != '0' AND status = '1'
--SELECT * FROM oc_blog_article_related ar LEFT JOIN oc_blog_article_description ad ON (ar.related_id = ad.article_id) LEFT JOIN oc_blog_article a ON (ar.related_id = a.article_id) LEFT JOIN oc_blog_article_to_store a2s ON (ar.related_id = a2s.article_id) WHERE ar.article_id = '112' AND a.status = '1' AND a.available <= '2024-11-21 14:13:21' AND ad.language_id = '1' AND a2s.store_id = '0'
--SELECT * FROM oc_blog_product_related bpr LEFT JOIN oc_product_to_store p2s ON (bpr.product_id = p2s.product_id) WHERE bpr.article_id = '112' AND p2s.store_id = '0'
--SELECT * FROM oc_blog_article_tag WHERE article_id = '112' AND language_id = '1'
--UPDATE oc_blog_article SET viewed = (viewed + 1) WHERE article_id = '112'
--SELECT * FROM oc_extension WHERE `type` = 'analytics'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '88651b379a5d4de2f7d6ca45f0590c03'
--SELECT * FROM oc_extension WHERE `type` = 'total'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '88651b379a5d4de2f7d6ca45f0590c03'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '88651b379a5d4de2f7d6ca45f0590c03'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '88651b379a5d4de2f7d6ca45f0590c03'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '88651b379a5d4de2f7d6ca45f0590c03'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '88651b379a5d4de2f7d6ca45f0590c03'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '88651b379a5d4de2f7d6ca45f0590c03'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '88651b379a5d4de2f7d6ca45f0590c03'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '88651b379a5d4de2f7d6ca45f0590c03'
--SELECT DISTINCT * FROM oc_currency WHERE code = '0'
--SELECT `keyword` FROM oc_url_alias WHERE language_id='1' AND query='blog/article'
--SELECT DISTINCT * FROM oc_currency WHERE code = '0'
--SELECT `keyword` FROM oc_url_alias WHERE language_id='2' AND query='blog/article'
--SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
--DELETE FROM `oc_customer_online` WHERE date_added < '2024-11-21 13:13:21'
--REPLACE INTO `oc_customer_online` SET `ip` = '3.145.91.111', `customer_id` = '0', `url` = 'http://www.yaziciyedekparca.com/index.php?article_id=112&blog_category_id=11&route=blog%2Farticle', `referer` = 'https://yaziciyedekparca.com/index.php?article_id=112&blog_category_id=11&route=blog%2Farticle', `date_added` = '2024-11-21 14:13:21'
--SELECT * FROM oc_layout_route WHERE 'blog/article' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
--SELECT * FROM oc_layout_module WHERE layout_id = '13' AND position = 'content_bottom' ORDER BY sort_order
--SELECT * FROM oc_layout_route WHERE 'blog/article' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
--SELECT * FROM oc_layout_module WHERE layout_id = '13' AND position = 'content_top' ORDER BY sort_order
--SELECT * FROM oc_layout_route WHERE 'blog/article' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
--SELECT * FROM oc_layout_module WHERE layout_id = '13' AND position = 'column_right' ORDER BY sort_order
--SELECT * FROM oc_layout_route WHERE 'blog/article' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
--SELECT * FROM oc_layout_module WHERE layout_id = '13' AND position = 'column_left' ORDER BY sort_order
--SELECT * FROM oc_blog_category c LEFT JOIN oc_blog_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_blog_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1' ORDER BY c.sort_order, LCASE(cd.name)
--SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
Yazıcı Parça Kodları

                                          LEXMARK MS811DN PARÇA KODLARI


Ref.Parça KoduTanım
140X7577Fırın data cable
240X7743MS81x İade Program Fırın Tip 00, 110-120V Letter
240X7744MS81x İade Program Fırın Tip 01, 220-240V A4
240X7745MS81x İade Program Fırın Tip 02, 100V A4
240X7581MS81x İade Program Fırın Tip 03, 110-120V A4
240X7734MS81x İade Program Fırın Tip 04, 220-240V Letter
240X8016MS81x Fırın Tip 05, 110-120V Letter
240X8017MS81x Fırın Tip 06, 220-240V A4
240X8018MS81x Fırın Tip 07, 100V A4
240X8019MS81x Fırın Tip 08, 110-120V A4
240X8020MS81x Fırın Tip 09, 220-240V Letter
240X8503MS71x İade Program Fırın Tip 11, 110-120V contact
240X8504MS71x İade Program Fırın Tip 13, 220-240V contact
240X8505MS71x İade Program Fırın Tip 15, 100V contact
240X8506MS71x Fırın Tip 17, 110v contact
240X8507MS71x Fırın Tip 19, 220v contact
240X8508MS71x Fırın Tip 21, 100v contact
Etiketler: kodları, parçaları, yazıcı, catalogue, parts, kodları, parça, fotokopi, kodu, parça, yazıcı Son Güncelleme: January 02, 2022
Whatsapp