Error: Table '.\dagas_web\prekes' is marked as crashed and last (automatic?) repair failed
Error No: 144
SELECT COUNT(*) EiluciuKiekis
FROM
(
SELECT AtrinktosPrekes.Prekes_ID
FROM
(
# Paieska pagal norima paieskos tipa (0,1,2,3,4,5,6,7, 9)
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,
(Prekes.NomenklaturosNr LIKE CAST(CAST(REPLACE('%1%', ' ', '') AS BINARY) AS CHAR)) * 30 +
(Prekes.NomenklaturosNr LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 30 +
(REPLACE(Prekes.NomenklaturosNr, ' ', '') LIKE CAST(CAST(REPLACE('%1%', ' ', '') AS BINARY) AS CHAR)) * 30 +
(REPLACE(Prekes.NomenklaturosNr, ' ', '') LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 30 +
(Prekes.OrgPrekesTiekKodas LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 20 +
(REPLACE(Prekes.OrgPrekesTiekKodas, ' ', '') LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 20 +
(Prekes.Pozymis1 LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 10 +
(REPLACE(Prekes.Pozymis1, ' ', '') LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 10 +
(Prekes.Paieska LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 10
+ MATCH(Prekes.Pavadinimas, Prekes.OrgPrekesTiekKodas, Prekes.NomenklaturosNr) AGAINST(CAST(CAST(REPLACE('1* <<<1 ', '/', '') AS BINARY) AS CHAR) IN BOOLEAN MODE)
Score
FROM Prekes
LEFT JOIN PrekiuGrupes ON PrekiuGrupes.AKF = Prekes.PrekesGrupeAKF
LEFT JOIN Imones ON Imones.AKB = Prekes.Tiekejas_ID
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 1 IN (0,1,2,3,4,5,6,7, 9) AND
Prekes.Nenaudojama = 0 AND
PrekiuGrupes.RodytiWWW = 1 AND
(Prekes.NomenklaturosNr LIKE CAST(CAST(REPLACE('%1%', ' ', '') AS BINARY) AS CHAR)) * 30 +
(Prekes.NomenklaturosNr LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 30 +
(REPLACE(Prekes.NomenklaturosNr, ' ', '') LIKE CAST(CAST(REPLACE('%1%', ' ', '') AS BINARY) AS CHAR)) * 30 +
(REPLACE(Prekes.NomenklaturosNr, ' ', '') LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 30 +
(Prekes.OrgPrekesTiekKodas LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 20 +
(REPLACE(Prekes.OrgPrekesTiekKodas, ' ', '') LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 20 +
(Prekes.Pozymis1 LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 10 +
(REPLACE(Prekes.Pozymis1, ' ', '') LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 10 +
(Prekes.Paieska LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 10
+ MATCH(Prekes.Pavadinimas, Prekes.OrgPrekesTiekKodas, Prekes.NomenklaturosNr) AGAINST(CAST(CAST(REPLACE('1* <<<1 ', '/', '') AS BINARY) AS CHAR) IN BOOLEAN MODE)
> 0
HAVING Score >= 1
ORDER BY Score DESC,
Prekes.NomenklaturosNr
LIMIT 100
) AS PrekesPagalPaieska
UNION ALL
# Paieska pagal norima paieskos tipa (8)
SELECT Prekes.*,
Prekes.AKP Prekes_ID,
Imones.ImonesKodas, Imones.TruPavad, Imones.ImonesPavadinimas,
PrekiuGrupes.PrGrKodas, PrekiuGrupes.PrGrPav,
PrekiuGrupes.PagrindinesPaslaugosPrekes_ID, PrekiuGrupes.Sandeliai_ID GrupesSandeliai_ID,
PrekesPagalPaieska.Score Score
FROM
(
SELECT IF(Skaicius = 1, PirminisPrekiuSarasas.Prekes_ID, AnaloginesPrekes.PanasiosPrekes_ID) NaujasPrekes_ID,
Score + (2 - Skaicius) Score
FROM
(
# Prekiu atrinkimas
SELECT Prekes.AKP Prekes_ID,
(Prekes.NomenklaturosNr LIKE CAST(CAST(REPLACE('%1%', ' ', '') AS BINARY) AS CHAR)) * 30 +
(Prekes.NomenklaturosNr LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 30 +
(REPLACE(Prekes.NomenklaturosNr, ' ', '') LIKE CAST(CAST(REPLACE('%1%', ' ', '') AS BINARY) AS CHAR)) * 30 +
(REPLACE(Prekes.NomenklaturosNr, ' ', '') LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 30 +
(Prekes.OrgPrekesTiekKodas LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 20 +
(REPLACE(Prekes.OrgPrekesTiekKodas, ' ', '') LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 20 +
(Prekes.Pozymis1 LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 10 +
(REPLACE(Prekes.Pozymis1, ' ', '') LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 10 +
(Prekes.Paieska LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 10
+ MATCH(Prekes.Pavadinimas, Prekes.OrgPrekesTiekKodas, Prekes.NomenklaturosNr) AGAINST(CAST(CAST(REPLACE('1* <<<1 ', '/', '') AS BINARY) AS CHAR) IN BOOLEAN MODE)
Score
FROM Prekes
LEFT JOIN PrekiuGrupes ON PrekiuGrupes.AKF = Prekes.PrekesGrupeAKF
LEFT JOIN Imones ON Imones.AKB = Prekes.Tiekejas_ID
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 1 = 8 AND
Prekes.Nenaudojama = 0 AND
PrekiuGrupes.RodytiWWW = 1 AND
(Prekes.NomenklaturosNr LIKE CAST(CAST(REPLACE('%1%', ' ', '') AS BINARY) AS CHAR)) * 30 +
(Prekes.NomenklaturosNr LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 30 +
(REPLACE(Prekes.NomenklaturosNr, ' ', '') LIKE CAST(CAST(REPLACE('%1%', ' ', '') AS BINARY) AS CHAR)) * 30 +
(REPLACE(Prekes.NomenklaturosNr, ' ', '') LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 30 +
(Prekes.OrgPrekesTiekKodas LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 20 +
(REPLACE(Prekes.OrgPrekesTiekKodas, ' ', '') LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 20 +
(Prekes.Pozymis1 LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 10 +
(REPLACE(Prekes.Pozymis1, ' ', '') LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 10 +
(Prekes.Paieska LIKE CAST(CAST('%1%' AS BINARY) AS CHAR)) * 10
+ MATCH(Prekes.Pavadinimas, Prekes.OrgPrekesTiekKodas, Prekes.NomenklaturosNr) AGAINST(CAST(CAST(REPLACE('1* <<<1 ', '/', '') AS BINARY) AS CHAR) IN BOOLEAN MODE)
> 0
HAVING Score >= 1
ORDER BY Score DESC
LIMIT 100
) PirminisPrekiuSarasas
LEFT JOIN AnaloginesPrekes ON AnaloginesPrekes.Prekes_ID = PirminisPrekiuSarasas.Prekes_ID AND
0 <= 0
LEFT JOIN Skaiciai ON Skaicius <= 2
GROUP BY NaujasPrekes_ID
HAVING NaujasPrekes_ID > 0
ORDER By Score DESC
LIMIT 100
) AS PrekesPagalPaieska
LEFT JOIN Prekes ON Prekes.AKP = PrekesPagalPaieska.NaujasPrekes_ID
LEFT JOIN PrekiuGrupes ON PrekiuGrupes.AKF = Prekes.PrekesGrupeAKF
LEFT JOIN Imones ON Imones.AKB = Prekes.Tiekejas_ID
WHERE Prekes.Nenaudojama = 0 AND
PrekiuGrupes.RodytiWWW = 1
) AS AtrinktosPrekes
GROUP BY AtrinktosPrekes.Prekes_ID
) AS AtrinktosPrekes;