select cruise.* ,(select Img from cruise_imgs where Cruise = cruise.Id limit 0,1 ) as Thum from cruise where Active=0 and Id!= order by rand() limit 0,4
Mysql Error Number 1064
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 'order by rand() limit 0,4' at line 1