SELECT *
FROM jos_session
WHERE session_id = '26b03f2a94aa3c71ca3e2968638ef689'
DELETE
FROM jos_session
WHERE ( TIME < '1686028277' )
SELECT *
FROM jos_session
WHERE session_id = '26b03f2a94aa3c71ca3e2968638ef689'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '26b03f2a94aa3c71ca3e2968638ef689','1686031877','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM jos_joomgallery_config
WHERE id = 0
SELECT
uid,
uuserid,
zipname
FROM
jos_joomgallery_users
WHERE
zipname != ''
AND TIME != ''
AND TIME < NOW()-INTERVAL 60 SECOND
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 16 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT
COUNT(cid)
FROM
jos_joomgallery_catg
WHERE
published = '1'
AND parent='0'
AND access <= '0'
SELECT
*
FROM
jos_joomgallery_catg
WHERE
published = '1'
AND parent = 0
AND access<= '0'
ORDER BY
ordering
LIMIT 0,12
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (446)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (446)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (449,450,451,452,453,511,601,669)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (449,450,451,452,453,511,601,669)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (454,132,81,83,457,456,459,458,28,41,460,461,462,464,463,465,466,467,468,287,469,470,471,472,473,475,474,476,477,478,479,482,494,512,517,526,531,542,556,563,581,602,620,618,629,648,644,657,670,675,688,692,696)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (454,132,81,83,457,456,459,458,28,41,460,461,462,464,463,465,466,467,468,287,469,470,471,472,473,475,474,476,477,478,479,482,494,512,517,526,531,542,556,563,581,602,620,618,629,648,644,657,670,675,688,692,696)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (116,655,652,29,30,288,290,40,118,69,87,72,122,90,89,45,134,138,142,147,150,158,163,164,207,205,208,215,216,219,235,227,226,223,237,238,240,259,267,272,274,273,284,294,298,305,299,307,312,309,308,314,315,319,326,323,327,330,333,335,340,336,342,343,344,345,346,651,351,347,359,357,360,361,365,367,373,375,377,376,379,384,382,390,398,414,425,436,437,438,439,483,488,489,495,496,497,516,513,523,518,527,534,533,537,536,535,538,539,543,544,545,546,547,650,550,551,552,557,558,559,562,564,565,567,566,568,569,582,649,583,603,605,619,621,631,630,633,632,645,634,638,82,84,658,671,676,689,690,691,693,697,698,699)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (116,655,652,29,30,288,290,40,118,69,87,72,122,90,89,45,134,138,142,147,150,158,163,164,207,205,208,215,216,219,235,227,226,223,237,238,240,259,267,272,274,273,284,294,298,305,299,307,312,309,308,314,315,319,326,323,327,330,333,335,340,336,342,343,344,345,346,651,351,347,359,357,360,361,365,367,373,375,377,376,379,384,382,390,398,414,425,436,437,438,439,483,488,489,495,496,497,516,513,523,518,527,534,533,537,536,535,538,539,543,544,545,546,547,650,550,551,552,557,558,559,562,564,565,567,566,568,569,582,649,583,603,605,619,621,631,630,633,632,645,634,638,82,84,658,671,676,689,690,691,693,697,698,699)
AND access <= 0
AND published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=446
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=449
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=450
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=451
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=452
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=453
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=511
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=601
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=669
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=454
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=132
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=81
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=83
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=457
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=456
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=459
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=458
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=28
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=41
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=460
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=461
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=462
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=464
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=463
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=465
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=466
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=467
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=468
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=287
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=469
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=470
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=471
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=472
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=473
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=475
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=474
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=476
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=477
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=478
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=479
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=482
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=494
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=512
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=517
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=526
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=531
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=542
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=556
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=563
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=581
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=602
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=620
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=618
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=629
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=648
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=644
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=657
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=670
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=675
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=688
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=692
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=696
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=118
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=116
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=82
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=84
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=72
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=69
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=87
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=45
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=122
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=90
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=89
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=29
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=30
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=40
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=134
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=138
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=142
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=147
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=150
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=158
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=163
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=164
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=207
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=205
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=208
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=215
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=216
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=219
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=259
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=235
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=227
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=226
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=223
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=237
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=238
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=240
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=267
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=272
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=274
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=273
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=284
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=294
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=288
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=290
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=298
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=305
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=299
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=307
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=312
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=309
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=308
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=314
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=315
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=319
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=326
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=323
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=327
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=330
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=333
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=335
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=340
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=336
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=342
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=343
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=344
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=345
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=346
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=351
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=347
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=359
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=357
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=360
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=361
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=365
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=367
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=390
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=373
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=375
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=377
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=376
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=379
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=384
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=382
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=398
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=414
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=425
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=436
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=437
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=438
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=439
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=483
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=488
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=489
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=495
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=496
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=497
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=516
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=513
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=523
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=518
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=527
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=534
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=533
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=537
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=536
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=535
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=538
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=539
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=543
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=544
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=545
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=546
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=547
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=550
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=551
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=552
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=557
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=558
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=559
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=562
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=564
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=565
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=567
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=566
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=568
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=569
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=582
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=583
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=603
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=605
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=621
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=619
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=631
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=630
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=633
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=632
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=634
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=638
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=655
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=652
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=651
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=650
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=649
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=645
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=658
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=671
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=676
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=689
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=690
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=691
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=693
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=697
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=698
AND published=1
SELECT cid
FROM jos_joomgallery_catg
WHERE parent=699
AND published=1
SELECT COUNT(id) AS COUNT
FROM jos_joomgallery
WHERE published = 1
AND approved = 1
AND catid IN (446,449,450,451,452,453,511,601,669,454,132,81,83,457,456,459,458,28,41,460,461,462,464,463,465,466,467,468,287,469,470,471,472,473,475,474,476,477,478,479,482,494,512,517,526,531,542,556,563,581,602,620,618,629,648,644,657,670,675,688,692,696,118,116,82,84,72,69,87,45,122,90,89,29,30,40,134,138,142,147,150,158,163,164,207,205,208,215,216,219,259,235,227,226,223,237,238,240,267,272,274,273,284,294,288,290,298,305,299,307,312,309,308,314,315,319,326,323,327,330,333,335,340,336,342,343,344,345,346,351,347,359,357,360,361,365,367,390,373,375,377,376,379,384,382,398,414,425,436,437,438,439,483,488,489,495,496,497,516,513,523,518,527,534,533,537,536,535,538,539,543,544,545,546,547,550,551,552,557,558,559,562,564,565,567,566,568,569,582,583,603,605,621,619,631,630,633,632,634,638,655,652,651,650,649,645,658,671,676,689,690,691,693,697,698,699)
SELECT ca.cid,ca.parent,IFNULL(COUNT(p.id),0) AS piccount
FROM jos_joomgallery_catg AS ca
LEFT JOIN jos_joomgallery AS p
ON p.catid = ca.cid
WHERE ca.published = '1'
AND ca.access <= '0'
AND (isnull(p.published) OR p.published=1)
AND (isnull(p.approved) OR p.approved=1)
/* unpublished approved picture for category, only working with own coice */
OR ((isnull(p.published) OR p.published=0)
AND (isnull(p.approved) OR p.approved=1))
GROUP BY ca.cid
ORDER BY CAST(parent AS UNSIGNED)
SELECT
*,
c.access
FROM
jos_joomgallery AS p
LEFT JOIN
jos_joomgallery_catg AS c
ON c.cid = p.catid
WHERE
p.catid = 346
AND p.published = '1'
AND p.approved='1'
AND c.access <= 0
AND c.published = '1'
ORDER BY
rand()
LIMIT 1
SELECT
cid,
name,
parent,
access
FROM
jos_joomgallery_catg
WHERE
published = '1'
ORDER BY
parent ASC,
name ASC
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (449)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (449)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (454,132)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (454,132)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (116,118)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (116,118)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (450)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (450)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (81,83,457,456,459,458)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (81,83,457,456,459,458)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (82,84,69,87,72,122,90,89,45)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (82,84,69,87,72,122,90,89,45)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (451)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (451)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (28,41,460,461,462,464,463,465,466)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (28,41,460,461,462,464,463,465,466)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (29,30,40,134,138,142,147,150,158,163,164,207,205,208,215,216,219,235,227,226,223,237,238,240,259,267,272,274,273)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (29,30,40,134,138,142,147,150,158,163,164,207,205,208,215,216,219,235,227,226,223,237,238,240,259,267,272,274,273)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (452)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (452)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (467,468,287,469,470,471,472,473,475,474,476)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (467,468,287,469,470,471,472,473,475,474,476)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (288,290,284,294,298,305,299,307,312,309,308,314,315,319,326,323,327,330,333,335,340,336,342,343,344,345,346,351,347,359,357,360,361,365,367,373,375,377,376,379,384,382,390,398)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (288,290,284,294,298,305,299,307,312,309,308,314,315,319,326,323,327,330,333,335,340,336,342,343,344,345,346,351,347,359,357,360,361,365,367,373,375,377,376,379,384,382,390,398)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (453)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (453)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (477,478,479,482,494)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (477,478,479,482,494)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (414,425,436,437,438,439,483,488,489,495,496,497)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (414,425,436,437,438,439,483,488,489,495,496,497)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (511)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (511)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (512,517,526,531,542,556,563,581)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (512,517,526,531,542,556,563,581)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (516,513,523,518,527,534,533,537,536,535,538,539,543,544,545,546,547,550,551,552,557,558,559,562,564,565,567,566,568,569,582,583)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (516,513,523,518,527,534,533,537,536,535,538,539,543,544,545,546,547,550,551,552,557,558,559,562,564,565,567,566,568,569,582,583)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (601)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (601)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (602,620,618,629,648,644,657)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (602,620,618,629,648,644,657)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (603,605,619,621,631,630,633,632,634,638,645,655,652,651,650,649,658)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (603,605,619,621,631,630,633,632,634,638,645,655,652,651,650,649,658)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (669)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (669)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (670,675,688,692,696)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (670,675,688,692,696)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (671,676,689,690,691,693,697,698,699)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (671,676,689,690,691,693,697,698,699)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (132)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (132)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (116)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (116)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (454)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (454)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (118)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (118)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (458)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (458)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (122,90,89)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (122,90,89)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (459)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (459)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (45)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (45)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (81)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (81)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (82)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (82)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (457)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (457)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (72)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (72)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (456)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (456)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (69,87)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (69,87)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (83)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (83)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (84)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (84)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (460)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (460)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (134,138,142)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (134,138,142)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (463)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (463)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (235,227,226,223,237,238,240)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (235,227,226,223,237,238,240)
AND access <= 0
AND published = '1'
SELECT MAX(imgdate)
FROM jos_joomgallery AS a
LEFT JOIN jos_joomgallery_catg AS c
ON c.cid=a.catid
WHERE a.catid IN (466)
AND a.published = '1'
AND a.approved='1'
AND c.access <= 0
AND c.published = '1'
SELECT cid
FROM jos_joomgallery_catg
WHERE parent IN (
