Domů » Vyhledávání podle technického vybavení » NIKON D7000
SELECT
*
FROM
azael_foto f, azael_gallery g
WHERE
f.lock_foto = '0'
AND
(
f.name_foto
LIKE
'%~~~nikon-d7000~~~%'
OR
f.info_foto
LIKE
'%~~~nikon-d7000~~~%'
OR
f.keywords_foto
LIKE
'%~~~nikon-d7000~~~%'
OR
f.camera_foto
LIKE
'%~~~nikon-d7000~~~%'
OR
f.lens_foto
LIKE
'%~~~nikon-d7000~~~%'
OR
f.accessories_foto
LIKE
'%~~~nikon-d7000~~~%'
)
AND
f.public_foto = '1'
AND
f.id_gallery = g.id_gallery
AND
g.public_gallery = '1'
ORDER BY
f.rank_foto
DESC
LIMIT
80, 16