Error SQL: 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 'AND producto_usado_portal_publicacion.id_portal = 227 AND produc' at line 28 Línea: 23 de archivo /home/rramirez/proyectos/enlace_portal_usados/fw/classes/Lista.php Query: SELECT SQL_CALC_FOUND_ROWS producto_usado.*, prm_comuna.glosa_comuna, producto_usado.glosa_producto, producto_usado.id_gestor_inmobiliario, prm_tipo_casa.glosa_tipo_casa, producto_usado.id_tipo_casa, producto_usado.precio AS precio_minimo, producto_usado.dormitorios AS num_dormitorios, producto_usado.mt2, producto_usado.mt2_ter, empresa.imagen_logo, empresa.glosa_empresa, producto_usado.id_geo_cuadrante, producto_usado_portal_publicacion.id_tipo_pago AS tipo_pago, IF(producto_usado.oferta =1 OR producto_usado.destacado=1,2,1) AS grupo_etiquetas, imagen_producto_usado.nombre AS imagen_frontis FROM producto_usado LEFT JOIN empresa ON producto_usado.id_gestor_inmobiliario = empresa.id_empresa JOIN producto_usado_portal_publicacion ON producto_usado_portal_publicacion.id_producto_usado = producto_usado.id_producto_usado LEFT JOIN prm_tipo_casa ON prm_tipo_casa.id_tipo_casa = producto_usado.id_tipo_casa LEFT JOIN prm_comuna ON prm_comuna.id_comuna = producto_usado.id_comuna LEFT JOIN imagen_producto_usado ON (imagen_producto_usado.id_producto_usado = producto_usado.id_producto_usado AND imagen_producto_usado.n_imagen = 1) WHERE AND producto_usado_portal_publicacion.id_portal = 227 AND producto_usado_portal_publicacion.publicado = 1 AND producto_usado.activo = 1 AND producto_usado.precio >= 100 AND producto_usado.precio <= 99999 AND producto_usado.id_producto_usado NOT IN (2454,6129,6130,6131,6132,6133,6135,6136,6137,6142,6143,6155,6156,6157,6158,6159,6163,6164,6167,6168,6171,6172,6174,6177,6178,6179,6181,6183,6185,6187,6194,6195,6196,6198,6200,6201,6202,6203,6207,6208,6211,6216,6221,6222,6223,6224,6225,6237,6239,6240,6241,6243,6248,6250,6251,6252,6253,6255,6257,6259,6264,6265,6271,6273,6274,6275,6277,6278,6280,6283,6290,6295,6296,6298,6304,6305,6306,6307,6308,6309,6310,6312,6313,6314,6315,6316,6317,6320,6321,6322,6323,6324,6325,6326,6327,6328,6329,6330,6331,6332,6333,6334,6336,6337,6338,6339,6341,6342,6345,6347,6350,6351,6352,6356,6357,6358,6361,6364,6365,6367,6368,6370,6371,6372,6373,6374,6375,6376,6378,6379,6380,6385,6386,6387,6389,6390,6392,6393,6396,6397,6399,6412,6414,6415,6417,6418,6420,6421,6422,6423,6424,6426,6427,6433,6434,6446,6448,6449,6451,6452,6458,6459,6460,6462,6463,6464,6465,6466,6467,6468,6469,6471,6472,6473,6474,6475,6477,6479,6480,6481,6485,6487,6488,6489,6493,6494,6496,6497,6502,6507,6509,6511,6512,6513,6514,6519,6521,6522,6523,6524,6526,6528,6529,6534,6537,6538,6541,6542,6543,6544,6546,6551,6552,6554,6556,6557,6558,6559,6560,6561,6562,6564,6565,6566,6567,6569,6572,6574,6575,6578,6579,6580,6582,6585,6587,6588,6589,6591,6592,8336,8337,8338,8339,8343,8344,8345,8346,8347,8348,8350,8351,8352,8366,8367,8368,8370,8372,8521,8522,8523,8525,8526,8527,8528,8529,8532,8533,8534,8797,8798,8799,8800,8801,8804,8806,8807,8808,8809,8810,8811,8813,8814,8816,8817,8818,8820,8822,8982,8985,8986,8987,8988,8989,8990,8991,9091,9093,9094,9095,9096,9097,9098,9099,9100,9103,9104,9161,9162,9163,9164,9165,9166,9167,9406,9407,9408,9410,9413,9415,9622,9623,9632,9639,9640,9641,9642,9643,9644,9645,9646,9647,9648,9649,9650,9651,9652,9653,9654,9655,9656,9658,9659,9660,9661,9662,9663,9664,9665,9666,9719,9721,9722,9723,9724,9726,9727,9896,9897,9900,9901,9903,9904,9905,9906,9907,9908,9958,9959,9960,10005,10006,10008,10010,10108,10109,10111,10140,10196,10198,10199,10200,10284,10285,10286,10287,10495,10507,10508,10509,10510,10511,10513,10514,10585,10587,10763,10764,10765,10766,10805,10806,10807,10808,10888,10892,10894,10895,10896,10897,10901,10986,10988,10989,10990,17694,17695,17696,17697,20573,20574,20576,20577,20579,20580,20582,20583,20589,20592,20594,20596,20599,20601,20606,20610,20611,20614,20616,20622,20623,20627,20628,20630,20631,20632,20633,20634,20636,20637,20639,20641,20642,20643,20646,20650,20651,20652,20653,20659,20660,20661,20663,20664,20667,20669,20670,20671,20672,20673,20674,20676,20679,20680,20681,20682,20683,20687,20688,20692,20693,20694,20698,20699,20702,20704,20706,20707,20708,20712,20714,20717,20722,20723,20724,20726,20731,20733,20735,20749,20750,20751,20752,20753,20754,20757,20760,20761,20762,20765,20766,20767,20768,20769,20771,20773,20774,20775,20776,20777,20780,20781,20782,20784,20786,20788,20789) GROUP BY producto_usado.id_producto_usado ORDER BY grupo_etiquetas DESC, tipo_pago DESC, LIMIT 0, 15