|
|
select distinct bikes_motor.id,bikes_motor.title,bikes_motor.price,
bikes_category.name,bikes_motor.des,
bikes_motor.model, bikes_make.name, bikes_motor.status
from bikes_motor,bikes_category, bikes_make where bikes_make.id = bikes_motor.make and bikes_motor.price > 0 and bikes_category.id = bikes_motor.cat and bikes_motor.id != '0' and active = 'y' group by bikes_motor.id |
|
Displaying 1 - 10 of 35 Scooters | Page : [ 1 ] 2 3 4 Next |
|
|
|
Displaying 1 - 10 of 35 Scooters | Page : [ 1 ] 2 3 4 Next |
| |
|