Рекламация

SELECT *
FROM store
WHERE REPLACE(`url`, 'www.', '') = 'http://novelki.ru/'

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

SELECT *
FROM language
WHERE status = '1'

SELECT *
FROM currency

SELECT *
FROM weight_class wc

SELECT *
FROM length_class mc

SELECT *
FROM url_alias
WHERE keyword IN ('reklamatsiya')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=106')

SELECT DISTINCT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '106' AND i2s.store_id = '0' AND i.status = '1'

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=106')

SELECT *
FROM information_to_layout
WHERE information_id = '106' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'information/information' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

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

SELECT *
FROM category c
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c2s.store_id = '0' AND c.status = '1' AND c.top='1'
ORDER BY c.parent_id, c.sort_order, c.name

SELECT *
FROM category c
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c2s.store_id = '0' AND c.status = '1'
ORDER BY c.parent_id, c.sort_order, c.name

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0' AND p2c.store_id = '0' AND (p2c.category_id = '922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0' AND p2c.store_id = '0' AND (p2c.category_id = '923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0' AND p2c.store_id = '0' AND (p2c.category_id = '924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0' AND p2c.store_id = '0' AND (p2c.category_id = '925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0' AND p2c.store_id = '0' AND (p2c.category_id = '926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0' AND p2c.store_id = '0' AND (p2c.category_id = '927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0' AND p2c.store_id = '0' AND (p2c.category_id = '928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0' AND p2c.store_id = '0' AND (p2c.category_id = '929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0' AND p2c.store_id = '0' AND (p2c.category_id = '932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0' AND p2c.store_id = '0' AND (p2c.category_id = '934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM information_to_layout
WHERE information_id = '106' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'information/information' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

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

SELECT *
FROM information_to_layout
WHERE information_id = '106' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'information/information' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

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

SELECT *
FROM information_to_layout
WHERE information_id = '106' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'information/information' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

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

SELECT *
FROM information_to_layout
WHERE information_id = '106' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'information/information' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

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

SELECT *
FROM information_to_layout
WHERE information_id = '106' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'information/information' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

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

SELECT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i2s.store_id = '0' AND i.status = '1' AND i.sort_order <> '-1'
ORDER BY i.sort_order, LCASE(i.title) ASC

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=106')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=13')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i2s.store_id = '0' AND i.top = '1' AND i.status = '1' AND i.sort_order <> '-1'
ORDER BY i.sort_order, LCASE(i.title) ASC

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=106')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=106')

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

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