Artwork_sort
string(86) " ORDER BY artist.nom ASC,artist.prenom ASC,tbl_artwork.year ASC,tbl_artwork.title ASC "
sql_swipe
string(1387) "SELECT tbl_artwork.id,tbl_artwork.id_artist FROM tbl_artwork
LEFT JOIN tbl_contact as artist ON (tbl_artwork.id_artist = artist.id)
LEFT JOIN tbl_artwork_multiple ON tbl_artwork_multiple.id_artwork=tbl_artwork.id and tbl_artwork_multiple.premiere_dispo = 1
WHERE
( tbl_artwork.published = 'on' or tbl_artwork.stock = 'on' )
and tbl_artwork_multiple.premiere_dispo = 1
and ( ( tbl_artwork.custom_field_8 <= DATE(NOW()) and tbl_artwork.custom_field_8 !='0000-00-00' ) and (tbl_artwork.custom_field_9 >= DATE(NOW()) or tbl_artwork.custom_field_9 ='0000-00-00' ))
AND (( artist.prenom LIKE '%Philippe%20Druillet%' OR
artist.nom LIKE '%Philippe%20Druillet%' OR
tbl_artwork.title LIKE '%Philippe%20Druillet%' OR
tbl_artwork.year LIKE '%Philippe%20Druillet%' OR
tbl_artwork.serie LIKE '%Philippe%20Druillet%' OR
tbl_artwork.collection LIKE '%Philippe%20Druillet%' OR
tbl_artwork.dimension LIKE '%Philippe%20Druillet%' OR
tbl_artwork.dimension_en LIKE '%Philippe%20Druillet%' OR
tbl_artwork.technic LIKE '%Philippe%20Druillet%' OR
tbl_artwork.technic_en LIKE '%Philippe%20Druillet%' OR
tbl_artwork.custom_field_2 LIKE '%Philippe%20Druillet%' ) )
GROUP BY tbl_artwork.id
ORDER BY artist.nom ASC,artist.prenom ASC,tbl_artwork.year ASC,tbl_artwork.title ASC "
nb_total
int(0)
sql
string(1381) "SELECT tbl_artwork.id FROM tbl_artwork
LEFT JOIN tbl_contact as artist ON (tbl_artwork.id_artist = artist.id)
LEFT JOIN tbl_artwork_multiple ON tbl_artwork_multiple.id_artwork=tbl_artwork.id and tbl_artwork_multiple.premiere_dispo = 1
WHERE
( tbl_artwork.published = 'on' or tbl_artwork.stock = 'on' )
and tbl_artwork_multiple.premiere_dispo = 1
and ( ( tbl_artwork.custom_field_8 <= DATE(NOW()) and tbl_artwork.custom_field_8 !='0000-00-00' ) and (tbl_artwork.custom_field_9 >= DATE(NOW()) or tbl_artwork.custom_field_9 ='0000-00-00' ))
AND (( artist.prenom LIKE '%Philippe%20Druillet%' OR
artist.nom LIKE '%Philippe%20Druillet%' OR
tbl_artwork.title LIKE '%Philippe%20Druillet%' OR
tbl_artwork.year LIKE '%Philippe%20Druillet%' OR
tbl_artwork.serie LIKE '%Philippe%20Druillet%' OR
tbl_artwork.collection LIKE '%Philippe%20Druillet%' OR
tbl_artwork.dimension LIKE '%Philippe%20Druillet%' OR
tbl_artwork.dimension_en LIKE '%Philippe%20Druillet%' OR
tbl_artwork.technic LIKE '%Philippe%20Druillet%' OR
tbl_artwork.technic_en LIKE '%Philippe%20Druillet%' OR
tbl_artwork.custom_field_2 LIKE '%Philippe%20Druillet%' ) )
GROUP BY tbl_artwork.id
ORDER BY artist.nom ASC,artist.prenom ASC,tbl_artwork.year ASC,tbl_artwork.title ASC
LIMIT 0, 8"
GET
array(7) {
["lang"]=>
string(2) "fr"
["page"]=>
string(9) "recherche"
["view"]=>
string(8) "resultat"
["id"]=>
string(1) "0"
["name"]=>
string(9) "recherche"
["?paged"]=>
string(0) ""
["sq"]=>
string(19) "Philippe%20Druillet"
}
artwork_ids
NULL
Recherche :
Philippe%20Druillet
Aucune oeuvre correspondante aux critères renseignés