SQL: SELECT SQL_CACHE SQL_CALC_FOUND_ROWS
product.id AS id,
product.bonus_points,
product.in_store AS in_store,
COALESCE(product_lang.availability_text, product_lang_alt.availability_text) AS availability_text,
COALESCE(availability_lang.title, availability_lang_alt.title) AS availability,
availability.icon AS availability_icon,
product.is_configuration AS is_configuration,
IF(product.is_configuration = 1,
(SELECT GROUP_CONCAT(CONCAT(product_configuration.id_product_configuration,'-',product_configuration.id_category,'-',product_configuration.required)
ORDER BY product_configuration.id_product_configuration
SEPARATOR '|')
FROM product_configuration
LEFT JOIN product product_alt ON product_alt.id = product_configuration.id_product_configuration
LEFT JOIN product_visible ON product_visible.id_product = product_configuration.id_product
AND product_visible.id_domain = 1
WHERE product_configuration.id_product = product.id AND
product_configuration.id_domain = '1' AND
product_visible.visible = 1 AND
product_alt.deleted = 0
GROUP BY product_configuration.id_product),
'na'
) AS id_products_included,
(SELECT COUNT(DISTINCT p_extras.id_color_code)
FROM product AS product1
INNER JOIN product_visible ON product_visible.id_product = product1.id AND product_visible.id_domain = '1' AND product_visible.visible = 1
INNER JOIN product_extras AS p_extras ON p_extras.id_product = product1.id AND id_color_code != 0
WHERE product1.id_product_group = product.id_product_group AND product1.deleted = 0) AS variants_count,
IF(product.is_configuration = 1,
COALESCE((SELECT GROUP_CONCAT(product_configuration.id_product_configuration
ORDER BY product_configuration.id_product_configuration
SEPARATOR '|')
FROM product_configuration
LEFT JOIN product product_alt ON product_alt.id = product_configuration.id_product_configuration
LEFT JOIN product_visible ON product_visible.id_product = product_configuration.id_product
AND product_visible.id_domain = 1
WHERE product_configuration.id_product = product.id AND
product_configuration.id_domain = '1' AND
product_visible.visible = 1 AND
product_alt.deleted = 0
GROUP BY product_configuration.id_product),'na'),
'na'
) AS product_ids_included,
category_product.id_category AS id_category,
COALESCE(product_lang.title, product_lang_alt.title) AS title,
COALESCE(product_lang.rewrite_title, product_lang_alt.rewrite_title) AS rewrite_title,
COALESCE(product_lang.description, product_lang_alt.description) AS description,
COALESCE(product_lang.short_description, product_lang_alt.short_description) AS short_description,
product.user_code AS user_code,
product.quantity AS quantity,
product.id_producer,
product.id_product_config_parameter_group,
producer.title AS producer_title,
product.id_product_group,
product_extras.discount AS product_discount,
product_extras.discount_type AS product_discount_type,
product_extras.fixed_price AS fixed_price,
IF(
(SELECT COUNT(*)
FROM price
WHERE price.id_price_type = 1 AND
price.id_domain = 1 AND
id_product = product.id) = 0 AND
(SELECT COUNT(*)
FROM price
WHERE price.id_price_type = 1 AND
price.id_domain = 1 AND
id_product = product.id) = 0,
0,
COALESCE(
(SELECT value
FROM price
WHERE price.id_price_type = 1 AND
price.id_domain = 1 AND
id_product = product.id),
(SELECT value
FROM price
WHERE price.id_price_type = 1 AND
price.id_domain = 1 AND
id_product = product.id))
) AS price,
vat.rate AS vat,
IF(
(SELECT COUNT(*)
FROM price
WHERE price.id_price_type = 2 AND
price.id_domain = 1 AND
id_product = product.id) = 0,
0,
(SELECT value
FROM price
WHERE price.id_price_type = 2 AND
price.id_domain = 1 AND
id_product = product.id)
) AS normal_price,
normal_vat.rate AS normal_vat,
IF(
(SELECT COUNT(*)
FROM price
WHERE price.id_price_type = 1 AND
price.id_domain = 1 AND
id_product = product.id) = 0,
0,
(SELECT value
FROM price
WHERE price.id_price_type = 1 AND
price.id_domain = 1 AND
id_product = product.id)) AS price_fixed,
image.url AS image,
COUNT(order_item.id) AS order_by,
product.minimum_quantity AS minimum_quantity,
IF(pref_alt.action = 1 AND
((pref_alt.action_from IS NULL OR pref_alt.action_from >= NOW()) AND
(pref_alt.action_to IS NULL OR pref_alt.action_to <= NOW())), product_extras.action_price, 0) AS action_price
FROM product
LEFT OUTER JOIN producer ON product.id_producer = producer.id
LEFT JOIN preference AS pref_alt ON pref_alt.id_product = product.id
LEFT JOIN product_lang ON product_lang.id_product = product.id AND product_lang.id_lang = 1
LEFT JOIN product_lang AS product_lang_alt ON product_lang.id_lang IS NULL AND product_lang_alt.id_product = product.id AND product_lang_alt.id_lang = '1'
LEFT JOIN product_extras ON product_extras.id_product = product.id
LEFT JOIN price ON price.id_product = product.id AND price.id_price_type = 1
LEFT JOIN price AS price_alt ON price.id_product IS NULL AND price_alt.id_product = product.id AND price_alt.id_price_type = 1
INNER JOIN vat ON vat.id = COALESCE(price.id_vat, price_alt.id_vat)
LEFT JOIN price AS normal_price ON normal_price.id_product = product.id AND normal_price.id_price_type = 2
LEFT JOIN vat AS normal_vat ON normal_vat.id = normal_price.id_vat
LEFT JOIN image ON image.id_product = product.id AND image.head = 1
LEFT JOIN availability ON availability.id = product.id_availability
LEFT JOIN availability_lang ON availability_lang.id_availability = availability.id
AND availability_lang.id_lang = 1
LEFT JOIN availability_lang AS availability_lang_alt ON availability_lang.id_lang IS NULL
AND availability_lang_alt.id_availability = availability.id
AND availability_lang_alt.id_lang = 1
INNER JOIN category_product ON category_product.id_product = product.id AND category_product.id_category IN (1,1099,1100,1101,1102,1103,1104,1214,900,901,941,1264,1213,726,678,685,686,687,688,689,690,691,729,1207,730,731,922,926,927,921,1208,676,679,680,681,929,2,1105,1256,1257,1258,1266,68,69,169,1220,171,565,566,567,92,175,666,1121,44,89,3,26,27,42,43,28,29,32,1130,1131,1132,952,1129,5,33,34,1255,4,860,56,85,859,938,70,71,1216,854,1245,72,73,75,76,77,78,12,157,158,495,87,928,147,895,9,10,107,108,1237,1141,1240,894,115,116,117,122,804,491,24,74,120,722,1236,723,724,725,1226,1233,1232,1231,174,80,790,1230,857,103,104,105,106,489,123,124,1143,798,799,801,1235,475,1095,93,102,94,861,101,100,79,150,95,99,855,737,897,898,899,146,142,1124,1125,1126,1127,1144,1212,1128,570,1025,1243,1147,1244,1148,1033,1238,1035,1036,1040,1039,1228,1041,1043,1229,1145,1046,1227,1042,1044,1146,1150,1067,1242,1241,1239,1049,1151,1152,1209,1023,1211,1210,1215,1234,1024,1149,586,882,923,924,1133,1134,1135,1136,940,1107,942,943,944,1117,925,1218,1111,1185,1112,1113,1114,1115,945,946,948,950,1172,1173,1174,1175,1176,947,1171,955,1140,956,1061,1139,1178,1179,1180,1182,1183,1184,1138,1181,1050,1051,1052,1164,951,1193,1194,1195,1196,1197,1165,1060,961,1075,1076,1082,1081,1098,1077,1078,1083,1084,1085,1087,1088,1089,1079,1090,1091,1092,1093,1094,1096,1097,969,971,979,1080,1109,1168,1169,1199,1200,1201,1170,980,992,993,966,994,997,998,1001,1002,1003,1004,1005,1007,1008,1009,967,968,999,1000,1006,953,995,1010,1011,1012,1108,973,981,954,985,986,987,982,988,989,990,983,984,1202,1122,1186,1187,1188,1190,1191,1192,1013,1070,1071,1072,1073,1074,1059,1014,1021,1020,1015,1167,1016,1027,1028,1017,1029,1030,1031,1032,931,1063,1068,1069,1064,1065,1018,1053,1054,1055,1056,1057,1058,1019,930,1119,1118,1120,1154,1246,1254,1249,1253,1252,1247,1251,1250,1248,1260,1265,732,735,736,738,1262)
LEFT JOIN product_visible ON product_visible.id_product = product.id
AND product_visible.id_domain = 1
INNER JOIN order_item ON order_item.id_product = product.id
WHERE
1=1 AND
product_visible.visible = 1 AND
product.deleted = 0 AND
(1=1) AND
(product.valid_until IS NULL OR product.valid_until > NOW())
GROUP BY product.id
Server Error
Server Error
We're sorry! The server encountered an internal error and
was unable to complete your request. Please try again later.