Error 1064:
Array
(
[0] => Array
(
[errno] => 1064
[sqlstate] => 42000
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
UNION
SELECT Prekes.AKP Prekes_ID
FROM Prekes
' at line 48
)
)
SELECT COUNT(*) EiluciuKiekis,
GROUP_CONCAT(DISTINCT GamintojasImones_ID) ListGamintojasImones_ID,
GROUP_CONCAT(DISTINCT PrekiuGrupes_ID) ListPrekiuGrupes_ID
FROM
(
SELECT AtrinktosPrekes.Prekes_ID,
AtrinktosPrekes.GamintojasImones_ID,
AtrinktosPrekes.PrekesGrupeAKF PrekiuGrupes_ID
FROM
(
SELECT PrekesPagalPaieska.*
FROM
(
# Prekiu atrinkimas
SELECT
Prekes.*,
Prekes.AKP Prekes_ID,
Imones.ImonesKodas, Imones.TruPavad, Imones.ImonesPavadinimas,
PrekiuGrupes.PrGrKodas,
PrekiuGrupes.PrGrPav,
PrekiuGrupes.PagrindinesPaslaugosPrekes_ID, PrekiuGrupes.Sandeliai_ID GrupesSandeliai_ID,
CONCAT_WS(' ', PrekiuGrupes.PrGrPav, Prekes.Pavadinimas) PrekesPavadinimas,
Prekes.Pavadinimas Pavadinimas_BeGrupes,
Prekes.IlgasPavadinimas IlgasPavadinimas_BeGrupes,
Prekes.RusiskasPavadinimas RusiskasPavadinimas_BeGrupes,
Prekes.VokiskasPavadinimas VokiskasPavadinimas_BeGrupes,
PrekiuGrupes.Pavadinimas_RU,
PrekiuGrupes.Pavadinimas_EN,
PrekiuGrupes.Pavadinimas_DE,
PrekiuGrupes.Pavadinimas_LV,
PrekiuGrupes.SEOName PrekesGrupe_SEO,
AkcijinesKainos.Kaina AkcijosKainininkoKaina,
AkcijinisKainuTipas.SuPVM AkcijosSuPVM,
AkcijinisKainuTipas.KainuTipai_ID AkcijosKainuTipai_ID,
1 Score
FROM
(
SELECT PrekiuGrupiuRysys.Prekes_ID
FROM PrekiuGrupiuRysys
WHERE PrekiuGrupiuRysys.PrekiuGrupes_ID IN (815,1001,1002,1013,1014,1015,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1175,1176,1178,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,)
UNION
SELECT Prekes.AKP Prekes_ID
FROM Prekes
WHERE Prekes.PrekesGrupeAKF IN (815,1001,1002,1013,1014,1015,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1175,1176,1178,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,)
) AS PrekiuSarasas
LEFT JOIN Prekes ON Prekes.AKP = PrekiuSarasas.Prekes_ID
LEFT JOIN PrekiuGrupes ON PrekiuGrupes.AKF = Prekes.PrekesGrupeAKF
LEFT JOIN Imones ON Imones.AKB = Prekes.Tiekejas_ID
#LEFT JOIN KainuKoeficientai AS KK1 ON KK1.Imones_ID = 100000001 AND KK1.PrekiuGrupes_ID = Prekes.PrekesGrupeAKF AND Prekes.PrekesGrupeAKF > 0
#LEFT JOIN KainuKoeficientai AS KK2 ON KK2.Imones_ID = 100000001 AND KK2.TiekejasImones_ID = Prekes.Tiekejas_ID AND Prekes.Tiekejas_ID > 0
#LEFT JOIN KainuKoeficientai AS KK3 ON KK3.Imones_ID = 100000001 AND KK3.GamintojasImones_ID = Prekes.GamintojasImones_ID AND Prekes.GamintojasImones_ID > 0
LEFT JOIN KainuTipai AS AkcijinisKainuTipas ON AkcijinisKainuTipas.KainuTipai_ID = 0
LEFT JOIN DetaliosKainos AS AkcijinesKainos ON AkcijinesKainos.Prekes_ID = Prekes.AKP AND
AkcijinesKainos.KainuTipai_ID = 0
WHERE -- $SearchType IN (0,1,2,3,4,5,6,7, 9) AND
Prekes.Nenaudojama = 0 AND
Prekes.NerodytiWWW = 0 AND
PrekiuGrupes.RodytiWWW = 1 AND
# (
# IFNULL(KK1.NerodytiWWW, 0) = 0 AND
# IFNULL(KK2.NerodytiWWW, 0) = 0 AND
# IFNULL(KK3.NerodytiWWW, 0) = 0
# ) AND
1 > 0
ORDER BY Score DESC,
Prekes.NomenklaturosNr
LIMIT 3000
) AS PrekesPagalPaieska
LEFT JOIN KainuKoeficientai AS KK1 ON KK1.Imones_ID = 100000001 AND KK1.PrekiuGrupes_ID = PrekesPagalPaieska.PrekesGrupeAKF AND PrekesPagalPaieska.PrekesGrupeAKF > 0
LEFT JOIN KainuKoeficientai AS KK2 ON KK2.Imones_ID = 100000001 AND KK2.TiekejasImones_ID = PrekesPagalPaieska.Tiekejas_ID AND PrekesPagalPaieska.Tiekejas_ID > 0
LEFT JOIN KainuKoeficientai AS KK3 ON KK3.Imones_ID = 100000001 AND KK3.GamintojasImones_ID = PrekesPagalPaieska.GamintojasImones_ID AND PrekesPagalPaieska.GamintojasImones_ID > 0
WHERE (
IFNULL(KK1.NerodytiWWW, 0) = 0 AND
IFNULL(KK2.NerodytiWWW, 0) = 0 AND
IFNULL(KK3.NerodytiWWW, 0) = 0
)
) AS AtrinktosPrekes
LEFT JOIN Likuciai ON Likuciai.Prekes_ID = AtrinktosPrekes.Prekes_ID AND
Likuciai.Sandeliai_ID IN (0,800000000,800000001,800000002,800000003,800000005, @PagrindinisSandeliai_ID, 800000000,800000001)
WHERE 1=1
GROUP BY AtrinktosPrekes.Prekes_ID
) AS AtrinktosPrekes;Array
(
[0] => Array
(
[file] => /home/www_rcdalys/www/eprekyba-core/system/library/db.php
[line] => 33
[function] => query
[class] => mysqlid
[object] => mysqlid Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1064
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
UNION
SELECT Prekes.AKP Prekes_ID
FROM Prekes
' at line 48
[error_list] => Array
(
[0] => Array
(
[errno] => 1064
[sqlstate] => 42000
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
UNION
SELECT Prekes.AKP Prekes_ID
FROM Prekes
' at line 48
)
)
[field_count] => 0
[host_info] => 192.168.225.249 via TCP/IP
[info] =>
[insert_id] => 0
[server_info] => 8.0.42
[server_version] => 80042
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 10263526
[warning_count] => 0
)
[type] => ->
[args] => Array
(
[0] =>
SELECT COUNT(*) EiluciuKiekis,
GROUP_CONCAT(DISTINCT GamintojasImones_ID) ListGamintojasImones_ID,
GROUP_CONCAT(DISTINCT PrekiuGrupes_ID) ListPrekiuGrupes_ID
FROM
(
SELECT AtrinktosPrekes.Prekes_ID,
AtrinktosPrekes.GamintojasImones_ID,
AtrinktosPrekes.PrekesGrupeAKF PrekiuGrupes_ID
FROM
(
SELECT PrekesPagalPaieska.*
FROM
(
# Prekiu atrinkimas
SELECT
Prekes.*,
Prekes.AKP Prekes_ID,
Imones.ImonesKodas, Imones.TruPavad, Imones.ImonesPavadinimas,
PrekiuGrupes.PrGrKodas,
PrekiuGrupes.PrGrPav,
PrekiuGrupes.PagrindinesPaslaugosPrekes_ID, PrekiuGrupes.Sandeliai_ID GrupesSandeliai_ID,
CONCAT_WS(' ', PrekiuGrupes.PrGrPav, Prekes.Pavadinimas) PrekesPavadinimas,
Prekes.Pavadinimas Pavadinimas_BeGrupes,
Prekes.IlgasPavadinimas IlgasPavadinimas_BeGrupes,
Prekes.RusiskasPavadinimas RusiskasPavadinimas_BeGrupes,
Prekes.VokiskasPavadinimas VokiskasPavadinimas_BeGrupes,
PrekiuGrupes.Pavadinimas_RU,
PrekiuGrupes.Pavadinimas_EN,
PrekiuGrupes.Pavadinimas_DE,
PrekiuGrupes.Pavadinimas_LV,
PrekiuGrupes.SEOName PrekesGrupe_SEO,
AkcijinesKainos.Kaina AkcijosKainininkoKaina,
AkcijinisKainuTipas.SuPVM AkcijosSuPVM,
AkcijinisKainuTipas.KainuTipai_ID AkcijosKainuTipai_ID,
1 Score
FROM
(
SELECT PrekiuGrupiuRysys.Prekes_ID
FROM PrekiuGrupiuRysys
WHERE PrekiuGrupiuRysys.PrekiuGrupes_ID IN (815,1001,1002,1013,1014,1015,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1175,1176,1178,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,)
UNION
SELECT Prekes.AKP Prekes_ID
FROM Prekes
WHERE Prekes.PrekesGrupeAKF IN (815,1001,1002,1013,1014,1015,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1175,1176,1178,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,)
) AS PrekiuSarasas
LEFT JOIN Prekes ON Prekes.AKP = PrekiuSarasas.Prekes_ID
LEFT JOIN PrekiuGrupes ON PrekiuGrupes.AKF = Prekes.PrekesGrupeAKF
LEFT JOIN Imones ON Imones.AKB = Prekes.Tiekejas_ID
#LEFT JOIN KainuKoeficientai AS KK1 ON KK1.Imones_ID = 100000001 AND KK1.PrekiuGrupes_ID = Prekes.PrekesGrupeAKF AND Prekes.PrekesGrupeAKF > 0
#LEFT JOIN KainuKoeficientai AS KK2 ON KK2.Imones_ID = 100000001 AND KK2.TiekejasImones_ID = Prekes.Tiekejas_ID AND Prekes.Tiekejas_ID > 0
#LEFT JOIN KainuKoeficientai AS KK3 ON KK3.Imones_ID = 100000001 AND KK3.GamintojasImones_ID = Prekes.GamintojasImones_ID AND Prekes.GamintojasImones_ID > 0
LEFT JOIN KainuTipai AS AkcijinisKainuTipas ON AkcijinisKainuTipas.KainuTipai_ID = 0
LEFT JOIN DetaliosKainos AS AkcijinesKainos ON AkcijinesKainos.Prekes_ID = Prekes.AKP AND
AkcijinesKainos.KainuTipai_ID = 0
WHERE -- $SearchType IN (0,1,2,3,4,5,6,7, 9) AND
Prekes.Nenaudojama = 0 AND
Prekes.NerodytiWWW = 0 AND
PrekiuGrupes.RodytiWWW = 1 AND
# (
# IFNULL(KK1.NerodytiWWW, 0) = 0 AND
# IFNULL(KK2.NerodytiWWW, 0) = 0 AND
# IFNULL(KK3.NerodytiWWW, 0) = 0
# ) AND
1 > 0
ORDER BY Score DESC,
Prekes.NomenklaturosNr
LIMIT 3000
) AS PrekesPagalPaieska
LEFT JOIN KainuKoeficientai AS KK1 ON KK1.Imones_ID = 100000001 AND KK1.PrekiuGrupes_ID = PrekesPagalPaieska.PrekesGrupeAKF AND PrekesPagalPaieska.PrekesGrupeAKF > 0
LEFT JOIN KainuKoeficientai AS KK2 ON KK2.Imones_ID = 100000001 AND KK2.TiekejasImones_ID = PrekesPagalPaieska.Tiekejas_ID AND PrekesPagalPaieska.Tiekejas_ID > 0
LEFT JOIN KainuKoeficientai AS KK3 ON KK3.Imones_ID = 100000001 AND KK3.GamintojasImones_ID = PrekesPagalPaieska.GamintojasImones_ID AND PrekesPagalPaieska.GamintojasImones_ID > 0
WHERE (
IFNULL(KK1.NerodytiWWW, 0) = 0 AND
IFNULL(KK2.NerodytiWWW, 0) = 0 AND
IFNULL(KK3.NerodytiWWW, 0) = 0
)
) AS AtrinktosPrekes
LEFT JOIN Likuciai ON Likuciai.Prekes_ID = AtrinktosPrekes.Prekes_ID AND
Likuciai.Sandeliai_ID IN (0,800000000,800000001,800000002,800000003,800000005, @PagrindinisSandeliai_ID, 800000000,800000001)
WHERE 1=1
GROUP BY AtrinktosPrekes.Prekes_ID
) AS AtrinktosPrekes;
[1] =>
)
)
[1] => Array
(
[file] => /home/www_rcdalys/www/eprekyba-core/model/catalog/product.php
[line] => 1884
[function] => query
[class] => DB
[object] => DB Object
(
[driver:DB:private] => mysqlid Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1064
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
UNION
SELECT Prekes.AKP Prekes_ID
FROM Prekes
' at line 48
[error_list] => Array
(
[0] => Array
(
[errno] => 1064
[sqlstate] => 42000
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
UNION
SELECT Prekes.AKP Prekes_ID
FROM Prekes
' at line 48
)
)
[field_count] => 0
[host_info] => 192.168.225.249 via TCP/IP
[info] =>
[insert_id] => 0
[server_info] => 8.0.42
[server_version] => 80042
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 10263526
[warning_count] => 0
)
)
[type] => ->
[args] => Array
(
[0] =>
SELECT COUNT(*) EiluciuKiekis,
GROUP_CONCAT(DISTINCT GamintojasImones_ID) ListGamintojasImones_ID,
GROUP_CONCAT(DISTINCT PrekiuGrupes_ID) ListPrekiuGrupes_ID
FROM
(
SELECT AtrinktosPrekes.Prekes_ID,
AtrinktosPrekes.GamintojasImones_ID,
AtrinktosPrekes.PrekesGrupeAKF PrekiuGrupes_ID
FROM
(
SELECT PrekesPagalPaieska.*
FROM
(
# Prekiu atrinkimas
SELECT
Prekes.*,
Prekes.AKP Prekes_ID,
Imones.ImonesKodas, Imones.TruPavad, Imones.ImonesPavadinimas,
PrekiuGrupes.PrGrKodas,
PrekiuGrupes.PrGrPav,
PrekiuGrupes.PagrindinesPaslaugosPrekes_ID, PrekiuGrupes.Sandeliai_ID GrupesSandeliai_ID,
CONCAT_WS(' ', PrekiuGrupes.PrGrPav, Prekes.Pavadinimas) PrekesPavadinimas,
Prekes.Pavadinimas Pavadinimas_BeGrupes,
Prekes.IlgasPavadinimas IlgasPavadinimas_BeGrupes,
Prekes.RusiskasPavadinimas RusiskasPavadinimas_BeGrupes,
Prekes.VokiskasPavadinimas VokiskasPavadinimas_BeGrupes,
PrekiuGrupes.Pavadinimas_RU,
PrekiuGrupes.Pavadinimas_EN,
PrekiuGrupes.Pavadinimas_DE,
PrekiuGrupes.Pavadinimas_LV,
PrekiuGrupes.SEOName PrekesGrupe_SEO,
AkcijinesKainos.Kaina AkcijosKainininkoKaina,
AkcijinisKainuTipas.SuPVM AkcijosSuPVM,
AkcijinisKainuTipas.KainuTipai_ID AkcijosKainuTipai_ID,
1 Score
FROM
(
SELECT PrekiuGrupiuRysys.Prekes_ID
FROM PrekiuGrupiuRysys
WHERE PrekiuGrupiuRysys.PrekiuGrupes_ID IN (815,1001,1002,1013,1014,1015,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1175,1176,1178,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,)
UNION
SELECT Prekes.AKP Prekes_ID
FROM Prekes
WHERE Prekes.PrekesGrupeAKF IN (815,1001,1002,1013,1014,1015,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1175,1176,1178,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,)
) AS PrekiuSarasas
LEFT JOIN Prekes ON Prekes.AKP = PrekiuSarasas.Prekes_ID
LEFT JOIN PrekiuGrupes ON PrekiuGrupes.AKF = Prekes.PrekesGrupeAKF
LEFT JOIN Imones ON Imones.AKB = Prekes.Tiekejas_ID
#LEFT JOIN KainuKoeficientai AS KK1 ON KK1.Imones_ID = 100000001 AND KK1.PrekiuGrupes_ID = Prekes.PrekesGrupeAKF AND Prekes.PrekesGrupeAKF > 0
#LEFT JOIN KainuKoeficientai AS KK2 ON KK2.Imones_ID = 100000001 AND KK2.TiekejasImones_ID = Prekes.Tiekejas_ID AND Prekes.Tiekejas_ID > 0
#LEFT JOIN KainuKoeficientai AS KK3 ON KK3.Imones_ID = 100000001 AND KK3.GamintojasImones_ID = Prekes.GamintojasImones_ID AND Prekes.GamintojasImones_ID > 0
LEFT JOIN KainuTipai AS AkcijinisKainuTipas ON AkcijinisKainuTipas.KainuTipai_ID = 0
LEFT JOIN DetaliosKainos AS AkcijinesKainos ON AkcijinesKainos.Prekes_ID = Prekes.AKP AND
AkcijinesKainos.KainuTipai_ID = 0
WHERE -- $SearchType IN (0,1,2,3,4,5,6,7, 9) AND
Prekes.Nenaudojama = 0 AND
Prekes.NerodytiWWW = 0 AND
PrekiuGrupes.RodytiWWW = 1 AND
# (
# IFNULL(KK1.NerodytiWWW, 0) = 0 AND
# IFNULL(KK2.NerodytiWWW, 0) = 0 AND
# IFNULL(KK3.NerodytiWWW, 0) = 0
# ) AND
1 > 0
ORDER BY Score DESC,
Prekes.NomenklaturosNr
LIMIT 3000
) AS PrekesPagalPaieska
LEFT JOIN KainuKoeficientai AS KK1 ON KK1.Imones_ID = 100000001 AND KK1.PrekiuGrupes_ID = PrekesPagalPaieska.PrekesGrupeAKF AND PrekesPagalPaieska.PrekesGrupeAKF > 0
LEFT JOIN KainuKoeficientai AS KK2 ON KK2.Imones_ID = 100000001 AND KK2.TiekejasImones_ID = PrekesPagalPaieska.Tiekejas_ID AND PrekesPagalPaieska.Tiekejas_ID > 0
LEFT JOIN KainuKoeficientai AS KK3 ON KK3.Imones_ID = 100000001 AND KK3.GamintojasImones_ID = PrekesPagalPaieska.GamintojasImones_ID AND PrekesPagalPaieska.GamintojasImones_ID > 0
WHERE (
IFNULL(KK1.NerodytiWWW, 0) = 0 AND
IFNULL(KK2.NerodytiWWW, 0) = 0 AND
IFNULL(KK3.NerodytiWWW, 0) = 0
)
) AS AtrinktosPrekes
LEFT JOIN Likuciai ON Likuciai.Prekes_ID = AtrinktosPrekes.Prekes_ID AND
Likuciai.Sandeliai_ID IN (0,800000000,800000001,800000002,800000003,800000005, @PagrindinisSandeliai_ID, 800000000,800000001)
WHERE 1=1
GROUP BY AtrinktosPrekes.Prekes_ID
) AS AtrinktosPrekes;
)
)
[2] => Array
(
[file] => /home/www_rcdalys/www/eprekyba-core/controller/product/category.php
[line] => 175
[function] => getTotalProductsByCategoryId
[class] => ModelCatalogProduct
[object] => ModelCatalogProduct Object
(
[StartQuery] => 1756478261.6597
[StopQuery] =>
[ListPrekiuGrupes:ModelCatalogProduct:private] =>
[ListGamintojasImones:ModelCatalogProduct:private] =>
)
[type] => ->
[args] => Array
(
[0] => 815
[1] => 0
[2] => 0
)
)
[3] => Array
(
[file] => /home/www_rcdalys/www/eprekyba-core/system/engine/front.php
[line] => 48
[function] => index
[class] => ControllerProductCategory
[object] => ControllerProductCategory Object
(
[id:protected] =>
[template:protected] =>
[layout:protected] =>
[children:protected] => Array
(
)
[data:protected] => Array
(
[valiuta] => Array
(
[0] => Array
(
[text] => LTL
[value] => ltl
[href] => https://www.rcdalys.lt/setcookie.php?url=http%3A%2F%2Fwww.rcdalys.lt%2Fkategorijos%2F815%2FPropelerislt-sandelis&curret=ltl
)
[1] => Array
(
[text] => EUR
[value] => eur
[href] => https://www.rcdalys.lt/setcookie.php?url=http%3A%2F%2Fwww.rcdalys.lt%2Fkategorijos%2F815%2FPropelerislt-sandelis&curret=eur
)
)
[kaina_su] => Array
(
[0] => Array
(
[text] => Su PVM
[value] => 1
[href] => https://www.rcdalys.lt/setcookie.php?url=http%3A%2F%2Fwww.rcdalys.lt%2Fkategorijos%2F815%2FPropelerislt-sandelis&act=pvm&curret=su
)
[1] => Array
(
[text] => Be PVM
[value] => 0
[href] => https://www.rcdalys.lt/setcookie.php?url=http%3A%2F%2Fwww.rcdalys.lt%2Fkategorijos%2F815%2FPropelerislt-sandelis&act=pvm&curret=be
)
)
[action] => https://www.rcdalys.lt/index.php?route=checkout/cart
[heading_title] => Propeleris.lt sandėlis
[heading_description] =>
[heading_description_long] =>
[description] =>
)
[output:protected] =>
[title:protected] =>
[sidebar:protected] => Array
(
)
[head:protected] => Array
(
)
[meta_title:protected] => RC dalys | Propeleris.lt sandėlis
[canonical:protected] =>
)
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] => /home/www_rcdalys/www/eprekyba-core/system/engine/front.php
[line] => 27
[function] => execute
[class] => Front
[object] => Front Object
(
[pre_action:protected] => Array
(
[0] => Router Object
(
[class:protected] => common/seo_url
[method:protected] => index
[args:protected] => Array
(
)
)
)
[error:protected] => Router Object
(
[class:protected] => error/not_found
[method:protected] => index
[args:protected] => Array
(
)
)
)
[type] => ->
[args] => Array
(
[0] =>
)
)
[5] => Array
(
[file] => /home/www_rcdalys/www/eprekyba-core/index.php
[line] => 504
[function] => dispatch
[class] => Front
[object] => Front Object
(
[pre_action:protected] => Array
(
[0] => Router Object
(
[class:protected] => common/seo_url
[method:protected] => index
[args:protected] => Array
(
)
)
)
[error:protected] => Router Object
(
[class:protected] => error/not_found
[method:protected] => index
[args:protected] => Array
(
)
)
)
[type] => ->
[args] => Array
(
[0] => Router Object
(
[class:protected] => product/category
[method:protected] => index
[args:protected] => Array
(
)
)
[1] => Router Object
(
[class:protected] => error/not_found
[method:protected] => index
[args:protected] => Array
(
)
)
)
)
[6] => Array
(
[file] => /home/www_rcdalys/www/index.php
[line] => 2
[args] => Array
(
[0] => /home/www_rcdalys/www/eprekyba-core/index.php
)
[function] => require_once
)
)