Uygulamayı Mağazadan Edinebilirsiniz

MENÜ
Son 24 saatte 4 kişi bu ürüne baktı.
Lady Moda Home Çift Kişilik Yatak Örtüsü - Sarı


Lady Moda Home Çift Kişilik Pike & Yatak Örtüsü & Dekoratif Örtü  - Sarı

 

Çok amaçlı kullanım sağlayan ürünümüz, pike, yatak örtüsü, dekoratif örtü gibi kullanım alanları ile evlerinize yepyeni bir tarz katacak. Ürünümüz 1. kalite %100 organik pamuk ipliğinden üretilmiştir. Dayanıklığı ve kırışmayan yapısıyla uzun yıllar kullanabileceğiniz pikelerimiz hızlı kurur, kolay ütülenebilir. Ultra yumuşak yapısı ile rahat bir uyku konforu sağlamaktadır. Bakımı kolaydır. Hafiftir. Hava geçirgenliği mevcuttur. Avrupa standartlarında boya kalitesi ile onlarca yıkamadan sonra dahi solmadan ve ilk günkü gibi yıpranmadan kullanın. Terletme yapmaz.  Ürünümüz Çift Kişiliktir. Ürün Boyutu: 200x230cm

*** Görseldeki çarşaf, yastık ve yastık kılıfı dahil değildir. ***

  • Türkiye'nin her bölgesine ücretsiz kargo.
  • Hafta içi (Pazartesi, Salı, Çarşamba, Perşembe, Cuma) günleri saat 16:00' a kadar verilen siparişleriniz, aynı gün kargoya verilir.
  • Cumartesi günü saat 12:00' a kadar verilen siparişleriniz, aynı gün kargoya verilir.
  • Cumartesi 12:00' dan sonraki ve Pazar tüm gün verilen siparişleriniz, Pazartesi günü kargoya verilir.

  • Elde veya çamaşır makinesinde, bol ve ılık suda yıkayınız.
  • Çamaşır suyu kullanmayınız.
  • Ilık ütü ile ütüleyiniz.
  • Kurutma makinesinde kurutabilirsiniz.
  • Kuru temizleme yapmayınız.

  • Satın aldığınız ürünü, ürünün tekrar satılabilirlik özelliğini kaybetmemiş ve kullanılmamış olması koşuluyla iade etmek/değiştirmek için faturamızın arka yüzeyindeki formu doldurarak, ürün/ürünlerinizi teslim aldığınız tarihten itibaren 14 gün içerisinde göndermelisiniz.
  • 14 günlük iade/değişim süresi dolmuş olan, kullanımış ve tekrar satılabilirlik özelliğini kaybetmiş olan ürünler iade/değişim olarak kabul edilmeyecek ve kargo masrafları size ait olmak üzere geri gönderilecektir.
  • İade/değişim kargonuz bize ulaştığında size e-mail yada telefon yoluyla bilgi verilecek, 24 saat içerisinde iade/değişim işleminiz gerçekleştirilecektir.
  • İade/değişim işleminiz tamamlandığında size e-mail yada telefon yoluyla bilgi verilecektir.

1950 Yılında İtimat Manifatura olarak Aydın ili Nazilli ilçesinde kurulan firmamız 2002 yılına kadar manifatura sektöründe faaliyet göstermiştir. Manifatura sektöründe birçok kumaş çeşidi ile toptan ve perakende satışlarda hizmet veren firmamız 2002 yılında kapasitesini arttırmak için tekstilin başkenti Denizli ilinde yerleşik olarak hizmet vermeye başladı.
2003 yılında 500m2 kapalı alanda manifatura grubu, stok ve ihraç ev tekstil ürünlerini tüm Türkiye pazarına açıp sektörde önemli bir pazar payına ulaştı. Menderes Tekstil , Zorlu Tekstil ve daha bir çok tekstil firmasının stok ve ihraç fazlası ürünlerini, hizmet vermiş olduğu tüm bölgelere dağıtımını gerçekleştirdi.
2003 – 2008 yılları arasında bayi ağlarını genişleten firmamız 2009 yılında ihracat birimini oluşturup ilk ihracatını Afrika bölgesine gerçekleştirdi ve ihracat yapan bir firma haline geldi. Günümüzde çeşitli dünya ülkelerine yüklü miktarlarda ev tekstil ürünleri ihracatını gerçekleştirmektedir.
İhracat girişimlerini başarı ile sürdüren firmamız 2010 yılında sektör yatırımlarına ağırlık vererek 2500 m2 kapalı alanda fason üretim faaliyetlerini başlattı. Yurtiçi ve yurtdışı birçok firmaya fason üretim konusunda hizmet veren bir firma haline geldi.
2017 yılında üretim bandını genişleterek daha iyi hizmet verebilmek için Çiçekçi Tekstil A.Ş firmasını kurdu ve manifatura ile ev tekstil faaliyetlerini ayırdı. Her iki sektörde de hızlı bir şekilde ilerleyen firmamız marka oluşumuna giderek Lady Moda – Flanel – Kırmızı Home markalarını oluşturdu.
Oluşturmuş olduğu markalar ile birçok ulusal market zincirlerine ev tekstil ürünlerinin üretimini ve satışını gerçekleştirmekte ve günümüze ise Lady Moda markası ile kendi koleksiyonunu hazırlayan firmamız 12.000 m2 kapalı alanda, 120 çalışanı ve 68 yıllık tecrübesi ile aylık 80.000 adet üretim kapasiteli bir tesis haline gelmiştir. Başlıca müşterilerimiz arasında Zorlu, Soley, Marie Claire, Firstchoice ve BİM zincir mağazaları bulunmaktadır. Ürünlerini dünya pazarına da açan firmamız, Italya, Danimarka, Hollanda, Almanya, Yunanistan, Hırvatistan, Sırbistan, Arabistan ve Afrika ülkelerine ihracat yapmaktadı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.

