Uygulamayı Mağazadan Edinebilirsiniz

MENÜ
1,00 Karat GÖRÜNÜMLÜ "H-I" RENK KORONET TEKTAŞ PIRLANTA KOLYE-14 Ayar Beyaz Altın - 15039-HI-030-14K
Kuyumcu Dükkanı’na hoşgeldiniz!

Ürün Özellikleri


  • Ürün Kodu: 15039-HI-030-14K
    Koronet Tektaş Kolyenizin taşlarını toplamı "0,30" Karat ağırlığında gerçek Pırlantadır.Fakat görüntüsü "1,00" Karat Pırlanta Görünümündedir
    Yani "0,30" Karat Fiyatı Ödeyip "1,00" Karat Görünümlü Kolye Satın Alıyorsunuz
  • Karat : 0,30 Ct
  • TasBerrak : SI
  • Maden : Altın
  • MadenAyari : 14 Ayar
  • MadenRengi : Beyaz
  • TasKesimi : Yuvarlak
  • TasRengi : H-I
  • Gram : 3,50 gr
  • YuzeyTipi : Parlak
  • ModelTipi : Spor
  • Tema : Aşk



    Ürün Açıklamaları
  • Siparişiniz en geç ​üç iş günü içinde kargoya teslim edilir.
  • Kargo ücretsizdir.
  • Siparişiniz anlaşmalı kargo şirketlerinde taşınırken çalınma, kaybolma ve hasar alma gibi ihtimallere karşın sigortalı ​olarak gönderilir.
  • Kuyumcu Dükkanı nda kişiye özel mücevherat tasarımı yapılabilmektedir.
  • Ürün tasarımıyla alakalı değişiklik taleplerinizi bize "Sipariş Notu" bölümüne yazarak iletebilirsiniz.
  • Ürün ​hemen hediye edilmeye uygun bir paketleme ile, özel ve şık kutusunda gönderilir.

    Kuyumcu Dükkanı, ​Aslaner Kuyumculuk​ markasıdır.

  • Yorum Yap

    Lütfen Yorum yazmak için oturum açın ya da kayıt olun.
    Satın almış olduğunuz ürüne yorum yapabilirsiniz.

    Sorunuzu ekleyin

    Lütfen Yorum yazmak için oturum açın ya da kayıt olun.

    1,00 Karat GÖRÜNÜMLÜ "H-I" RENK KORONET TEKTAŞ PIRLANTA KOLYE-14 Ayar Beyaz Altın - 15039-HI-030-14K

      Mağaza: KUYUMCU DÜKKANI
    • Görünümler: 73
    • Model kuyumcudukkani
    • Stok Durumu: Var
    • kargo ücreti: 0 TL.
    • 2.133,80 TL

    Mevcut Seçenekler:

    ETİKETLER: 1, 00, Karat, GÖRÜNÜMLÜ, "H-I", RENK, KORONET, TEKTAŞ, PIRLANTA, KOLYE-14, Ayar, Beyaz, Altın, -, 15039-HI-030-14K

    Queries: 124, Total time: 757.841 ms [By time] [By id] [By file]
    1 (0.284)
    SELECT `data`
    FROM `oc_session`
    WHERE session_id = '278d68f3366a91165c7771acea' AND expire > 1571537488
    /home/bpazar/public_html/system/library/session/db.php:21
    2 (0.061)
    SELECT *
    FROM oc_extension
    WHERE `type` = 'openbay'
    /home/bpazar/public_html/system/library/openbay.php:61
    3 (0.038)
    SELECT *
    FROM oc_extension
    WHERE `type` = 'openbay'
    /home/bpazar/public_html/system/library/openbay.php:61
    4 (0.153)
    SELECT `data`
    FROM `oc_session`
    WHERE session_id = 'ed2de9602cef8b002539f56c11' AND expire > 1571537488
    /home/bpazar/public_html/system/library/session/db.php:21
    5 (0.064)
    SELECT *
    FROM oc_store
    WHERE REPLACE(`ssl`, 'www.', '') = 'https://bpazar.com/'
    /home/bpazar/storage/modification/catalog/controller/startup/startup.php:7
    6 (0.620)
    SELECT *
    FROM `oc_setting`
    WHERE store_id = '0' OR store_id = '0'
    ORDER BY store_id ASC
    /home/bpazar/storage/modification/catalog/controller/startup/startup.php:26
    7 (0.076)
    SELECT *
    FROM oc_language
    WHERE status = '1'
    ORDER BY sort_order, name
    /home/bpazar/public_html/catalog/model/localisation/language.php:15
    8 (0.072)
    SELECT *
    FROM oc_currency
    /home/bpazar/storage/modification/system/library/cart/currency.php:10
    9 (0.067)
    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 = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '215' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3354')
    ORDER BY tr1.priority ASC
    /home/bpazar/public_html/system/library/cart/tax.php:16
    10 (0.059)
    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 = '3354')
    ORDER BY tr1.priority ASC
    /home/bpazar/public_html/system/library/cart/tax.php:44
    11 (0.069)
    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 = '3'
    /home/bpazar/public_html/system/library/cart/weight.php:10
    12 (0.071)
    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 = '3'
    /home/bpazar/public_html/system/library/cart/length.php:10
    13 (3.787)
    DELETE
    FROM oc_cart
    WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
    /home/bpazar/storage/modification/system/library/cart/cart.php:15
    14 (0.100)
    SELECT *
    FROM oc_extension
    WHERE `type` = 'openbay'
    /home/bpazar/public_html/system/library/openbay.php:61
    15 (0.111)
    SELECT *
    FROM `oc_event`
    WHERE `trigger` LIKE 'catalog/%' AND status = '1'
    ORDER BY `sort_order` ASC
    /home/bpazar/public_html/catalog/model/setting/event.php:4
    16 (0.734)
    SELECT DISTINCT *, pd.name AS name, p.image, p.price AS price, p.quantity, ctp.customer_id ,p.shipping_method , m.name AS manufacturer, (SELECT price
    FROM oc_product_discount pd2
    WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
    ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (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, (SELECT points
    FROM oc_product_reward pr
    WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
    FROM oc_stock_status ss
    WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
    FROM oc_weight_class_description wcd
    WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
    FROM oc_length_class_description lcd
    WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
    FROM oc_review r1
    WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
    FROM oc_review r2
    WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
    FROM oc_product p
    LEFT JOIN oc_customerpartner_to_product ctp ON (p.product_id = ctp.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)
    LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
    WHERE p.product_id = '1308313' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1034
    17 (0.127)
    SELECT category_id
    FROM oc_product_to_category
    WHERE product_id = '1308313'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1966
    18 (0.073)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '173'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    19 (0.070)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '204'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    20 (0.161)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '391'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    21 (0.148)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '2825'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    22 (0.389)
    show tables like "oc\_journal2\_config"
    /home/bpazar/public_html/system/journal2/startup.php:154
    23 (0.128)
    SELECT *
    FROM oc_journal2_config
    WHERE store_id = '0' OR store_id = -1
    /home/bpazar/public_html/catalog/model/journal2/db.php:7
    24 (1.749)
    SELECT *
    FROM oc_journal2_settings
    WHERE `theme_id` = '13'
    /home/bpazar/public_html/system/journal2/classes/journal2_skin.php:111
    25 (0.134)
    SELECT parent_id
    FROM oc_journal2_skins
    WHERE `skin_id` = '13'
    /home/bpazar/public_html/system/journal2/classes/journal2_skin.php:195
    26 (0.182)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '1308313' AND store_id = '0'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1952
    27 (0.079)
    SELECT *
    FROM oc_layout_route
    WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
    ORDER BY route DESC LIMIT 1
    /home/bpazar/public_html/catalog/model/design/layout.php:13
    28 (0.061)
    SELECT *
    FROM oc_layout_module
    WHERE layout_id = '2' AND position = 'column_left'
    ORDER BY sort_order
    /home/bpazar/public_html/catalog/model/design/layout.php:23
    29 (0.062)
    SELECT *
    FROM oc_layout_module
    WHERE layout_id = '2' AND position = 'column_right'
    ORDER BY sort_order
    /home/bpazar/public_html/catalog/model/design/layout.php:23
    30 (0.093)
    SELECT viewed
    FROM oc_product
    WHERE product_id = '1308313'
    /home/bpazar/public_html/catalog/model/journal2/product.php:134
    31 (0.213)
    SELECT Count(*) AS 'viewed'
    FROM oc_view_by_day
    WHERE product_id = '1308313' AND date >= CURDATE() - INTERVAL 1 DAY AND date < CURDATE() + INTERVAL 1 DAY
    /home/bpazar/public_html/catalog/model/journal2/product.php:144
    32 (0.175)
    SELECT sum(op.quantity) as quantity
    FROM `oc_order_product` op
    LEFT JOIN `oc_order` o ON op.order_id = o.order_id
    WHERE o.order_status_id <> 0 AND op.product_id = '1308313'
    /home/bpazar/public_html/catalog/model/journal2/product.php:149
    33 (0.629)
    SELECT DISTINCT *, pd.name AS name, p.image, p.price AS price, p.quantity, ctp.customer_id ,p.shipping_method , m.name AS manufacturer, (SELECT price
    FROM oc_product_discount pd2
    WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
    ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (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, (SELECT points
    FROM oc_product_reward pr
    WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
    FROM oc_stock_status ss
    WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
    FROM oc_weight_class_description wcd
    WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
    FROM oc_length_class_description lcd
    WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
    FROM oc_review r1
    WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
    FROM oc_review r2
    WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
    FROM oc_product p
    LEFT JOIN oc_customerpartner_to_product ctp ON (p.product_id = ctp.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)
    LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
    WHERE p.product_id = '1308313' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1034
    34 (0.097)
    SELECT category_id
    FROM oc_product_to_category
    WHERE product_id = '1308313'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1966
    35 (0.043)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '173'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    36 (0.039)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '204'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    37 (0.033)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '391'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    38 (0.034)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '2825'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    39 (0.075)
    SELECT manufacturer_id
    FROM oc_product
    WHERE product_id = 1308313
    /home/bpazar/public_html/catalog/model/journal2/module.php:16
    40 (0.418)
    SELECT category_id
    FROM oc_product_to_category
    WHERE product_id = 1308313
    /home/bpazar/public_html/catalog/model/journal2/module.php:24
    41 (0.065)
    SELECT *
    FROM oc_journal2_modules
    WHERE module_type = "journal2_product_tabs"
    /home/bpazar/public_html/catalog/model/journal2/module.php:31
    42 (0.035)
    SELECT *
    FROM oc_journal2_modules
    WHERE module_type = "journal2_product_tabs"
    /home/bpazar/public_html/catalog/model/journal2/module.php:90
    43 (0.032)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '1308313' AND store_id = '0'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1952
    44 (0.059)
    SELECT *
    FROM oc_layout_route
    WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
    ORDER BY route DESC LIMIT 1
    /home/bpazar/public_html/catalog/model/design/layout.php:13
    45 (0.057)
    SELECT *
    FROM oc_layout_module
    WHERE layout_id = '2' AND position = 'top'
    ORDER BY sort_order
    /home/bpazar/public_html/catalog/model/design/layout.php:23
    46 (0.059)
    SELECT *
    FROM oc_layout_module
    WHERE layout_id = '2' AND position = 'bottom'
    ORDER BY sort_order
    /home/bpazar/public_html/catalog/model/design/layout.php:23
    47 (0.055)
    SELECT *
    FROM oc_layout_module
    WHERE layout_id = '2' AND position = 'header'
    ORDER BY sort_order
    /home/bpazar/public_html/catalog/model/design/layout.php:23
    48 (0.087)
    SELECT *
    FROM oc_layout_module
    WHERE layout_id = '2' AND position = 'footer'
    ORDER BY sort_order
    /home/bpazar/public_html/catalog/model/design/layout.php:23
    49 (0.124)
    SELECT DISTINCT *
    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 i.information_id = '4' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
    /home/bpazar/public_html/catalog/model/catalog/information.php:4
    50 (0.123)
    SELECT DISTINCT *
    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 i.information_id = '9' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
    /home/bpazar/public_html/catalog/model/catalog/information.php:4
    51 (0.327)
    SELECT DISTINCT *
    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 i.information_id = '10' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
    /home/bpazar/public_html/catalog/model/catalog/information.php:4
    52 (0.109)
    SELECT DISTINCT *
    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 i.information_id = '5' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
    /home/bpazar/public_html/catalog/model/catalog/information.php:4
    53 (0.112)
    SELECT DISTINCT *
    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 i.information_id = '3' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
    /home/bpazar/public_html/catalog/model/catalog/information.php:4
    54 (0.093)
    SELECT DISTINCT *
    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 i.information_id = '11' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
    /home/bpazar/public_html/catalog/model/catalog/information.php:4
    55 (0.085)
    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 = '256' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
    /home/bpazar/public_html/catalog/model/catalog/category.php:4
    56 (0.079)
    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 = '267' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
    /home/bpazar/public_html/catalog/model/catalog/category.php:4
    57 (0.079)
    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 = '212' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
    /home/bpazar/public_html/catalog/model/catalog/category.php:4
    58 (0.079)
    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 = '223' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
    /home/bpazar/public_html/catalog/model/catalog/category.php:4
    59 (0.072)
    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 = '884' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
    /home/bpazar/public_html/catalog/model/catalog/category.php:4
    60 (0.075)
    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 = '202' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
    /home/bpazar/public_html/catalog/model/catalog/category.php:4
    61 (0.072)
    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 = '177' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
    /home/bpazar/public_html/catalog/model/catalog/category.php:4
    62 (0.627)
    SELECT DISTINCT *, pd.name AS name, p.image, p.price AS price, p.quantity, ctp.customer_id ,p.shipping_method , m.name AS manufacturer, (SELECT price
    FROM oc_product_discount pd2
    WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
    ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (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, (SELECT points
    FROM oc_product_reward pr
    WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
    FROM oc_stock_status ss
    WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
    FROM oc_weight_class_description wcd
    WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
    FROM oc_length_class_description lcd
    WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
    FROM oc_review r1
    WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
    FROM oc_review r2
    WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
    FROM oc_product p
    LEFT JOIN oc_customerpartner_to_product ctp ON (p.product_id = ctp.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)
    LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
    WHERE p.product_id = '1308313' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1034
    63 (0.085)
    SELECT category_id
    FROM oc_product_to_category
    WHERE product_id = '1308313'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1966
    64 (0.078)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '173'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    65 (0.076)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '204'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    66 (0.078)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '391'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    67 (0.076)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '2825'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    68 (0.201)
    SELECT COUNT(*) AS total
    FROM oc_review r
    LEFT JOIN oc_product p ON (r.product_id = p.product_id)
    LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
    WHERE p.product_id = '1308313' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '3'
    /home/bpazar/storage/modification/catalog/model/catalog/review.php:69
    69 (0.161)
    SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added
    FROM oc_review r
    LEFT JOIN oc_product p ON (r.product_id = p.product_id)
    LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
    WHERE p.product_id = '1308313' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '3'
    ORDER BY r.date_added DESC LIMIT 0,5
    /home/bpazar/storage/modification/catalog/model/catalog/review.php:63
    70 (0.717)
    SELECT DISTINCT *, pd.name AS name, p.image, p.price AS price, p.quantity, ctp.customer_id ,p.shipping_method , m.name AS manufacturer, (SELECT price
    FROM oc_product_discount pd2
    WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
    ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (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, (SELECT points
    FROM oc_product_reward pr
    WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
    FROM oc_stock_status ss
    WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
    FROM oc_weight_class_description wcd
    WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
    FROM oc_length_class_description lcd
    WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
    FROM oc_review r1
    WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
    FROM oc_review r2
    WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
    FROM oc_product p
    LEFT JOIN oc_customerpartner_to_product ctp ON (p.product_id = ctp.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)
    LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
    WHERE p.product_id = '1308313' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1034
    71 (0.074)
    SELECT category_id
    FROM oc_product_to_category
    WHERE product_id = '1308313'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1966
    72 (0.072)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '173'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    73 (0.073)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '204'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    74 (0.070)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '391'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    75 (0.069)
    SELECT cp.category_id, cp.path_id, cp.level, c.dc
    FROM oc_category_path AS cp
    LEFT JOIN oc_category AS c ON (c.category_id = cp.category_id)
    WHERE c.dc>0 AND c.category_id = '2825'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2000
    76 (0.102)
    SELECT c2c.*, c.*,c.firstname,c.lastname,co.name as country, a.address_1, a.address_2, a.city, a.postcode, a.country_id, a.zone_id, a.custom_field
    FROM oc_customerpartner_to_customer c2c
    LEFT JOIN oc_customer c ON (c2c.customer_id = c.customer_id)
    LEFT JOIN oc_address a ON (c.address_id = a.address_id)
    LEFT JOIN oc_country co ON (c2c.country = co.iso_code_2)
    WHERE c2c.customer_id = '1442' AND c2c.is_partner = '1' AND c.status = '1'
    /home/bpazar/public_html/catalog/model/customerpartner/master.php:120
    77 (0.134)
    SELECT *
    FROM oc_product_to_category
    WHERE product_id = '1308313'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1960
    78 (0.179)
    SELECT *
    FROM oc_product_to_category AS ptc
    LEFT JOIN oc_category_description AS cd ON (ptc.category_id = cd.category_id)
    WHERE ptc.product_id = '1308313' AND language_id = '3'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2006
    79 (0.089)
    SELECT *
    FROM oc_manufacturer m
    LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
    WHERE m.manufacturer_id = '0' AND m2s.store_id = '0'
    /home/bpazar/public_html/catalog/model/catalog/manufacturer.php:4
    80 (0.222)
    SELECT *
    FROM oc_product_image
    WHERE product_id = '1308313'
    ORDER BY sort_order ASC
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1939
    81 (0.169)
    SELECT *
    FROM oc_product_discount
    WHERE product_id = '1308313' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
    ORDER BY quantity ASC, priority ASC, price ASC
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1935
    82 (0.436)
    SELECT *
    FROM oc_product_option po
    LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
    LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
    WHERE po.product_id = '1308313' AND od.language_id = '3'
    ORDER BY o.sort_order
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1884
    83 (0.926)
    SELECT *
    FROM oc_product_option_value pov
    LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
    LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
    WHERE pov.product_id = '1308313' AND pov.product_option_id = '3349215' AND ovd.language_id = '3'
    ORDER BY ov.sort_order
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1887
    84 (0.181)
    SELECT ag.attribute_group_id, agd.name
    FROM oc_product_attribute pa
    LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
    LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
    LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
    WHERE pa.product_id = '1308313' AND agd.language_id = '3' GROUP BY ag.attribute_group_id
    ORDER BY ag.sort_order, agd.name
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1863
    85 (0.950)
    SELECT *
    FROM oc_product_related pr
    LEFT JOIN oc_product p ON (pr.related_id = p.product_id)
    LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
    WHERE pr.product_id = '1308313' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1945
    86 (0.169)
    SELECT product_id
    FROM oc_customerpartner_to_product
    WHERE product_id = '1308313' AND customer_id = '0'
    /home/bpazar/public_html/catalog/model/account/customerpartner.php:28
    87 (0.111)
    SELECT fieldId
    FROM oc_wk_custom_field_product
    WHERE productId = '1308313'
    /home/bpazar/public_html/catalog/model/account/customerpartner.php:3385
    88 (0.071)
    SELECT product_id
    FROM oc_customerpartner_to_product
    WHERE product_id = '1308313' AND customer_id = '0'
    /home/bpazar/public_html/catalog/model/account/customerpartner.php:28
    89 (0.138)
    SELECT rd.*
    FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 3 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id
    WHERE pr.product_id = 1308313 AND status = '1' AND pr.customer_group_id = '1'
    ORDER BY sort_order ASC
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:2173
    90 (734.854)
    UPDATE oc_product SET viewed = (viewed + 1)
    WHERE product_id = '1308313'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1009
    91 (0.171)
    INSERT INTO oc_view_by_day (customer_id,date,product_id) VALUES ( 0, '2019-10-20 02:11', 1308313)
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1013
    92 (0.094)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '1308313' AND store_id = '0'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1952
    93 (0.101)
    SELECT *
    FROM oc_layout_route
    WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
    ORDER BY route DESC LIMIT 1
    /home/bpazar/public_html/catalog/model/design/layout.php:13
    94 (0.065)
    SELECT *
    FROM oc_layout_module
    WHERE layout_id = '2' AND position = 'column_left'
    ORDER BY sort_order
    /home/bpazar/public_html/catalog/model/design/layout.php:23
    95 (0.063)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '1308313' AND store_id = '0'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1952
    96 (0.061)
    SELECT *
    FROM oc_layout_route
    WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
    ORDER BY route DESC LIMIT 1
    /home/bpazar/public_html/catalog/model/design/layout.php:13
    97 (0.063)
    SELECT *
    FROM oc_layout_module
    WHERE layout_id = '2' AND position = 'column_right'
    ORDER BY sort_order
    /home/bpazar/public_html/catalog/model/design/layout.php:23
    98 (0.085)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '1308313' AND store_id = '0'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1952
    99 (0.084)
    SELECT *
    FROM oc_layout_route
    WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
    ORDER BY route DESC LIMIT 1
    /home/bpazar/public_html/catalog/model/design/layout.php:13
    100 (0.081)
    SELECT *
    FROM oc_layout_module
    WHERE layout_id = '2' AND position = 'content_top'
    ORDER BY sort_order
    /home/bpazar/public_html/catalog/model/design/layout.php:23
    101 (0.068)
    SELECT *
    FROM oc_product_to_layout
    WHERE product_id = '1308313' AND store_id = '0'
    /home/bpazar/storage/modification/catalog/model/catalog/product.php:1952
    102 (0.065)
    SELECT *
    FROM oc_layout_route
    WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
    ORDER BY route DESC LIMIT 1
    /home/bpazar/public_html/catalog/model/design/layout.php:13
    103 (0.073)
    SELECT *
    FROM oc_layout_module
    WHERE layout_id = '2' AND position = 'content_bottom'
    ORDER BY sort_order
    /home/bpazar/public_html/catalog/model/design/layout.php:23
    104 (0.390)
    DELETE
    FROM `oc_customer_online`
    WHERE date_added < '2019-10-20 01:11:29'
    /home/bpazar/public_html/catalog/model/tool/online.php:4
    105 (0.074)
    REPLACE INTO `oc_customer_online` SET `ip` = '18.207.134.98', `customer_id` = '0', `url` = 'https://www.bpazar.com/Saat-Mucevher-Taki/1,00-karat-gorunumlu-quot;h-i-quot;-renk-koronet-tektas-pirlanta-kolye-14-ayar-beyaz-altin-15039-hi-030-14k/1308313', `referer` = '', `date_added` = '2019-10-20 02:11:29'
    /home/bpazar/public_html/catalog/model/tool/online.php:6
    106 (0.047)
    SELECT *
    FROM oc_extension
    WHERE `type` = 'analytics'
    /home/bpazar/public_html/catalog/model/setting/extension.php:4
    107 (0.085)
    SELECT *
    FROM oc_customerpartner_to_customer
    WHERE customer_id = '0'
    /home/bpazar/public_html/catalog/model/account/customerpartner.php:1457
    108 (0.075)
    SELECT *
    FROM oc_customerpartner_to_customer
    WHERE customer_id = '0'
    /home/bpazar/public_html/catalog/model/account/customerpartner.php:1457
    109 (0.089)
    SELECT *
    FROM oc_language
    WHERE status = '1'
    ORDER BY sort_order, name
    /home/bpazar/public_html/catalog/model/localisation/language.php:15
    110 (0.071)
    SELECT *
    FROM oc_pointsvalues
    /home/bpazar/storage/modification/system/library/cart/cart.php:144
    111 (0.247)
    SELECT *
    FROM oc_cart
    WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ed2de9602cef8b002539f56c11'
    ORDER BY seller_id ASC
    /home/bpazar/storage/modification/system/library/cart/cart.php:147
    112 (0.048)
    SELECT *
    FROM oc_extension
    WHERE `type` = 'total'
    /home/bpazar/public_html/catalog/model/setting/extension.php:4
    113 (0.070)
    SELECT *
    FROM oc_pointsvalues
    /home/bpazar/storage/modification/system/library/cart/cart.php:144
    114 (0.073)
    SELECT *
    FROM oc_cart
    WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ed2de9602cef8b002539f56c11'
    ORDER BY seller_id ASC
    /home/bpazar/storage/modification/system/library/cart/cart.php:147
    115 (0.078)
    SELECT *
    FROM oc_pointsvalues
    /home/bpazar/storage/modification/system/library/cart/cart.php:144
    116 (0.077)
    SELECT *
    FROM oc_cart
    WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ed2de9602cef8b002539f56c11'
    ORDER BY seller_id ASC
    /home/bpazar/storage/modification/system/library/cart/cart.php:147
    117 (0.078)
    SELECT SUM(amount) AS total
    FROM oc_customer_transaction
    WHERE customer_id = '0'
    /home/bpazar/storage/modification/system/library/cart/customer.php:122
    118 (0.073)
    SELECT *
    FROM oc_pointsvalues
    /home/bpazar/storage/modification/system/library/cart/cart.php:144
    119 (0.069)
    SELECT *
    FROM oc_cart
    WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ed2de9602cef8b002539f56c11'
    ORDER BY seller_id ASC
    /home/bpazar/storage/modification/system/library/cart/cart.php:147
    120 (0.072)
    SELECT *
    FROM oc_pointsvalues
    /home/bpazar/storage/modification/system/library/cart/cart.php:144
    121 (0.068)
    SELECT *
    FROM oc_cart
    WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ed2de9602cef8b002539f56c11'
    ORDER BY seller_id ASC
    /home/bpazar/storage/modification/system/library/cart/cart.php:147
    122 (0.114)
    SELECT *
    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 = '0' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
    ORDER BY c.sort_order, LCASE(cd.name)
    /home/bpazar/public_html/catalog/model/catalog/category.php:11
    123 (0.118)
    SELECT *
    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 = '59' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
    ORDER BY c.sort_order, LCASE(cd.name)
    /home/bpazar/public_html/catalog/model/catalog/category.php:11
    124 (0.108)
    SELECT *
    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 = '69' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
    ORDER BY c.sort_order, LCASE(cd.name)
    /home/bpazar/public_html/catalog/model/catalog/category.php:11