|
SELECT
o.obqva_id AS o_id,
oo.ime AS o_ime,
img.img_id AS i_id,
img.ifile AS ifile,
img.width_sr AS iw,
img.height_sr AS ih,
img.width_th AS itw,
img.height_th AS ith,
sp.selishte_id,
sp.ime,
oo.opis_txt AS o_descr,
o.tip_id AS o_tip,
ooe.ime AS e_ime,
ooe.opis_txt AS e_descr,
o.cena AS o_c,
o.cena_ot AS o_co,
o.cena_zakvm AS o_ckvm,
o.cena_otdo AS o_cotdo,
v.akronim AS v_akr,
o.text_id AS o_tid,
o.kvadratura AS o_k,
o.kvadratura_min AS o_km,
o.valuta_id AS o_valuta,
oo.url AS o_url,
o.aktivnost AS o_akt
FROM
obqva o
LEFT JOIN
obqva_opisanie oo
ON o.obqva_id=oo.obqva_id AND oo.ezik_id=1
LEFT JOIN
obqva_opisanie ooe
ON o.obqva_id=ooe.obqva_id AND ooe.ezik_id=2
LEFT JOIN
obqva_img oi
ON o.obqva_id = oi.obqva_id AND oi.red = 1
LEFT JOIN
img img
ON oi.img_id = img.img_id
LEFT JOIN
obqva_selishte os ON os.obqva_id = o.obqva_id
LEFT JOIN
selishte s
ON s.selishte_id = os.selishte_id
LEFT JOIN
selishte sup
ON s.selishte_up_id = sup.selishte_id
LEFT JOIN
obqva_imot oim
ON oim.obqva_id = o.obqva_id
LEFT JOIN
selishte_prevod sp
ON s.selishte_id = sp.selishte_id AND sp.ezik_id = 1
LEFT JOIN
valuta v
ON o.valuta_id=v.valuta_id
WHERE
o.publikuvaj = 1 AND s.selishte_id IN (1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,5711,5712,1087,1088,1089,1090,1091,1092,1093,1094,1095,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,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,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,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,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,5686,5689,5690,5699,5701,5707,5713,5714,5715,5716,5717,5718,5719,5720,5721,5722,5723,5724,5725,1068) AND oim.imot_id IN (53,54,55,56,57,58,59,60,61,62,63,76,64,65,66,67,68,69,70,52) AND o.tip_id = 1 ORDER BY o.aktivnost, o.data_aktualizaciq DESC
#1030 - Got error 28 from storage engine
|
