POST
NULL
GET
array(9) {
["lang"]=>
string(2) "en"
["page"]=>
string(8) "editions"
["view"]=>
string(5) "liste"
["id"]=>
string(1) "0"
["name"]=>
string(0) ""
["?paged"]=>
string(0) ""
["paged"]=>
string(1) "4"
["sort_artwork"]=>
string(10) "artist_ASC"
["firstletter"]=>
string(0) ""
}
Artwork_sort
string(86) " ORDER BY artist.nom ASC,artist.prenom ASC,tbl_artwork.year ASC,tbl_artwork.title ASC "
exhib_search
string(0) ""
openFilter
bool(false)
artwork_ids
array(190) {
[0]=>
string(3) "173"
[1]=>
string(3) "172"
[2]=>
string(3) "171"
[3]=>
string(1) "6"
[4]=>
string(3) "182"
[5]=>
string(3) "184"
[6]=>
string(3) "183"
[7]=>
string(3) "185"
[8]=>
string(3) "186"
[9]=>
string(3) "181"
[10]=>
string(3) "187"
[11]=>
string(3) "471"
[12]=>
string(1) "7"
[13]=>
string(3) "286"
[14]=>
string(2) "93"
[15]=>
string(2) "91"
[16]=>
string(2) "95"
[17]=>
string(2) "92"
[18]=>
string(2) "94"
[19]=>
string(1) "9"
[20]=>
string(2) "79"
[21]=>
string(2) "12"
[22]=>
string(3) "175"
[23]=>
string(3) "255"
[24]=>
string(2) "10"
[25]=>
string(2) "11"
[26]=>
string(2) "15"
[27]=>
string(3) "337"
[28]=>
string(2) "16"
[29]=>
string(2) "18"
[30]=>
string(2) "17"
[31]=>
string(2) "19"
[32]=>
string(2) "20"
[33]=>
string(2) "60"
[34]=>
string(2) "83"
[35]=>
string(3) "123"
[36]=>
string(3) "120"
[37]=>
string(3) "122"
[38]=>
string(3) "121"
[39]=>
string(3) "119"
[40]=>
string(2) "21"
[41]=>
string(2) "23"
[42]=>
string(2) "22"
[43]=>
string(3) "339"
[44]=>
string(3) "395"
[45]=>
string(3) "392"
[46]=>
string(3) "394"
[47]=>
string(3) "393"
[48]=>
string(3) "513"
[49]=>
string(3) "668"
[50]=>
string(3) "667"
[51]=>
string(2) "42"
[52]=>
string(2) "46"
[53]=>
string(3) "493"
[54]=>
string(3) "499"
[55]=>
string(3) "503"
[56]=>
string(2) "48"
[57]=>
string(3) "501"
[58]=>
string(3) "124"
[59]=>
string(3) "128"
[60]=>
string(3) "129"
[61]=>
string(3) "130"
[62]=>
string(3) "131"
[63]=>
string(3) "125"
[64]=>
string(3) "126"
[65]=>
string(3) "127"
[66]=>
string(2) "49"
[67]=>
string(3) "192"
[68]=>
string(3) "188"
[69]=>
string(3) "562"
[70]=>
string(2) "24"
[71]=>
string(2) "26"
[72]=>
string(2) "50"
[73]=>
string(2) "51"
[74]=>
string(2) "81"
[75]=>
string(2) "52"
[76]=>
string(3) "307"
[77]=>
string(3) "306"
[78]=>
string(2) "74"
[79]=>
string(2) "53"
[80]=>
string(2) "54"
[81]=>
string(3) "222"
[82]=>
string(3) "309"
[83]=>
string(2) "55"
[84]=>
string(2) "57"
[85]=>
string(2) "58"
[86]=>
string(3) "176"
[87]=>
string(2) "76"
[88]=>
string(2) "75"
[89]=>
string(3) "284"
[90]=>
string(3) "145"
[91]=>
string(3) "568"
[92]=>
string(2) "72"
[93]=>
string(2) "73"
[94]=>
string(3) "376"
[95]=>
string(3) "235"
[96]=>
string(3) "249"
[97]=>
string(3) "250"
[98]=>
string(3) "301"
[99]=>
string(3) "246"
[100]=>
string(2) "59"
[101]=>
string(3) "398"
[102]=>
string(2) "78"
[103]=>
string(2) "82"
[104]=>
string(3) "338"
[105]=>
string(3) "564"
[106]=>
string(2) "30"
[107]=>
string(2) "31"
[108]=>
string(2) "29"
[109]=>
string(2) "27"
[110]=>
string(3) "329"
[111]=>
string(3) "289"
[112]=>
string(2) "84"
[113]=>
string(2) "32"
[114]=>
string(2) "33"
[115]=>
string(3) "436"
[116]=>
string(3) "252"
[117]=>
string(3) "194"
[118]=>
string(2) "35"
[119]=>
string(2) "36"
[120]=>
string(2) "39"
[121]=>
string(2) "37"
[122]=>
string(2) "38"
[123]=>
string(2) "56"
[124]=>
string(2) "61"
[125]=>
string(2) "62"
[126]=>
string(2) "41"
[127]=>
string(2) "63"
[128]=>
string(2) "98"
[129]=>
string(3) "108"
[130]=>
string(3) "112"
[131]=>
string(3) "105"
[132]=>
string(2) "99"
[133]=>
string(2) "64"
[134]=>
string(3) "101"
[135]=>
string(2) "65"
[136]=>
string(2) "66"
[137]=>
string(3) "396"
[138]=>
string(3) "386"
[139]=>
string(3) "390"
[140]=>
string(3) "387"
[141]=>
string(3) "388"
[142]=>
string(3) "389"
[143]=>
string(3) "335"
[144]=>
string(3) "593"
[145]=>
string(3) "586"
[146]=>
string(3) "587"
[147]=>
string(3) "589"
[148]=>
string(3) "585"
[149]=>
string(3) "590"
[150]=>
string(3) "534"
[151]=>
string(3) "512"
[152]=>
string(3) "294"
[153]=>
string(3) "292"
[154]=>
string(3) "290"
[155]=>
string(2) "87"
[156]=>
string(2) "85"
[157]=>
string(2) "86"
[158]=>
string(2) "89"
[159]=>
string(3) "505"
[160]=>
string(3) "203"
[161]=>
string(3) "202"
[162]=>
string(3) "201"
[163]=>
string(3) "204"
[164]=>
string(2) "67"
[165]=>
string(2) "68"
[166]=>
string(3) "154"
[167]=>
string(3) "156"
[168]=>
string(3) "155"
[169]=>
string(2) "69"
[170]=>
string(3) "538"
[171]=>
string(2) "71"
[172]=>
string(3) "545"
[173]=>
string(3) "547"
[174]=>
string(3) "543"
[175]=>
string(3) "546"
[176]=>
string(3) "548"
[177]=>
string(3) "304"
[178]=>
string(3) "166"
[179]=>
string(3) "302"
[180]=>
string(3) "168"
[181]=>
string(3) "167"
[182]=>
string(3) "200"
[183]=>
string(3) "199"
[184]=>
string(2) "80"
[185]=>
string(2) "44"
[186]=>
string(3) "146"
[187]=>
string(3) "456"
[188]=>
string(3) "421"
[189]=>
string(3) "515"
}
sql_swipe
string(459) "SELECT DISTINCT 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.stock='on' AND tbl_artwork.type !='artwork' AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY artist.nom ASC,artist.prenom ASC,tbl_artwork.year ASC,tbl_artwork.title ASC "
nb_total
string(3) "190"
sql
string(472) "SELECT DISTINCT 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.stock='on' AND tbl_artwork.type !='artwork' AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY artist.nom ASC,artist.prenom ASC,tbl_artwork.year ASC,tbl_artwork.title ASC LIMIT 30, 10"
Advanced filter
en