Resultados de Búsqueda
SELECT f.id, f.max_age, f.min_age, f.presentacion, f.sentby, f.description, f.dosis, f.indicaciones, f.sinagregado, l1.id subid, l1.name subname, l2.id catid, l2.name catname
FROM foods f
LEFT JOIN companies c on c.id = f.companyid
JOIN levels l1 on l1.id = f.categoryid
LEFT JOIN levels l2 on l2.id = l1.parentid
WHERE f.state = 1 AND (1 = 1 AND (categoryid = :cate or categoryid in (select id from levels where parentid = :cate )) AND f.min_age <= 0 AND f.max_age <= 1 AND f.companyid = 31 ) ORDER BY l2.name;
-
$ 0
Monopatín Cars Unibike...
-
$ 0
Monopatín Hotwheels Unbike...
-
$ 0
Scooter 3 Ruedas Winnie Pooh Unbike...
-
$ 0
Scooter 3 Ruedas Power Ranger Unibike...
-
$ 0
Scooter 3 Ruedas Barbie Unibike...
-
$ 0
Scooter 3 Ruedas Princesa Unibike...
-
$ 0
Scooter 3 Ruedas Hotwheel Unibike...
-
$ 0
Scooter 3 Ruedas Spiderman Unibike...
-
$ 0
Scooter 3 Ruedas Cars Unibike...
-
$ 0
Scooter 3 Ruedas Ben-10 Unbike...
-
$ 0
Scooter 3 Ruedas Hello Kitty Unbike...
-
$ 0
Scooter 3 Ruedas Mickey Unibike...
-
$ 0
Scooter 3 Ruedas Kun Fu Panda Unibike...
-
$ 0
Mono Scooter 8” Aluminio Ben-10 Unibike...
-
$ 0
Mono Scooter 8” Aluminio Hotwheels Unibike...
-
$ 0
Scooter Infantil 3 Ruedas Nano y Titi Unibike...