SQL:select ads.orderno, ads.display_time, ads.photo,
ads.title,ads.description, ads.created,ads.url,
ads.created,ads.add_type_id, payment_detail.paymentby as paymentby
from advertisements as ads
join ads_payment_detail as payment_detail on (ads.orderno = payment_detail.orderno)
where status = 'Completed'
group by rand() |