Товары для пчеловодства (спецодежда, оборудование, инвентарь, препараты для пчел)

SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://nashedelo.biz.ua/'

SELECT *
FROM oc_setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

SELECT *
FROM `oc_language`
WHERE status = '1'

SELECT *
FROM oc_currency

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'

SELECT *
FROM oc_language
WHERE status = '1'

SELECT *
FROM oc_language
WHERE status = '1'

SELECT *
FROM oc_layout l
LEFT JOIN oc_layout_route lr ON (l.layout_id = lr.layout_id)
ORDER BY name ASC

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 = '20' AND cd.language_id = '1' AND c2s.store_id = '0' 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 = '211' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '211' AND cd.language_id = '1' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT SQL_CALC_FOUND_ROWS p.product_id, NULL AS rating, NULL AS discount, NULL AS special
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 = '211' GROUP BY p.product_id
ORDER BY p.sort_order DESC, p.quantity >0 DESC, LCASE(pd.name) ASC LIMIT 0,28

SELECT FOUND_ROWS() AS `found_rows`

SELECT *, IF(td.name_short IS NULL or td.name_short = '', td.name, td.name_short) as name, (select category_id
from oc_tag_to_category
where tag_id = t.tag_id) as category_id, (select count(*)
from oc_product_to_tag
where tag_id = pt.tag_id) as kol
FROM oc_product_to_tag pt
INNER JOIN oc_tag t ON (t.tag_id = pt.tag_id)
INNER JOIN oc_tag_description td ON (t.tag_id = td.tag_id)
INNER JOIN oc_tag_to_store ts ON (pt.tag_id = ts.tag_id)
INNER JOIN oc_product_to_category pc ON (pt.product_id = pc.product_id)
WHERE td.language_id = '1' AND ts.store_id = '0' AND t.status = '1' AND pc.category_id = 211 group by t.tag_id
ORDER BY kol desc

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT p.product_id, oov2p.value_id, oov2p.option_id, oov2p.slide_value_min, oov2p.slide_value_max, p.manufacturer_id, p.quantity, p.stock_status_id
FROM oc_product p
LEFT JOIN oc_ocfilter_option_value_to_product oov2p ON (oov2p.product_id = p.product_id)
LEFT JOIN oc_product_to_category p2c ON (p2c.product_id = p.product_id)
WHERE p.status = '1' AND p.date_available <= '2018-10-23' AND p2c.category_id = '211'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'ascp_admin'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_customer
WHERE customer_id = '0'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'total'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'ascp_admin'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_customer
WHERE customer_id = '0'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'ascp_admin'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_customer
WHERE customer_id = '0'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'ascp_admin'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_customer
WHERE customer_id = '0'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'ascp_admin'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_customer
WHERE customer_id = '0'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'ascp_admin'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_customer
WHERE customer_id = '0'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '211' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT author, rating, text, date_added
FROM oc_category_review
WHERE category_id = '211' AND status = '1'
ORDER BY date_added DESC

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'specialofferoutsite'

SELECT m.*, (SELECT description
FROM oc_multi_modal_translate
WHERE `key` = 'title' AND modal_id = m.id AND lang_id = '1') AS title, (SELECT description
FROM oc_multi_modal_translate
WHERE `key` = 'content' AND modal_id = m.id AND lang_id = '1') AS content
FROM oc_multi_modals m
WHERE m.status = 1

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

SELECT 'store_id', 'url'
FROM oc_store
ORDER BY url

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

SELECT *
FROM oc_extension
WHERE `type` = 'total'