Domů » Vyhledávání podle technického vybavení » Nikkor AF-S 60/1:2.8 ED
SELECT
*
FROM
azael_foto f, azael_gallery g
WHERE
f.lock_foto = '0'
AND
(
f.name_foto
LIKE
'%~~~nikkor-af-s-60-128-ed~~~%'
OR
f.info_foto
LIKE
'%~~~nikkor-af-s-60-128-ed~~~%'
OR
f.keywords_foto
LIKE
'%~~~nikkor-af-s-60-128-ed~~~%'
OR
f.camera_foto
LIKE
'%~~~nikkor-af-s-60-128-ed~~~%'
OR
f.lens_foto
LIKE
'%~~~nikkor-af-s-60-128-ed~~~%'
OR
f.accessories_foto
LIKE
'%~~~nikkor-af-s-60-128-ed~~~%'
)
AND
f.public_foto = '1'
AND
f.id_gallery = g.id_gallery
AND
g.public_gallery = '1'
ORDER BY
f.rank_foto
DESC
LIMIT
16, 16