SELECT id_categorie as ID FROM categories WHERE slug = :slug
array(1) { ["slug"]=> string(9) "motoneige" }SELECT a.id_parent,b.slug FROM categories a inner join categories b on a.id_parent = b.id_categorie WHERE a.id_categorie = :id_category
array(1) { ["id_category"]=> string(2) "12" }SELECT nom FROM categories WHERE slug = :slug
array(1) { ["slug"]=> string(9) "motoneige" }SELECT id_marque AS ID FROM vehicules_marques WHERE slug = :slug
array(1) { ["slug"]=> string(7) "ski-doo" }SELECT marque AS nom FROM vehicules_marques WHERE slug = :slug
array(1) { ["slug"]=> string(7) "ski-doo" }SELECT id_modele AS ID FROM vehicules_modeles WHERE slug = :slug
array(1) { ["slug"]=> string(29) "ski-doo-freeride-154-800-etec" }SELECT modele AS nom FROM vehicules_modeles WHERE slug = :slug
array(1) { ["slug"]=> string(29) "ski-doo-freeride-154-800-etec" }CALL SP_SEARCH_VEHICLES_PREMIUM( :category, :subcategorie, :make, :model, :province, :region, :ville, :priceMin, :priceMax, :minYear, :maxYear, :minMileage, :maxMileage, :sort, :order, :start, :per_page, :status, :dealer )
array(19) { ["category"]=> string(2) "12" ["subcategorie"]=> string(4) "Tous" ["make"]=> string(4) "1718" ["model"]=> string(4) "3008" ["province"]=> string(4) "Tous" ["region"]=> string(4) "Tous" ["ville"]=> string(4) "Tous" ["priceMin"]=> string(4) "Tous" ["priceMax"]=> string(4) "Tous" ["minYear"]=> string(4) "Tous" ["maxYear"]=> string(4) "Tous" ["minMileage"]=> string(4) "Tous" ["maxMileage"]=> string(4) "Tous" ["sort"]=> string(7) "annonce" ["order"]=> string(4) "desc" ["start"]=> int(0) ["per_page"]=> int(3) ["status"]=> string(4) "Tous" ["dealer"]=> string(4) "Tous" }CALL SP_SEARCH_VEHICLES_2( :category, :subcategorie, :make, :model, :province, :region, :ville, :priceMin, :priceMax, :minYear, :maxYear, :minMileage, :maxMileage, :sort, :order, :start, :per_page, :status, :dealer )
array(19) { ["category"]=> string(2) "12" ["subcategorie"]=> string(4) "Tous" ["make"]=> string(4) "1718" ["model"]=> string(4) "3008" ["province"]=> string(4) "Tous" ["region"]=> string(4) "Tous" ["ville"]=> string(4) "Tous" ["priceMin"]=> string(4) "Tous" ["priceMax"]=> string(4) "Tous" ["minYear"]=> string(4) "Tous" ["maxYear"]=> string(4) "Tous" ["minMileage"]=> string(4) "Tous" ["maxMileage"]=> string(4) "Tous" ["sort"]=> string(7) "annonce" ["order"]=> string(4) "desc" ["start"]=> int(0) ["per_page"]=> string(2) "10" ["status"]=> string(4) "Tous" ["dealer"]=> string(4) "Tous" }init ->SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'Tous' for column 'V_STATUS' at row 1