consulta fulltext con case y left join da error

[TutexMdz]

Hola Gente, estoy intentando armar un buscador con un indice de tabla por primera vez.

este es el codigo SQL que intento que funcione y me da error. ya indicé la tabla en cuestión si alguien sabe donde esta el problema se lo agradezco desde ya

Código MySQL:

SELECT p.*,
    c.name as name_category,
    t.name as name_type,
    cy.name as name_country,
    s.name as name_state,
    l.name as name_locality,
    pf.usertype as usertype_profile,
    pf.name as name_profile,
    pf.logo_image as logo_image_profile,
    CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as Pslug,
    CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as Cslug,
    CASE WHEN CHAR_LENGTH(cy.alias) THEN CONCAT_WS(":", cy.id, cy.alias) ELSE cy.id END as CYslug,
    CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END as Sslug,
    CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(":", l.id, l.alias) ELSE l.id END as Lslug,
    CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(":", t.id, t.alias) ELSE t.id END as Tslug,
    CASE WHEN CHAR_LENGTH(pf.alias) THEN CONCAT_WS(":", pf.mid, pf.alias) ELSE pf.mid END as Uslug,
    MATCH ( name, description ) AGAINST ( lote venta ) as Score 
    FROM tab_productos_products AS p 
    LEFT JOIN tab_productos_country AS cy ON cy.id = p.cyid 
    LEFT JOIN tab_productos_state AS s ON s.id = p.sid 
    LEFT JOIN tab_productos_locality AS l ON l.id = p.lid 
    LEFT JOIN tab_productos_profiles AS pf ON pf.mid = p.agent_id 
    LEFT JOIN tab_productos_category AS c ON c.id = p.cid 
    LEFT JOIN tab_productos_type AS t ON t.id = p.type 
    MATCH ( name, description ) AGAINST ( lote venta ) 
    WHERE p.published = 1 
    ORDER BY p.featured DESC, p.listdate DESC, p.id DESC 
    LIMIT 0, 10
 

el error que tira es este:

No valid database connection 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 'venta ) as Score FROM tab_productos_products AS p LEFT JOIN alq_properties_cou' at line 5

Gracias