--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_url_alias WHERE keyword = 'hp-laserjet-pro-500-colorm570-adf-mentesesi' ORDER BY language_id ASC
--SELECT language_id,code FROM oc_language WHERE language_id = '1'
--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 * FROM oc_url_alias WHERE keyword = 'hp-laserjet-pro-500-colorm570-adf-mentesesi' AND language_id='1'
--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%'
--SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '14440' AND cd.language_id = '1' AND c.status = '1'
--SELECT cd.name,c.category_id,top,hizli_arama,`column` FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '14440' AND cd.language_id = '1' AND c.status = '1' ORDER BY c.sort_order ASC
--SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2s.store_id = '0' AND p2c.category_id = '14440'
--SELECT p.product_id,p.minimum,p.ean,p.quality,p.price,p.bildirim,p.tax_class_id,p.location, pd.name AS name, p.image, p.date_modified,p.quantity, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.sort_order FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '14440' ORDER BY p.quantity DESC, LCASE(pd.name) DESC LIMIT 0,48
--SELECT * FROM oc_category_to_layout WHERE category_id = '14440' AND store_id = '0'
--SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
--SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
--SELECT * FROM oc_module WHERE module_id = '22'
--SELECT p.product_id,p.minimum,p.ean,p.quality,p.price,p.bildirim,p.tax_class_id,p.location, pd.name AS name, p.image, p.date_modified,p.quantity, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' ORDER BY p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,6
--SELECT * FROM oc_module WHERE module_id = '21'
--SELECT * FROM oc_module WHERE module_id = '23'
--SELECT DISTINCT ps.product_id, (SELECT AVG(rating) FROM oc_review r1 WHERE r1.product_id = ps.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating FROM oc_product_special ps LEFT JOIN oc_product p ON (ps.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id ORDER BY LCASE(pd.name) ASC, LCASE(pd.name) ASC LIMIT 0,3
--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:45:28'
--REPLACE INTO `oc_customer_online` SET `ip` = '18.223.237.246', `customer_id` = '0', `url` = 'http://yaziciyedekparca.com/hp-laserjet-pro-500-colorm570-adf-mentesesi', `referer` = '', `date_added` = '2024-11-21 14:45:28'
--SELECT * FROM oc_extension WHERE `type` = 'analytics'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd6a6c34f2fdae4300f86e4ed25631b32'
--SELECT * FROM oc_extension WHERE `type` = 'total'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd6a6c34f2fdae4300f86e4ed25631b32'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd6a6c34f2fdae4300f86e4ed25631b32'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd6a6c34f2fdae4300f86e4ed25631b32'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd6a6c34f2fdae4300f86e4ed25631b32'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd6a6c34f2fdae4300f86e4ed25631b32'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd6a6c34f2fdae4300f86e4ed25631b32'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd6a6c34f2fdae4300f86e4ed25631b32'
--SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd6a6c34f2fdae4300f86e4ed25631b32'
--SELECT DISTINCT * FROM oc_currency WHERE code = '0'
--SELECT `keyword` FROM oc_url_alias WHERE language_id='1' AND query='category_id=14440'
--SELECT DISTINCT * FROM oc_currency WHERE code = '0'
--SELECT `keyword` FROM oc_url_alias WHERE language_id='2' AND query='category_id=14440'
--select path_id from oc_category_path WHERE category_id='14440'
--SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '2' AND cd.language_id = '1' AND c.status = '1'
--SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '278' AND cd.language_id = '1' AND c.status = '1'
--SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '14440' AND cd.language_id = '1' AND c.status = '1'
Hp Laserjet Pro 500 Color MFP M570
Muadil Ürün
Hp Laserjet Enterprise Pro 500 MFP M570dn ADF Menteşesi Sağ ve Sol Aynı

Hp Laserjet Enterprise Pro 500 MFP M570dn ADF Menteşesi Sağ ve Sol Aynı

248,39₺ KDV Dahil Vergiler Hariç: 206,99₺

Yükleniyor…

Whatsapp