Lady Moda Home Çift Kişilik Yatak Örtüsü - Sarı

    Mağaza: LADY MODA
  • Görünümler: 220
  • Model LadyModa
  • Stok Durumu: Var
  • kargo ücreti: 0 TL.
  • 58,81 TL

Mevcut Seçenekler:

ETİKETLER: Lady, Moda, Home, Çift, Kişilik, Yatak, Örtüsü, -, Sarı

Queries: 120, Total time: 20.770 ms [By time] [By id] [By file]
1 (0.186)
SELECT `data`
FROM `oc_session`
WHERE session_id = '7eec1198523ed35646b78d63e9' AND expire > 1569030246
/home/bpazar/public_html/system/library/session/db.php:21
2 (0.066)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/bpazar/public_html/system/library/openbay.php:61
3 (0.067)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/bpazar/public_html/system/library/openbay.php:61
4 (0.135)
SELECT `data`
FROM `oc_session`
WHERE session_id = '3acd42d294545cd1bb44457e6b' AND expire > 1569030246
/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.644)
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.086)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/bpazar/public_html/catalog/model/localisation/language.php:15
8 (0.076)
SELECT *
FROM oc_currency
/home/bpazar/storage/modification/system/library/cart/currency.php:10
9 (0.064)
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.068)
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.067)
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.454)
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.067)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/bpazar/public_html/system/library/openbay.php:61
15 (0.084)
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.690)
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 = '947188' 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:1035
17 (0.143)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '947188'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1973
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 = '170'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2007
19 (0.071)
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 = '237'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2007
20 (0.130)
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 = '889'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2007
21 (0.394)
show tables like "oc\_journal2\_config"
/home/bpazar/public_html/system/journal2/startup.php:154
22 (0.091)
SELECT *
FROM oc_journal2_config
WHERE store_id = '0' OR store_id = -1
/home/bpazar/public_html/catalog/model/journal2/db.php:7
23 (1.751)
SELECT *
FROM oc_journal2_settings
WHERE `theme_id` = '13'
/home/bpazar/public_html/system/journal2/classes/journal2_skin.php:111
24 (0.093)
SELECT parent_id
FROM oc_journal2_skins
WHERE `skin_id` = '13'
/home/bpazar/public_html/system/journal2/classes/journal2_skin.php:195
25 (0.162)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '947188' AND store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1958
26 (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
27 (0.059)
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
28 (0.067)
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
29 (0.130)
SELECT viewed
FROM oc_product
WHERE product_id = '947188'
/home/bpazar/public_html/catalog/model/journal2/product.php:134
30 (0.377)
SELECT Count(*) AS 'viewed'
FROM oc_view_by_day
WHERE product_id = '947188' AND date >= CURDATE() - INTERVAL 1 DAY AND date < CURDATE() + INTERVAL 1 DAY
/home/bpazar/public_html/catalog/model/journal2/product.php:144
31 (0.233)
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 = '947188'
/home/bpazar/public_html/catalog/model/journal2/product.php:149
32 (0.622)
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 = '947188' 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:1035
33 (0.070)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '947188'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1973
34 (0.084)
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 = '170'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2007
35 (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 = '237'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2007
36 (0.068)
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 = '889'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2007
37 (0.102)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = 947188
/home/bpazar/public_html/catalog/model/journal2/module.php:16
38 (0.105)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = 947188
/home/bpazar/public_html/catalog/model/journal2/module.php:24
39 (0.083)
SELECT *
FROM oc_journal2_modules
WHERE module_type = "journal2_product_tabs"
/home/bpazar/public_html/catalog/model/journal2/module.php:31
40 (0.071)
SELECT *
FROM oc_journal2_modules
WHERE module_type = "journal2_product_tabs"
/home/bpazar/public_html/catalog/model/journal2/module.php:90
41 (0.069)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '947188' AND store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1958
42 (0.062)
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
43 (0.062)
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
44 (0.062)
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
45 (0.062)
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
46 (0.050)
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
47 (0.118)
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
48 (0.111)
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
49 (0.306)
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
50 (0.090)
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
51 (0.071)
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
52 (0.090)
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
53 (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
54 (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 = '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
55 (0.071)
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
56 (0.071)
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
57 (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
58 (0.071)
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
59 (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 = '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
60 (0.777)
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 = '947188' 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:1035
61 (0.040)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '947188'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1973
62 (0.068)
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 = '170'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2007
63 (0.067)
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 = '237'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2007
64 (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 = '889'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2007
65 (0.230)
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 = '947188' 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
66 (0.191)
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 = '947188' 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
67 (0.682)
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 = '947188' 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:1035
68 (0.072)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '947188'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1973
69 (0.071)
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 = '170'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2007
70 (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 = '237'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2007
71 (0.071)
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 = '889'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2007
72 (0.322)
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 = '2323' AND c2c.is_partner = '1' AND c.status = '1'
/home/bpazar/public_html/catalog/model/customerpartner/master.php:120
73 (0.132)
SELECT *
FROM oc_product_to_category
WHERE product_id = '947188'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1966
74 (0.170)
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 = '947188' AND language_id = '3'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2013
75 (0.075)
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
76 (0.167)
SELECT *
FROM oc_product_image
WHERE product_id = '947188'
ORDER BY sort_order ASC
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1945
77 (0.181)
SELECT *
FROM oc_product_discount
WHERE product_id = '947188' 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:1941
78 (0.355)
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 = '947188' AND od.language_id = '3'
ORDER BY o.sort_order
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1888
79 (0.516)
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 = '947188' AND pov.product_option_id = '1228402' AND ovd.language_id = '3'
ORDER BY ov.sort_order
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1891
80 (0.179)
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 = '947188' 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:1867
81 (0.131)
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 = '947188' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1951
82 (0.161)
SELECT product_id
FROM oc_customerpartner_to_product
WHERE product_id = '947188' AND customer_id = '0'
/home/bpazar/public_html/catalog/model/account/customerpartner.php:28
83 (0.044)
SELECT fieldId
FROM oc_wk_custom_field_product
WHERE productId = '947188'
/home/bpazar/public_html/catalog/model/account/customerpartner.php:3348
84 (0.064)
SELECT product_id
FROM oc_customerpartner_to_product
WHERE product_id = '947188' AND customer_id = '0'
/home/bpazar/public_html/catalog/model/account/customerpartner.php:28
85 (0.114)
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 = 947188 AND status = '1' AND pr.customer_group_id = '1'
ORDER BY sort_order ASC
/home/bpazar/storage/modification/catalog/model/catalog/product.php:2180
86 (0.137)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '947188'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1010
87 (0.098)
INSERT INTO oc_view_by_day (customer_id,date,product_id) VALUES ( 0, '2019-09-21 01:44', 947188)
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1014
88 (0.041)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '947188' AND store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1958
89 (0.032)
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
90 (0.031)
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
91 (0.069)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '947188' AND store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1958
92 (0.069)
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
93 (0.068)
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
94 (0.071)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '947188' AND store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1958
95 (0.068)
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
96 (0.066)
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
97 (0.070)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '947188' AND store_id = '0'
/home/bpazar/storage/modification/catalog/model/catalog/product.php:1958
98 (0.067)
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
99 (0.066)
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
100 (0.348)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2019-09-21 00:44:06'
/home/bpazar/public_html/catalog/model/tool/online.php:4
101 (0.104)
REPLACE INTO `oc_customer_online` SET `ip` = '3.227.254.12', `customer_id` = '0', `url` = 'https://www.bpazar.com/Ev-Tekstili/lady-moda-home-cift-kisilik-yatak-ortusu-sari/947188', `referer` = '', `date_added` = '2019-09-21 01:44:06'
/home/bpazar/public_html/catalog/model/tool/online.php:6
102 (0.074)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/bpazar/public_html/catalog/model/setting/extension.php:4
103 (0.086)
SELECT *
FROM oc_customerpartner_to_customer
WHERE customer_id = '0'
/home/bpazar/public_html/catalog/model/account/customerpartner.php:1460
104 (0.076)
SELECT *
FROM oc_customerpartner_to_customer
WHERE customer_id = '0'
/home/bpazar/public_html/catalog/model/account/customerpartner.php:1460
105 (0.076)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/bpazar/public_html/catalog/model/localisation/language.php:15
106 (0.071)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:147
107 (0.191)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3acd42d294545cd1bb44457e6b'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:150
108 (0.082)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/bpazar/public_html/catalog/model/setting/extension.php:4
109 (0.078)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:147
110 (0.078)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3acd42d294545cd1bb44457e6b'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:150
111 (0.080)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:147
112 (0.074)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3acd42d294545cd1bb44457e6b'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:150
113 (0.091)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/bpazar/storage/modification/system/library/cart/customer.php:122
114 (0.076)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:147
115 (0.069)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3acd42d294545cd1bb44457e6b'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:150
116 (0.070)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:147
117 (0.075)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3acd42d294545cd1bb44457e6b'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:150
118 (0.115)
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
119 (0.119)
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
120 (0.104)
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