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 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 (11594,11593,11592,11591,11590,11581,11580,11579,11550,11549,11543,11540,11539,11538,11534,11533,11532,11530,11504,11497) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;

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 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`

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

SELECT SQL_NO_CACHE h.id_hook, h.name AS h_name, h.title, h.description, h.position, h.live_edit, hm.position AS hm_position, m.id_module, m.name, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` AS m ON (m.id_module = hm.id_module)
ORDER BY hm.position

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 133) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`

SELECT SQL_NO_CACHE t.template_filters as data, tl.data as lang, t.id_template
FROM ps_af_templates t
LEFT JOIN ps_af_templates_lang tl
ON tl.id_template = t.id_template
AND tl.id_shop = t.id_shop
AND tl.id_lang = 4
INNER JOIN ps_af_category_templates ct
ON ct.id_template = t.id_template
AND ct.id_shop = t.id_shop
AND (ct.id_category = 133 OR ct.id_category = 0)
WHERE t.active = 1
AND t.template_controller = 'category'
AND t.id_shop = 1
ORDER BY ct.id_category DESC, t.id_template DESC LIMIT 1

SELECT SQL_NO_CACHE p.*, product_shop.*, pl.*, image.id_image, il.legend, m.name AS manufacturer_name,
DATEDIFF('2025-08-04 04:08:35', 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 (11594, 11593, 11592, 11591, 11590, 11581, 11580, 11579, 11550, 11549, 11543, 11540, 11539, 11538, 11534, 11533, 11532, 11530, 11504, 11497)

SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` AS name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name

SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 4 AND cl.id_shop = 1 
WHERE (c.nleft <= 34 AND c.nright >= 35)
ORDER BY c.nleft

SELECT SQL_NO_CACHE l.*, cr.id_cart_rule, sl.text, sl.hint, sl.url, spl.`priority`
FROM ps_seosaproductlabels_cart_rules cr
LEFT JOIN `ps_seosaproductlabels_shop` AS l 
ON l.id_product_label = cr.id_product_label
LEFT JOIN ps_seosaproductlabels_lang AS sl 
ON l.id_product_label = sl.id_product_label
LEFT JOIN `ps_seosaproductlabels`  AS spl 
ON spl.id_product_label = sl.id_product_label
LEFT JOIN `ps_cart_rule` crp ON crp.`id_cart_rule` = cr.`id_cart_rule` 
WHERE l.active = 1 AND sl.id_lang = 4 
AND crp.`active` = 1 AND l.`id_shop` = 1

SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1

SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 4  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 133
AND category_shop.`active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC

SELECT SQL_NO_CACHE `id_configuration`
FROM `ps_configuration`
WHERE name = 'aff_pname'
AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1

SELECT SQL_NO_CACHE m.`page`, ml.`url_rewrite`, ml.`id_lang`
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` `ml` ON m.`id_meta` = ml.`id_meta`  AND ml.id_shop = 1 
ORDER BY LENGTH(ml.`url_rewrite`) DESC

SELECT SQL_NO_CACHE smsg.*
FROM `ps_st_banner_group` smsg
INNER JOIN ps_st_banner_group_shop st_banner_group_shop
ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1)
WHERE smsg.`active`=1 AND smsg.`id_parent`=0  AND smsg.`location` IN (21)
ORDER BY smsg.`position`

SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1