Contactez-nous: + 33 (0)3 80 27 03 58

Détails du bateau




-

vente en cours


Détails

{"data":[],"total":null,"sql":"SELECT SQL_CALC_FOUND_ROWS \n\t\t\t\t\t\t\t\t\t its.cabins,\n\t\t\t\t\t\t\t\t\t it.fr_brand,\n\t\t\t\t\t\t\t\t\t its.`Year`,\n\t\t\t\t\t\t\t\t\t it.fr_Model,\n\t\t\t\t\t\t\t\t\t it.`fr_yacht-name`,\n\t\t\t\t\t\t\t\t\t it.`fr_Length`,\n\t\t\t\t\t\t\t\t\t it.fr_LengthType,\n\t\t\t\t\t\t\t\t\t it.`fr_Type`,\n\t\t\t\t\t\t\t\t\t it.fr_City,\n\t\t\t\t\t\t\t\t\t it.fr_State,\n\t\t\t\t\t\t\t\t\t it.fr_Country,\n\t\t\t\t\t\t\t\t\t it.fr_Summary,\n\t\t\t\t\t\t\t\t\t its.`Status`,\n\t\t\t\t\t\t\t\t\t it.fr_Price,\n\t\t\t\t\t\t\t\t\t it.fr_PriceType,\n\t\t\t\t\t\t\t\t\t u.company,\n\t\t\t\t\t\t\t\t\t its.user_id,\n\t\t\t\t\t\t\t\t\t c.name,\n\t\t\t\t\t\t\t\t\t it.item_id,\n\t\t\t\t \t\t\t\t\t its.url FROM (\n\t\t\t\t\t\t\t\t\t\tSELECT image, max(item_id) AS item_id\n\t\t\t\t\t\t\t\t\t\tFROM item_images GROUP BY item_id\n\t\t\t\t\t\t\t\t\t\t) img\n\t\t\t\t\t\t\t\t\t\tINNER JOIN items its ON its.id = img.item_id\n\t\t\t\t\t\t\t\t\t\tINNER JOIN fr_items it ON it.item_id = its.id\n\t\t\t\t\t\t\t\t\t\tINNER JOIN user u ON its.user_id = u.id\n\t\t\t\t\t\t\t\t\t\tINNER JOIN companies c ON u.company = c.id\n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t(its.id = it.item_id) AND \n\t\t\t\t\t\t\t\t\t\t(it.fr_Length BETWEEN AND ) AND\n\t\t\t\t\t\t\t\t\t\t(its.year BETWEEN AND ) AND\n\t\t\t\t\t\t\t\t\t\t(it.fr_price BETWEEN AND ) AND\n\t\t\t\t\t\t\t\t\t\tit.fr_state LIKE '' AND\n\t\t\t\t\t\t\t\t\t\tit.fr_country LIKE '' AND\n\t\t\t\t\t\t\t\t\t\tits.allowcobroker LIKE '' AND 1 AND 1 AND 1 AND 1 AND 1 AND 1 AND 1 AND 1 AND 1 ORDER BY LIMIT , ","filters":{"fr_brand":[],"cabins":[],"fr_Category":[],"fr_Type":[],"fr_State":[""],"fr_Country":[""]}}

Romuald Leblanc

Email: romuald.leblanc@leboat.com