SELECT SQL_NO_CACHE sa.id_product_attribute as id_comb,
sa.quantity as qty,
pac.id_attribute as id_att,
sa.id_product,
a.id_attribute_group as id_group
FROM ps_stock_available sa
INNER JOIN ps_product_shop ps
ON ps.id_product = sa.id_product AND ps.active = 1
AND ps.id_shop = 1
LEFT JOIN ps_product_attribute_combination pac
ON pac.id_product_attribute = sa.id_product_attribute
LEFT JOIN ps_attribute a
ON a.id_attribute = pac.id_attribute
WHERE sa.id_shop = 1
AND sa.quantity > 0
ORDER BY pac.id_attribute ASC

SELECT SQL_NO_CACHE DISTINCT a.id_attribute AS id,
a.position,
al.name,
a.color,
ag.id_attribute_group AS id_group,
agl.public_name AS group_name,
ag.is_color_group
FROM ps_attribute_group ag
INNER JOIN ps_attribute_group_lang agl
ON (ag.id_attribute_group = agl.id_attribute_group AND agl.id_lang = 4)
INNER JOIN ps_attribute a
ON a.id_attribute_group = ag.id_attribute_group
INNER JOIN ps_attribute_lang al
ON (a.id_attribute = al.id_attribute AND al.id_lang = 4)
INNER JOIN ps_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE a.id_attribute IS NOT NULL AND al.name IS NOT NULL AND agl.id_attribute_group IS NOT NULL
ORDER BY al.name

SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_log`
WHERE
`message` = 'MaxMindGeoIP2: The file \"/var/www/vhosts/o-m.co.il/httpdocs/tools/geoip/db.mmdb\" does not exist or is not readable.'
AND `severity` = '1'
AND `error_code` = '0'
AND `object_type` = ''
AND `object_id` = '' LIMIT 1

SELECT SQL_NO_CACHE v.id_feature_value AS id,
fl.name AS group_name,
v.id_feature AS id_group,
vl.value AS name
FROM ps_feature_value v
INNER JOIN ps_feature_value_lang vl
ON (v.id_feature_value = vl.id_feature_value AND vl.id_lang = 4)
INNER JOIN ps_feature f
ON f.id_feature = v.id_feature
INNER JOIN ps_feature_lang fl
ON (fl.id_feature = v.id_feature AND fl.id_lang = 4)
ORDER BY vl.value

SELECT SQL_NO_CACHE * FROM `ps_awp_attribute_wizard_pro`

SELECT SQL_NO_CACHE h.name, h.title
FROM `ps_hook` h
LEFT JOIN `ps_hook_alias` `ha` ON ha.name = h.name
WHERE (h.name LIKE 'display%' OR h.name IN ("displayHeader","displayLeftColumn","displayRightColumn","displayHome","displayTop","displayFooter","displayFooterProduct","displayMyAccountBlock","displayBackOfficeFooter","displayBackOfficeHeader","displayBackOfficeHome","displayBackOfficeTop","displayBackOfficeCategory","displayAdminOrder","displayAdminCustomers","displayBeforeCarrier","displayBeforePayment","displayCustomerAccount","displayCustomerAccountForm","displayCustomerAccountFormTop","displayLeftColumnProduct","displayMaintenance","displayRightColumnProduct","displayProductTab","displayProductTabContent","displayPaymentReturn","displayPaymentTop","displayProductButtons","displayProductComparison","displayShoppingCart","displayShoppingCartFooter","displayTopColumn","displayProductListFunctionalButtons","displayPDFInvoice","displayInvoice","displayNav","displayMyAccountBlockFooter","displayHomeTab","displayHomeTabContent","displayPricesDropTop","displayPricesDropBelow","displayNewProductsTop","displayNewProductsBelow","displayBestSalesTop","displayBestSalesBelow") or ha.alias IN ("displayHeader","displayLeftColumn","displayRightColumn","displayHome","displayTop","displayFooter","displayFooterProduct","displayMyAccountBlock","displayBackOfficeFooter","displayBackOfficeHeader","displayBackOfficeHome","displayBackOfficeTop","displayBackOfficeCategory","displayAdminOrder","displayAdminCustomers","displayBeforeCarrier","displayBeforePayment","displayCustomerAccount","displayCustomerAccountForm","displayCustomerAccountFormTop","displayLeftColumnProduct","displayMaintenance","displayRightColumnProduct","displayProductTab","displayProductTabContent","displayPaymentReturn","displayPaymentTop","displayProductButtons","displayProductComparison","displayShoppingCart","displayShoppingCartFooter","displayTopColumn","displayProductListFunctionalButtons","displayPDFInvoice","displayInvoice","displayNav","displayMyAccountBlockFooter","displayHomeTab","displayHomeTabContent","displayPricesDropTop","displayPricesDropBelow","displayNewProductsTop","displayNewProductsBelow","displayBestSalesTop","displayBestSalesBelow"))
ORDER BY h.name, h.title

SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10320,10316,10314,10312,10310,10308,10306,10304,10194) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='22804f871b0af5b7c51509c0c4cd3cac' AND cache_id LIKE "productlist_colors|7033|1|4%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='22804f871b0af5b7c51509c0c4cd3cac' AND cache_id LIKE "productlist_colors|7533|1|4%"

SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`value`) AS `value`, c.`id_shop_group`, c.`id_shop`
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` `cl` ON c.`id_configuration` = cl.`id_configuration`

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='22804f871b0af5b7c51509c0c4cd3cac' AND cache_id LIKE "productlist_colors|7099|1|4%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='22804f871b0af5b7c51509c0c4cd3cac' AND cache_id LIKE "productlist_colors|7683|1|4%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='22804f871b0af5b7c51509c0c4cd3cac' AND cache_id LIKE "productlist_colors|7685|1|4%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='22804f871b0af5b7c51509c0c4cd3cac' AND cache_id LIKE "productlist_colors|7690|1|4%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='22804f871b0af5b7c51509c0c4cd3cac' AND cache_id LIKE "productlist_colors|7110|1|4%"

SELECT SQL_NO_CACHE `id_date_range`, `time_end`
FROM `ps_date_range`
WHERE (`time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`)) LIMIT 1

SELECT SQL_NO_CACHE COUNT(DISTINCT(cp.`id_product`)) AS total
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (133) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='22804f871b0af5b7c51509c0c4cd3cac' AND cache_id LIKE "productlist_colors|7472|1|4%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='22804f871b0af5b7c51509c0c4cd3cac' AND cache_id LIKE "productlist_colors|7691|1|4%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='22804f871b0af5b7c51509c0c4cd3cac' AND cache_id LIKE "productlist_colors|7528|1|4%"

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='22804f871b0af5b7c51509c0c4cd3cac' AND cache_id LIKE "productlist_colors|7114|1|4%"

SELECT SQL_NO_CACHE p.*, product_shop.*, pl.*, image.id_image, il.legend, m.name AS manufacturer_name,
DATEDIFF('2025-08-04 04:10:31', p.date_add) < 3 AS new
FROM ps_product p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
INNER JOIN ps_product_lang pl
ON (pl.id_product = p.id_product AND pl.id_shop = 1 
AND pl.id_lang = 4)
LEFT JOIN ps_image image
ON (image.id_product = p.id_product AND image.cover = 1)
LEFT JOIN ps_image_lang il
ON (il.id_image = image.id_image AND il.id_lang = 4)
LEFT JOIN ps_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE p.id_product IN (10320, 10316, 10314, 10312, 10310, 10308, 10306, 10304, 10194, 7691, 7690, 7685, 7683, 7533, 7528, 7472, 7114, 7110, 7099, 7033)